JSP+SQLserver2000设计的系统 为什么连不上数据库 有连接数据库代码
下面的连数据库的代码 为什么连接不上 急求高手指点..........哪错了....
包 环境变量 补丁都没问题
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class sqlBean {
public Connection conn;
public ResultSet rs;
private String DatabaseDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;databaseName=ClassDB";
public void createConn(){
try {
Class.forName(DatabaseDriver);
conn=DriverManager.getConnection(url,"limq","123");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.println("连接错误!"+e);
} catch (SQLException e) {
// TODO Auto-generated catch block
System.out.println("Cl`ssforName错误!"+e);
}
}
public int executeInsert(String sql){
int num=0;
try{
createConn();
Statement stmt=conn.createStatement( );
num=stmt.executeUpdate(sql);
} catch(SQLException ex){
System.err.println("执行插入有错误:"+ex.getMessage() );
System.out.print("执行插入有错误:"+ex.getMessage());//输出到客户端
}
CloseDataBase();
return num;
}
public ResultSet executeQuery(String sql){
rs=null;
try{
createConn();
Statement stmt=conn.createStatement( );
rs=stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println("执行查询有错误:"+ex.getMessage() );
System.out.print("执行查询有错误:"+ex.getMessage()); //输出到客户端
}
CloseDataBase();
return rs;
}
public int executeDelete(String sql){
createConn();
int num=0;
try{
Statement stmt=conn.createStatement( );
num=stmt.executeUpdate(sql);
}
catch(SQLException ex){
System.err.println("执行删除有错误:"+ex.getMessage() );
System.out.print("执行删除有错误:"+ex.getMessage()); //输出到客户端
}
CloseDataBase();
return num;
}
public void CloseDataBase(){
try{
conn.close();
}
catch(Exception end){
System.err.println("执行关闭Connection对象有错误:"+end.getMessage( ) );
System.out.print("执行执行关闭Connection对象有错误:有错误:"+end.getMessage()); //输出到客户端
}
}
}