- 论坛徽章:
- 0
|
下面的代码编译不过去,是因为啥呢?我想写个bean连接sqlserver2000的数据库....我的环境是windowsXP,tomcat,jdk....sqlserver2000和jdbc for sqlserver2000.....................
package SQLServer;
import java.sql.*;
public class SQLServer_dbconnect{
String sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String sConnStr = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=dream_marry";
Connection conn = null ;
ResultSet rs = null;
public SQLServer_dbconnect(){
try{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundExecption e){
System.err.println("Class SQLServer_dbconnect not found!" + e.getMessage());
}
}
public ResultSet executeQuery(String sql){
rs = null;
try{
conn = DriverManager.getConnection(sConnStr,"sa","" ;
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println("aq.executeQuery:" + ex.getMessage());
}
return rs;
}
public ResultSet executeUpdate(String sql){
rs = null;
try{
conn = DriverManager.getConnection(sConnStr,"sa","" ;
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
} |
|