请给我一个通过ＪＤＢＣ访问ＳＱＬ ＳＥＲＶＥＲ数据库的例子

Question

在微软网站下载jdbc的驱动，安装驱动，
将这三个包：
msbase.jar，mssqlserver.jar，msutil.jar
的路径放到环境变量classpath中，测试代码如下：
import java.sql.*;public class Test{
public void executeQuery(String sql){
try{
 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 
 Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;User=sa;Password=manager2000;DatabaseName=northwind");
//  "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
 Statement stmt=conn.createStatement(); 
 ResultSet rs = stmt.executeQuery(sql);
 while(rs.next()){ 
System.out.println("TestName:"+rs.getString("lastname"));
 }
}
catch(Exception ex) { 
ex.printStackTrace(); 
}
}
public static void  main(String args[]){ Test t=new Test();
t.executeQuery("select * from employees");
}
}
ok
如问题解决请揭帖，谢谢！！

Answer 1

import java.sql.*;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
/**
 *创建SqlServer的Connection
 *SqlServerConnection.java
 *@return conn
 */
public class SqlServerConnection {
    String driver;
    String url;
    String user;
    String passwd;
public SqlServerConnection(){
super();
driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DataBaseName=pubs";
user="sa";
passwd="";
}
public Connection createConnection(){
try{
Class.forName(driver).newInstance();
conn=DriverManager.getConnection(url,user,passwd);
System.out.println("SqlServer connection successful...");
}catch(Exception e){
System.err.println("SqlServerConnection.createConnection():"+e.getMessage());
}
return conn;
}
/**内部测试用*/
public static void main(String[] args){
try{
MyConnection my=new SqlServerConnection();
Connection sqlconn=my.createConnection();
Statement stmt=null;
ResultSet rs=null;
stmt=sqlconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery("select * from information");
while(rs.next())
System.out.println(rs.getString(2));
my.closeConnection();
System.out.println("sqlconn isClosed:"+sqlconn.isClosed());
//sqlconn.close();
}catch(Exception e){
System.err.println(e.getMessage());
}
}
}

Answer 2

典型的就是以下这样：
import java.sql.*;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
public class SqlServerConnection {
     public SqlServerConnection(){
driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DataBaseName=pubs";
user="sa";
passwd="";
}
public Connection createConnection(){
try{
Class.forName(driver).newInstance();
conn=DriverManager.getConnection(url,user,passwd);
System.out.println("SqlServer connection successful...");
}catch(Exception e){
System.err.println("SqlServerConnection.createConnection():"+e.getMessage());
}
return conn;
}
/**内部测试用*/
public static void main(String[] args){
try{
MyConnection my=new SqlServerConnection();
Connection sqlconn=my.createConnection();
Statement stmt=null;
ResultSet rs=null;
stmt=sqlconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery("select * from information");
while(rs.next())
System.out.println(rs.getString(2));
my.closeConnection();
System.out.println("sqlconn isClosed:"+sqlconn.isClosed());
//sqlconn.close();
}catch(Exception e){
System.err.println(e.getMessage());
}
}
}