使用eclipse工具jdbc链接sqlserver2005程序

使用eclipse工具jdbc链接sqlserver2005程序

public static void main(String[] args) {

try {
String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
Class.forName(driverName).newInstance();
String url="jdbc:sqlserver://192.168.40.131:1433;DatabaseName=cdws";
String USER = "sa"; // 根据你自己设置的数据库连接用户进行设置
   String PASSWORD = "wonders2009"; // 根据你自己设置的数据库连接密码进行设置
Connection conn = DriverManager.getConnection(url, USER, PASSWORD);
Statement stmt = conn.createStatement();
String sql = "select * from tb_his_patinf";
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
System.out.println("TestName:" + rs.getString("XM"));
}
rs.close();
stmt.close();
conn.close();
} catch (Exception ex) {
System.err.println(ex.getMessage());
}



}