首先，配制环境，其中包括下载JDBC FRO Microsft SQL_Server2000的驱动程序（在微软官方网站下的，是sp3版的，这里就不写具体地址了，网上挺多的，但注意版本，我下的是sp3）。下载后发现是EXE 文件，双击安装。默认安装目录：C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC，其中C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib目录下的三个扩展名为.jar是我们要的驱动。然后配制环境变量：
在classpath这个环境变量里加入以下语句：
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;
/* try to connct SQL_Server database*/
import java.sql.*;
public class Sql_db_test{
Connection con;
Statement sta;
ResultSet rs;
String sql_driver;
String sql_url;
String user;
String pwd;
public Sql_db_test(){
sql_driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";//驱动
sql_url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=manage";//
语句一，其中manage是要访问的数据库名
user="xiaolin";//你要访问的数据库用户名
pwd="123456";//访问数据库的密码
init();
}
public void init()
{
try{
Class.forName(sql_driver);//加载驱动
System.out.println("driver is ok");
con=DriverManager.getConnection(sql_url,user,pwd);
System.out.println("connection is ok");
sta=con.createStatement();
rs=sta.executeQuery("select * from 制衣表");//executeQuery
while(rs.next())
System.out.println(rs.getString("款式"));
}catch (Exception e)
{
e.printStackTrace();//printStackTrace();
}
}
public static void main(String[] args)
{
new Sql_db_test();
}
}
将上边的代码保存后，在命令提示行里执行
Javac Sql_db_test.java //编译正常通过
Java Sql_db_test //产生异常，异常如下
driver is ok
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establis
hing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Sou
rce)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown S
ource)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:523)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at DbTest.init(DbTest.java:32)
at DbTest.<init>(DbTest.java:25)
at DbTest.main(DbTest.java:46)
Press any key to continue...
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at Sql_db_test.init(Sql_db_test.java:21)
at Sql_db_test.<init>(Sql_db_test.java:16)
at Sql_db_test.main(Sql_db_test.java:36)
精品推荐