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

[lgmsyy]

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

[垲垲]

java.sql.Connection connDB =null;

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

[zxhong]

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

[indeed]

首先要装上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);
......

%>