jsp调用javabean连不到数据库?
我在jsp页面写代码连接数据库,就连得到!
但一用javabean调用就不行了,请各位大虾指教下!
javabean的内容是:
package conn;
import java.sql.*;
public class connsql{
String driver="org.gjt.mm.mysql.Driver";
String url="jdbc:mysql://localhost:3306/oasystem?user=root&password=121623";
public connsql(){
}
public ResultSet executeQuery(String sql){
try{
Class.forName(driver);
}catch(ClassNotFoundException ex){
}
try{
conn=DriverManager.getConnection(url);
if(!conn.isClosed()){
System.out.print("连接成功!");
}
}catch(Exception e){
}
try{
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}catch(Exception e){
}
return rs;
}
}
jsp的调用代码是:
<jsp:useBean id="db" scope="session" class="mysqltest.DBconn"/>
<%
try{
ResultSet rs=db.executeQuery("select * from user_tbe");
while(rs.next()){
out.print(rs.getString(1));
}
rs.close();
}catch(Exception ex){
out.println("连javabean出错!");
out.println(ex.getMessage());
}
%>
急用,请各位帮手解答!