Home Database Mysql Tutorial Eclipse(myeclipse)连接SQL Server 2008数据库

Eclipse(myeclipse)连接SQL Server 2008数据库

Jun 07, 2016 pm 03:41 PM
eclipse myeclipse sql connect

在连接数据库之前必须保证SQL Server 2008是采用SQL Server身份验证方式而不是windows身份验证方式。如果在安装时选用了后者,则重新设置如下: http://blog.163.com/jackie_howe/blog/static/19949134720122261121214/ SQL Server 2008装好后,默认协议是没

在连接数据库之前必须保证SQL Server 2008是采用SQL Server身份验证方式而不是windows身份验证方式。如果在安装时选用了后者,则重新设置如下:

http://blog.163.com/jackie_howe/blog/static/19949134720122261121214/

SQL Server 2008装好后,默认协议是没有开启的,可打开配置工具下的 SQL Server配置管理器中开启,如下2图:

保证SQL Server 2008是采用SQL Server身份验证方式下开始配置:

一、SQL Server 2008的配置:

1、安装好SQL Server 2008后,运行 开始 → 所有程序 → Microsoft SQL Server 2008 → 配置工具 → SQL Server配置管理器,在打开的窗口的左边找到 MSSQLSERVER的协议,在右边右单击 TCP/IP,选择 已启用。如果Named Pipes 未启用也设为启用。如图5所示:

Eclipse(myeclipse)连接SQL Server 2008数据库

Eclipse(myeclipse)连接SQL Server 2008数据库

图5

Eclipse(myeclipse)连接SQL Server 2008数据库

图6

4、然后重启数据库,重启完毕后,接下来使用命令测试1433端口是否打开。

5、开始菜单 → 运行cmd → 在命令提示符下输入:telnet 127.0.0.1 1433,(注意telnet与127之间有空格,1与1433之间有空格)若提示“不能打开到主机的连接,在端口 1433: 连接失败”,则说明1433端口没有打开,需要重新进行以上配置。若连接成功,显示如图8所示:

Eclipse(myeclipse)连接SQL Server 2008数据库

图8

注:Windows7如何开启telnet服务http://blog.163.com/jackie_howe/blog/static/199491347201251723939691/

二、环境变量CLASSPATH配置:

1、下载Microsoft JDBC Driver for SQL Server

http://www.microsoft.com/zh-cn/download/details.aspx?id=11774 (最新版4.0)

http://www.microsoft.com/zh-cn/download/details.aspx?id=21599 (3.0版)

http://www.microsoft.com/zh-cn/download/details.aspx?id=2505 (2.0版)

下载JDBC的驱动文件,例如下载得到的文件是sqljdbc_4.0.2206.100_chs.exe,解压文件。设将其解压到C:\Microsoft JDBC Driver 4.0 for SQL Server目录下。Eclipse(myeclipse)连接SQL Server 2008数据库

2、在桌面上右击 我的电脑,依次选择 属性 → 高级 → 环境变量,在 系统变量中双击 CLASSPATH变量,追加“;C:\Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\chs\sqljdbc4.jar”若不存在应当新建CLASSPATH变量,并且将其值设为“C:\Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\chs\sqljdbc4.jar”。如图9示:

Eclipse(myeclipse)连接SQL Server 2008数据库

图9

3、连续点击 确定 以退出环境变量配置。

三、使用Eclipse测试连接SQL Server2008数据库:

1、打开SQL Server 2008,在其中新建数据库 Test,然后退出SQL Server 2008。

2、运行Eclipse,新建一个Java Project 名为 Test。

Eclipse(myeclipse)连接SQL Server 2008数据库

图10

提示:也可以把sqljdbc4jar类  放到jre/lib/ext下,并放到tomcat/lib下

这样就可以应用到所有jsp文件,减少对每个项目进行sqljdbc4jar的加载;

4、在Test中新建包pkg,在pkg中新建一个类Main,在其中输入代码如下:

<p><span><span>package</span><span> pkg</span><span>;</span>

<span>import</span><span> java</span><span>.</span><span>sql</span><span>.*;</span>

<span>public</span><span>class</span><span>Main</span><span>{</span>
<span>public</span><span>static</span><span>void</span><span> main</span><span>(</span><span>String</span><span>[]</span><span> args</span><span>)</span>
<span>{</span>
<span>String</span><span> driverName</span><span>=</span><span>"com.microsoft.sqlserver.jdbc.SQLServerDriver"</span><span>;</span>
<span>String</span><span> dbURL</span><span>=</span><span>"jdbc:sqlserver://localhost:1433;DatabaseName=填写你的数据库名"</span><span>;</span>
<span>String</span><span> userName</span><span>=</span><span>"填写你的用户名,我的是sa"</span><span>;</span>
<span>String</span><span> userPwd</span><span>=</span><span>"填写你的密码"</span><span>;</span>
<span><span>try</span>
<span>{</span>
<span>Class</span><span>.</span><span>forName</span><span>(</span><span>driverName</span><span>);</span>
<span>System</span><span>.</span><span>out</span><span>.</span><span>println</span><span>(</span><span>"加载驱动成功!"</span><span>);</span>
<span>}</span><span>catch</span><span>(</span><span>Exception</span><span> e</span><span>){</span>
<span>	e</span><span>.</span><span>printStackTrace</span><span>();</span>
<span>System</span><span>.</span><span>out</span><span>.</span><span>println</span><span>(</span><span>"加载驱动失败!"</span><span>);</span>
<span>}</span>
<span>try</span><span>{</span>
<span>Connection</span><span> dbConn</span><span>=</span><span>DriverManager</span><span>.</span><span>getConnection</span><span>(</span><span>dbURL</span><span>,</span><span>userName</span><span>,</span><span>userPwd</span><span>);</span>
<span>System</span><span>.</span><span>out</span><span>.</span><span>println</span><span>(</span><span>"连接数据库成功!"</span><span>);</span>
<span>}</span><span>catch</span><span>(</span><span>Exception</span><span> e</span><span>)</span>
<span>{</span>
<span>	e</span><span>.</span><span>printStackTrace</span><span>();</span>
<span>System</span><span>.</span><span>out</span><span>.</span><span>print</span><span>(</span><span>"SQL Server连接失败!"</span><span>);</span>
<span>}</span></span>
<span>}</span>
</span></p><p><span><span><span>}</span></span></span></p>
Copy after login

5、点击右键,选择run as——>Java Application,出现下图11则连接成功!

Eclipse(myeclipse)连接SQL Server 2008数据库


11
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

What is the difference between HQL and SQL in Hibernate framework? What is the difference between HQL and SQL in Hibernate framework? Apr 17, 2024 pm 02:57 PM

HQL and SQL are compared in the Hibernate framework: HQL (1. Object-oriented syntax, 2. Database-independent queries, 3. Type safety), while SQL directly operates the database (1. Database-independent standards, 2. Complex executable queries and data manipulation).

How to connect keep body fat scale How to connect keep body fat scale Mar 07, 2024 pm 04:50 PM

How to connect the keep body fat scale? Keep has a specially designed body fat scale, but most users do not know how to connect the keep body fat scale. Next is the graphic tutorial on the connection method of the keep body fat scale that the editor brings to users. , interested users come and take a look! How to connect the keep body fat scale 1. First open the keep software, go to the main page, click [My] in the lower right corner, and select [Smart Hardware]; 2. Then on the My Smart Devices page, click the [Add Device] button in the middle; 3 , then select the device you want to add interface, select [Smart Body Fat/Weight Scale]; 4. Then on the device model selection page, click the [keep body fat scale] option; 5. Finally, in the interface shown below, finally [Add Now] at the bottom

Usage of division operation in Oracle SQL Usage of division operation in Oracle SQL Mar 10, 2024 pm 03:06 PM

"Usage of Division Operation in OracleSQL" In OracleSQL, division operation is one of the common mathematical operations. During data query and processing, division operations can help us calculate the ratio between fields or derive the logical relationship between specific values. This article will introduce the usage of division operation in OracleSQL and provide specific code examples. 1. Two ways of division operations in OracleSQL In OracleSQL, division operations can be performed in two different ways.

What does the identity attribute in SQL mean? What does the identity attribute in SQL mean? Feb 19, 2024 am 11:24 AM

What is Identity in SQL? Specific code examples are needed. In SQL, Identity is a special data type used to generate auto-incrementing numbers. It is often used to uniquely identify each row of data in a table. The Identity column is often used in conjunction with the primary key column to ensure that each record has a unique identifier. This article will detail how to use Identity and some practical code examples. The basic way to use Identity is to use Identit when creating a table.

Comparison and differences of SQL syntax between Oracle and DB2 Comparison and differences of SQL syntax between Oracle and DB2 Mar 11, 2024 pm 12:09 PM

Oracle and DB2 are two commonly used relational database management systems, each of which has its own unique SQL syntax and characteristics. This article will compare and differ between the SQL syntax of Oracle and DB2, and provide specific code examples. Database connection In Oracle, use the following statement to connect to the database: CONNECTusername/password@database. In DB2, the statement to connect to the database is as follows: CONNECTTOdataba

Detailed explanation of the Set tag function in MyBatis dynamic SQL tags Detailed explanation of the Set tag function in MyBatis dynamic SQL tags Feb 26, 2024 pm 07:48 PM

Interpretation of MyBatis dynamic SQL tags: Detailed explanation of Set tag usage MyBatis is an excellent persistence layer framework. It provides a wealth of dynamic SQL tags and can flexibly construct database operation statements. Among them, the Set tag is used to generate the SET clause in the UPDATE statement, which is very commonly used in update operations. This article will explain in detail the usage of the Set tag in MyBatis and demonstrate its functionality through specific code examples. What is Set tag Set tag is used in MyBati

What does printer error code 0x0000011b mean? What does printer error code 0x0000011b mean? Feb 18, 2024 pm 10:02 PM

What does 0x0000011b mean when connecting to a printer? Users often encounter various error codes when using computers, laptops or other devices. Among them, 0x0000011b is a common printer connection error code. So, what does connecting printer 0x0000011b mean? First, we need to understand the basic principles of printer connection. When we need to print files from the computer, we usually need to connect the printer to the computer for data transfer between the two. This connection can be made via

Shared printer cannot connect to printer Shared printer cannot connect to printer Feb 22, 2024 pm 01:09 PM

With the development of the digital era, shared printers have become an indispensable part of the modern office environment. However, sometimes we may encounter the problem that the shared printer cannot be connected to the printer, which will not only affect work efficiency, but also cause a series of troubles. This article aims to explore the reasons and solutions for why a shared printer cannot connect to the printer. There are many reasons why a shared printer cannot connect to the printer, the most common of which is network issues. If the network connection between the shared printer and the printer is unstable or interrupted, normal operation will not be possible.

See all articles