public static void main(String args[]){
System.out.println(321);
PreparedStatement ps = null;
ResultSet rs = null;
Connection ct = null;
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url = "jdbc:microsoft:sqlserver://serverxp.com:1433;DatabaseName=project_students";
String user="sa";
String pwd2 = "sa";
ct = DriverManager.getConnection(url, user, pwd2);
String sql ="SELECT * FROM stu WHERE 1=? ";
ps=ct.prepareStatement(sql);
ps.setString(1, "1");
rs=ps.executeQuery();
while(rs.next()){
System.out.println(rs.getString("stuName"));
}
}catch(Exception ex){
ex.printStackTrace();
}finally{
if(null!=rs){
try {
rs.close();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
rs=null;
}
if(null!=ps){
try {
ps.close();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
ps = null;
}
if(null!=ct){
try {
ct.close();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
ct=null;
}
}
}java jdbc操作SQLServer数据库,布布扣,bubuko.com
原文：http://6846041.blog.51cto.com/6836041/1435105