主题:Error establishing socket
本人用jsp页面开发一个用户登录程序,要用到数据库,当然也是第一次使用,但总是出现java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket的错误。
数据库是SQLServer 2000 ,也打了补丁,在cmd控制台下 telnet 127.0.0.1 1433连接失败。
下面是数据库处理程序,其参数没有问题:
<%@page contentType="text/html; charset=gb2312" language="java"
import="java.sql.*,java.util.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>插入数据</title>
</head>
<body>
<%
try{
String s1 = request.getParameter("na");
String s2 = request.getParameter("pa");
Class cla=Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection ct = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=login","ganliang13","3600205");
Statement sm = ct.createStatement();
ResultSet rs = sm.executeQuery("select * from login where Sname='"+s1+"'");
if(rs.next()){
response.sendRedirect("wel.jsp");
}
}catch(Exception e){
out.print(e);
}
%>
</body>
</html>
数据库是SQLServer 2000 ,也打了补丁,在cmd控制台下 telnet 127.0.0.1 1433连接失败。
下面是数据库处理程序,其参数没有问题:
<%@page contentType="text/html; charset=gb2312" language="java"
import="java.sql.*,java.util.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>插入数据</title>
</head>
<body>
<%
try{
String s1 = request.getParameter("na");
String s2 = request.getParameter("pa");
Class cla=Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection ct = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=login","ganliang13","3600205");
Statement sm = ct.createStatement();
ResultSet rs = sm.executeQuery("select * from login where Sname='"+s1+"'");
if(rs.next()){
response.sendRedirect("wel.jsp");
}
}catch(Exception e){
out.print(e);
}
%>
</body>
</html>