jdbc连接sql server 2005 数据库

gfdxy3322

import java.sql.*;
public class sqlconn{
public static void main(String args[]){
String Driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url="jdbc:sqlserver://localhost:1433;DatabaseName=MyStudy";
String user="sa";
String password="1573324";
try{
Class.forName(Driver).newInstance();
Connection conn=DriverManager.getConnection(url,user,password);
if (!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");
Statement statement=conn.createStatement();
String sql="select * from t_user";
ResultSet rs=statement.executeQuery(sql);
System.out.println("---------------");
System.out.println("执行结果如下");
System.out.println("---------------");
System.out.println("学号"+"\t"+"姓名");
System.out.println("---------------");
String name=null;
while(rs.next()){
name=rs.getString("name");
name=new String(name.getBytes("ISO-8859-1"),"GB2312");
System.out.println(rs.getString("password")+"\t"+name);
}
rs.close();
}catch(ClassNotFoundException e){
System.out.println("找不到驱动！");
e.printStackTrace();
}
catch(SQLException e){
e.printStackTrace();
}catch(Exception e){
e.printStackTrace();
}
}
}