JSP中链接SqlServer2000 出错

来源：百度知道 编辑：UC知道 时间：2024/05/31 03:33:57
我装的系统是xpSP3，出错代码如下：
exception

org.apache.jasper.JasperException: An exception occurred processing JSP page /login.jsp at line 24

21: String password = request.getParameter("password");
22: //到数据库中去验证
23: Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
24: Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=spdb1","administrator","");
25: Statement sm=conn.createStatement();
26: ResultSet rs=sm.executeQuery("select passwd from users where username='"+username+"'");
27: if(rs.next()) {

root cause

javax.servlet.ServletException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:855)
org.apache.jasper.runtime.PageCon

package bao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.PropertyResourceBundle;
public class Lei {
private static Lei p=null;
private PropertyResourceBundle bundle;
private static String jdbcDriver=null;
private static String split=null;
private String DBType=null;
private String DBhost="localhost";
private String DBname="";
private String DBport="";
private String DBuser="";
private String DBpasswd="";

private Connection Sqlconn=null;
private Statement Sqlstmt=null;
private String strCon =null;

private Lei(){
try{
bundle=new PropertyResourceBundle(Lei.class.getResourceAsStream("/sysConfig.properties"));
this.DBhost=getString("DBhost");