新手请教帮忙解决一个简单用户登录页面的出错
jsp环境配置测试通过。
以下是我的用户登录页面index.jsp和检验用户页面login.jsp
------index.jsp--------
<%@page contentType="text/html;charset=gb2312" %>
<html>
<head>
<title>计算机管理系统</title>
<body>
<br><br><br><br><br>
<form name="form1" action="login.jsp" method="post">
<table bgcolor="#dbdbdb" align="center" width="500">
<tr bgcolor="#dbdbdb"><div align="center"><h1><br><strong>欢迎进入计算机管理系统</strong></h1></div></tr>
<tr bgcolor="#dbdbdb"><div align="center"><br>用户名:<input type="text" name="name" size="20"></div>
</tr>
<tr bgcolor="#dbdbdb"><div align="center"><br>密 码:<input type="password" name="passwd" size="20" width="100"></div></tr>
<tr bgcolor="#dbdbdb"><div align="center">
<br><input width="100" type="submit" name="Submit" value="登录">
</div></tr>
</table>
</form>
</body>
</head>
</html>
------login.jsp--------
<%@ page import="java.sql.*"%>
<html>
<head>
<title>用户管理</title>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
</head>
<body>
<%
String name=request.getParameter("name");
String passwd=request.getParameter("passwd");
String DBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String SQLURL ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Documents";
String SQLUSER = "sa";
String SQLPWD = "";
Connection conn=null;
ResultSet rs=null;
try{
Class.forName(DBDriver);}
catch(java.lang.ClassNotFoundException e){
System.out.println("java.lang.ClassNotFoundException"+e.getMessage());}
try{
conn = DriverManager.getConnection(SQLURL, SQLUSER, SQLPWD);
Statement stmt = conn.createStatement();
String sqlquery="select * from user where user_id='"+name+"' and user_password='"+passwd+"'";
rs=stmt.executeQuery(sqlquery);
}
catch(SQLException ex){
System.out.println("SQLException"+ex.getMessage());}
if(rs.next())
{
%>
<p>登录成功</p>
<%
}
else
{
%>
<p>用户不存在</p>
<%
}
rs.close();
conn.close();
%>
</body>
</html>