将JSP与SQL2000的连接写在javabean中该如何写呢？

Question

java.sql.Connection connDB =null; Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
connDB = DriverManager.getConnection(connStr, connUser, connPwd); 

Answer 1

http://expert.csdn.net/Expert/topic/1063/1063469.xml?temp=3.190249E-02

Answer 2

首先要装上sql server2000的驱动,其次javabean的位置要放对
/***java***/
package opendb;import java.io.PrintStream;
import java.sql.*;public class opendb
{    String sDBDriver;
    String sConnStr;
    String sDBuser;
    String sDBpasswd;
    Connection conn;
    ResultSet rs;    public opendb()
    {
        sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
        sConnStr = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=faq";
        sDBuser = "admin";
        sDBpasswd = "123456";
        conn = null;
        rs = null;
        try
        {
            Class.forName(sDBDriver);
        }
        catch(ClassNotFoundException classnotfoundexception)
        {
            System.err.println("opendb(): " + classnotfoundexception.getMessage());
        }
    }    public ResultSet executeQuery(String s)
    {
        rs = null;
        try
        {
            conn = DriverManager.getConnection(sConnStr, sDBuser, sDBpasswd);
            Statement statement = conn.createStatement();
            rs = statement.executeQuery(s);
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery: " + sqlexception.getMessage());
        }
        return rs;
    }
public void executeUpdate(String sql) 
{
try 
{
conn = DriverManager.getConnection(sConnStr, sDBuser, sDBpasswd);
Statement stmt = conn.createStatement();
stmt.executeUpdate(sql);
} 
catch(SQLException ex) 
{ 
System.err.println("aq.executeUpdate: " + ex.getMessage());
System.err.println("aq.executeUpadatestrSQL: " + sql);
}
}
}
/***jsp**/
<%@page language="Java" import="java.sql.*"%>
<jsp:useBean id="RegisterBean" class="opendb.opendb" />
<%
String name_old = request.getParameter("name_old");
String pwd_old = request.getParameter("pwd_old");//生成注册用的SQL语句
String strSQL="select * from user_info where username='" + name_old + "' and password='" + pwd_old + "'";
//执行SQL语句，rs为返回结果
ResultSet rs=RegisterBean.executeQuery(strSQL);
......%>