libevent 删除事件:请教一个jsp连接sqlserver数据库的问题(急)

来源:百度文库 编辑:中科新闻网 时间:2024/05/02 19:17:30
我写了一个代码,使jsp与sqlserver数据库的连接,但是总是连接不上,我实在是找不出原因,请高手帮忙看一下,谢谢!代码如下:
package DB;
import java.sql.*;
import java.awt.*;
import java.lang.*;
public class DataBase
{
private Connection conn = null;
private ResultSet rs = null;

public DataBase()
{
}

private boolean setDriver(String sDBDriver)
{
boolean b=false;
try
{
Class.forName(sDBDriver);
b=true;
return b;
}
catch(java.lang.ClassNotFoundException e)
{
return b;
}
}

private boolean Connect(String url,String user, String password)
{
boolean b=false;
try
{
conn = DriverManager.getConnection(url,user,password);
System.out.println("Connect to DataBase successfully...");
b=true;
return b;
}
catch(Exception e)
{
System.out.println("Connect to DataBase fail...");
return b;
}
}

public ResultSet executeQuery(String sql)
{
try
{
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{ex.printStackTrace();

}
return rs;
}

public int executeUpdate(String sql)
{
int count = -1;
try
{
Statement stmt = conn.createStatement();
count = stmt.executeUpdate(sql);
return count;
}
catch(SQLException ex)
{
return count;
}
}

public boolean dbConnect()
{
return (setDriver("sun.jdbc.odbc.JdbcOdbcDriver")&&Connect("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=study","sa",""));
}

public int dbInsert(String TabN,String val)
{
String sql;
sql="Insert into " + TabN + " values("+val+")";
return executeUpdate(sql);
}

public ResultSet dbSelect(String TabN,String Condition, String Condition1)
{
String sql;
try{
if (Condition1.trim().compareTo("")==0)
sql= "Select" + Condition + " from" + TabN;

else
sql=" Select " + Condition + "from " + TabN + " where " + Condition1;
System.out.println(sql);
rs = executeQuery(sql);

return rs;
}
catch(Exception e) {
return null;
}
}

public int dbDelete(String TabN,String Condition)
{
String sql;
if(Condition.trim().compareTo("")==0)
sql="Delete from " + TabN;
else
sql="Delete from " + TabN + " where "+ Condition;
return executeUpdate(sql);
}

public void dbDisConnect()
{
try
{
rs.close();
conn.close();
}
catch(SQLException ex)
{
System.out.println("DisConnect failed: "+ex.toString());
}
}
}

把出错信息写出来吧,看代码比较麻烦