JDBC连接Sql_Server_2005

川长思鸟来 2022-05-26 02:54 249阅读 0赞

1.准备工作: 准备相关的软件(Eclipse除外,开源软件可以从官网下载)  
<1>.Microsoft SQL server 2005 Express Edition  
下载地址:[http://download.microsoft.com/download/0/9/0/09020fab-d2c3-4a8c-b9e0-db53a7a30ae8/SQLEXPR\_CHS.EXE][http_download.microsoft.com_download_0_9_0_09020fab-d2c3-4a8c-b9e0-db53a7a30ae8_SQLEXPR_CHS.EXE]  
<2>.SQL Server Management Studio  
下载地址:[http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796\#filelist][http_www.microsoft.com_downloads_details.aspx_displaylang_zh-cn_FamilyID_c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796_filelist]  
<3>.SQL Server 2005 driver for JDBC  
下载地址:[http://download.microsoft.com/download/8/B/D/8BDABAE2-B6EA-41D4-B903-7916EF3690EF/sqljdbc\_1.2.2323.101\_enu.exe][http_download.microsoft.com_download_8_B_D_8BDABAE2-B6EA-41D4-B903-7916EF3690EF_sqljdbc_1.2.2323.101_enu.exe]  
注：也可以直接安装完整版本的SQL 2005

一、配置数据库端口  
Microsoft SQL Server 2005——配置工具——SQL Server Configuration Manager  
![这里写图片描述][70]

![这里写图片描述][70 1]

![这里写图片描述][70 2]

如![这里写图片描述][70 3]中的协议有两个，，那么两个都要配置。

二、配置Microsoft SQL Server 2005  
Microsoft SQL Server 2005——SQL Server Management Studio打开SQL Server Management Studio  
![这里写图片描述][70 4]

![这里写图片描述][70 5]

![这里写图片描述][70 6]

![这里写图片描述][70 7]

![这里写图片描述][70 8]

![这里写图片描述][70 9]

![这里写图片描述][70 10]

![这里写图片描述][70 11]

![这里写图片描述][70 12]  
三、安装eclipse到C:\\Program Files（推荐）  
安装apache-tomcat-6.0.29到C:\\Program Files\\ apache-tomcat-6.0.29（推荐）  
复制sqljdbc.jar到C:\\Program Files\\eclipse（推荐）  
复制com.sysdeo.eclipse.tomcat\_3.2.1到C:\\Program Files\\eclipse\\dropins（必须在此目录）

配置tomcat6.0  
![这里写图片描述][70 13]

![这里写图片描述][70 14]

![这里写图片描述][70 15]

![这里写图片描述][70 16]

![这里写图片描述][70 17]

四、连接数据库  
打开Eclipse  
a.新建工程-> java -> java project,起名为Test  
<5> 编写java代码来测试连接数据库  
程序代码:

import java.sql.*; 
    public class Test {
    public static void main(String[] srg) {
      String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";  //加载JDBC驱动
      String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=master";  //连接服务器和数据库master
      String userName = "sa";  //默认用户名
      String userPwd = "111111";  //密码
      Connection dbConn;
      try {
       Class.forName(driverName);
       dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
       System.out.println("==========数据库连接成功========!");  //如果连接成功 控制台输出==========数据库连接成功========!
      } catch (Exception e) {
       e.printStackTrace();
      }
    }
    }

b.选择eclipse->窗口->首选项->java->installed JRE  编辑已经安装好的jdk,查找目录添加sqljdbc.jar

![这里写图片描述][70 18]

![这里写图片描述][70 19]

c.右键单击目录窗口中的Test, 选择Build Path ->Configure Build Path…, 添加扩展jar文件,即把sqljdbc.jar添加到其中  
![这里写图片描述][70 20]

![这里写图片描述][70 21]

![这里写图片描述][70 22]

![这里写图片描述][70 23]

[http_download.microsoft.com_download_0_9_0_09020fab-d2c3-4a8c-b9e0-db53a7a30ae8_SQLEXPR_CHS.EXE]: http://download.microsoft.com/download/0/9/0/09020fab-d2c3-4a8c-b9e0-db53a7a30ae8/SQLEXPR_CHS.EXE
[http_www.microsoft.com_downloads_details.aspx_displaylang_zh-cn_FamilyID_c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796_filelist]: http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796#filelist
[http_download.microsoft.com_download_8_B_D_8BDABAE2-B6EA-41D4-B903-7916EF3690EF_sqljdbc_1.2.2323.101_enu.exe]: http://download.microsoft.com/download/8/B/D/8BDABAE2-B6EA-41D4-B903-7916EF3690EF/sqljdbc_1.2.2323.101_enu.exe
[70]: /images/20220526/bc3fe05b5ac542d189df613328b64219.png
[70 1]: /images/20220526/5c35099966f247a59a1ad5af7318338b.png
[70 2]: /images/20220526/02af66d208614fc78274765f177310dc.png
[70 3]: /images/20220526/facd9bad7a8e473b9c8c97a22b803844.png
[70 4]: /images/20220526/78e72af4478e49a4a967a645aa04b1d8.png
[70 5]: /images/20220526/5991f61a69fd441c898963239aea896c.png
[70 6]: /images/20220526/8df413d9082245a78a3b553b7daeac43.png
[70 7]: /images/20220526/c4d053216c9c44e9af79849e4933a4cd.png
[70 8]: /images/20220526/86507c2da458494d8d11914ee886e1bb.png
[70 9]: /images/20220526/f736f71eb11a4e03859c46fd1116b753.png
[70 10]: /images/20220526/137a910781ef4df891dced3c39e863c3.png
[70 11]: /images/20220526/2aab3e6253244cdb9de1482b1e4c2190.png
[70 12]: /images/20220526/aaab4752036d4b4ab6d52ac2047dbe96.png
[70 13]: /images/20220526/800838af01484b6ea8a8584b02d0d7c8.png
[70 14]: /images/20220526/ef4de5cdef2c4ec79ffd351bddae73f6.png
[70 15]: /images/20220526/a980e4a2cfac4e82843dc525ffb989c6.png
[70 16]: /images/20220526/c90116a56fee48cebfbb344a57c6d62e.png
[70 17]: /images/20220526/5099bea9e36a4c30a3666f18985b8b61.png
[70 18]: /images/20220526/3fea309cb4cb4e128f7a16e640c57b89.png
[70 19]: /images/20220526/a1e5562f75a743caa7534c31f73bb188.png
[70 20]: /images/20220526/ecac46b7607b496186ce2a24c344e720.png
[70 21]: /images/20220526/08f2d56d6b2044f7a273b45a7c2579aa.png
[70 22]: /images/20220526/e0590a858df14ade957094773fe942cc.png
[70 23]: /images/20220526/c6886547f2854b97aed2afd1a5803887.png