java 连接sql2005_JAVA 连接SqlServer2005

import java.sql.*;

public class TxlDemo

{

public TxlDemo() throws Exception

{

//注册加载数据库驱动程序

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

//获得数据库连接

Connection conn=DriverManager.getConnection("jdbc:odbc:txl");

//创建语句对象

Statement stmt=conn.createStatement();

//发出查询命令

ResultSet rs=stmt.executeQuery("select 学号,姓名 from txl");

//逐条显示数据

System.out.println("学号"+"/t"+"姓名");

while(rs.next())

{

String name=rs.getString("学号");

String xm=rs.getString("姓名");

System.out.println(name+"/t"+xm);

}

conn.close();

}

public static void main(String args[]) throws Exception

{

TxlDemo t=new TxlDemo();

}

}

确认自己系统数据源名字与ODBC：名字一致。。。

方法2：

import java.sql.*;

import java.awt.event.*;

public class ConnetedSQL {

Connection connet;

public Connection launch()

{

String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载JDBC驱动

String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=SuperMarket"; //连接服务器和数据库SuperMarket

String userName = "sa"; //默认用户名

String userPwd = "lixiangblue"; //安装sql server 2005时的密码

//Connection connet;

try {

Class.forName(driverName);

connet = DriverManager.getConnection(dbURL, userName, userPwd);

System.out.println("Connection Successful!"); //如果连接成功 控制台输出Connection Successful!

} catch (Exception e) {

e.printStackTrace();

}

return connet;

}

}

1下载microsoft sqljdbc_1.2

2在eclipse中添加sqljdbc_1.2包