JavaBean连接数据库问题!

来源:百度知道 编辑:UC知道 时间:2024/06/10 03:51:02
刚接触JSP,写了个初级JavaBean连接数据库!可是我在页面中调用总是出错!帮忙看一下啊!
下面是JavaBean代码.
package org.util;
import java.sql.* ;
import javax.sql.*;

public class DataBase {
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver" ;
String url = "jdbc:microsoft:sqlserver://localhost:1350;DataBaseName=lianxi" ;
String user = "sa" ;
String password = "" ;

public Connection getConn(){
Connection conn = null ;
try{
Class.forName("driver") ;
conn = DriverManager.getConnection("url,user,password") ;
}catch(Exception e){}
return conn ;
}
public Statement getStatement(Connection conn) {
Statement stmt = null ;
try{
if(conn!=null){
stmt = conn.createStatement();
}
}catch(Exception e){}
return stmt ;
}
public ResultSet getResultSet(Statement stmt, String sql){
Resu

String sql = "select * from admin";
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
//你可以获取返回的rs对象 然后:
while(rs.next()) {
int name = rs.getString("username");
int pass = rs。getString("password");
System.out.println(name+ " " + pass);
}