这是源代码,看看先。package mytestproject;
import java.sql.*;public class faq {
String sDBDriver="com.micrsoft.jdbc.sqlserver.SQLServerDriver";
String sConnStr="jdbc:micrsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String USER="sa";
String PWD="sa";
Connection conn;
ResultSet rs;
public faq(){
try{
Class.forName(sDBDriver);
conn=DriverManager.getConnection(sConnStr,USER,PWD);
}
catch(Exception e){
e.printStackTrace();
}
} public ResultSet executeQuery(String sql){
try{
conn=DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
import java.sql.*;public class faq {
String sDBDriver="com.micrsoft.jdbc.sqlserver.SQLServerDriver";
String sConnStr="jdbc:micrsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String USER="sa";
String PWD="sa";
Connection conn;
ResultSet rs;
public faq(){
try{
Class.forName(sDBDriver);
conn=DriverManager.getConnection(sConnStr,USER,PWD);
}
catch(Exception e){
e.printStackTrace();
}
} public ResultSet executeQuery(String sql){
try{
conn=DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
试试看