接上面的贴,这是我连数据库的JAVABEAN:
package WebMailservlet;import java.io.PrintStream;
import java.sql.*;public class conn
{ String sDBDriver;
String sConnStr;
Connection connect;
ResultSet rs; public conn()
{
sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
sConnStr = "jdbc:odbc:WEBMAIL";
connect = null;
rs = null;
try
{
Class.forName(sDBDriver);
}
catch(ClassNotFoundException e)
{
System.err.println(e.getMessage());
}
} public ResultSet executeQuery(String sql)
{
rs = null;
String user = "sa";
String pwd = "szitsa";
try
{
connect = DriverManager.getConnection(sConnStr, user, pwd);
Statement stmt = connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println(ex.getMessage());
}以前我这句Statement stmt = connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);是这样写的
Statement stmt = connect.createStatement();用<jsp:useBean id="userBean" scope="page" class="WebMailservlet.conn"/>调用是可以的,但变成Statement stmt = connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);后用用<jsp:useBean id="userBean" scope="page" class="WebMailservlet.conn"/>调用时WEBLOGIC老是报:
can not loaded this class 请高手帮助!
package WebMailservlet;import java.io.PrintStream;
import java.sql.*;public class conn
{ String sDBDriver;
String sConnStr;
Connection connect;
ResultSet rs; public conn()
{
sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
sConnStr = "jdbc:odbc:WEBMAIL";
connect = null;
rs = null;
try
{
Class.forName(sDBDriver);
}
catch(ClassNotFoundException e)
{
System.err.println(e.getMessage());
}
} public ResultSet executeQuery(String sql)
{
rs = null;
String user = "sa";
String pwd = "szitsa";
try
{
connect = DriverManager.getConnection(sConnStr, user, pwd);
Statement stmt = connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println(ex.getMessage());
}以前我这句Statement stmt = connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);是这样写的
Statement stmt = connect.createStatement();用<jsp:useBean id="userBean" scope="page" class="WebMailservlet.conn"/>调用是可以的,但变成Statement stmt = connect.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);后用用<jsp:useBean id="userBean" scope="page" class="WebMailservlet.conn"/>调用时WEBLOGIC老是报:
can not loaded this class 请高手帮助!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货