/**
*
* jdbc 操作sql server数据库
*/
package com.ui1;
import java.sql.*;
public class jdbc_test {
public static void main(String[] args) {
// TODO Auto-generated method stub
PreparedStatement ps=null;
Connection ct=null;
ResultSet rs=null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
ct=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433; databaseName=student","sa","root");
ps=ct.prepareStatement("select * from stu");
rs=ps.executeQuery();
while (rs.next()) {
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
System.out.println(rs.getInt(4));
System.out.println(rs.getString(5));
System.out.println(rs.getString(6));
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}finally{
try {
if(rs!=null){rs.close();}
if(ps!=null){ps.close();}
if (ct!=null) {
ct.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
说明:要向java项目中导入一个jdbc驱动包:sqljdbc4.jar,这个包可以到网上下载
注意上面的驱动加载的字符串和连接sql server 2000是有区别的
jdbc 连接sql server 2000:
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433; databaseName=student","sa","root");