Eclipse(myeclipse)连接SQL Server 2008数据库
在连接数据库之前必须保证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所示:
图5
图6
4、然后重启数据库,重启完毕后,接下来使用命令测试1433端口是否打开。
5、开始菜单 → 运行cmd → 在命令提示符下输入:telnet 127.0.0.1 1433,(注意telnet与127之间有空格,1与1433之间有空格)若提示“不能打开到主机的连接,在端口 1433: 连接失败”,则说明1433端口没有打开,需要重新进行以上配置。若连接成功,显示如图8所示:
图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目录下。
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示:
图9
3、连续点击 确定 以退出环境变量配置。
三、使用Eclipse测试连接SQL Server2008数据库:
1、打开SQL Server 2008,在其中新建数据库 Test,然后退出SQL Server 2008。
2、运行Eclipse,新建一个Java Project 名为 Test。
图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>
5、点击右键,选择run as——>Java Application,出现下图11则连接成功!
图11

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



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 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 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.

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

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

Solutions to Restricted Network Connections in Win10 With the rapid development of technology, the Internet has become an indispensable part of people's lives. However, sometimes we may encounter some problems when connecting to the Internet on computers using the Windows 10 operating system, one of which is restricted connections. In this case, we cannot access web pages, download files, or use network functions normally. So, is there any way to solve this problem? This article will introduce you to several common solutions. 1. Check the network connection settings. First, I

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.

When you use the Edge browser to access web pages, have you ever encountered a prompt that your connection is not a dedicated connection, causing web browsing to fail? How is this going? Many friends don’t know how to deal with this problem. You can take a look at the following three solutions. Method 1 (simple and crude): In the edge browser, you can try to solve the problem of the website being inaccessible by entering the settings and turning off the security function, and then blocking location permissions in the website permissions. It is important to note that the effectiveness and duration of this approach may vary, and specific effects cannot be determined. After restarting your browser, you can try visiting the website to see if the issue is resolved. Method 2: Adjust the keyboard to English input
