MYSQL数据库
test
User Name char 10 P
Password char 10
-===============================logcheck.jsp========================
<%--
Document : Check
Created on : 2009-12-6, 15:27:54
Author : Administrator
--%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<%@page import="java.util.*"%>
<%@page import="java.io.*"%>
<title>登陆</title>
</head>
<body>
<%
java.sql.Connection conn=null;
java.lang.String strConn;
java.sql.PreparedStatement preparedStmt=null;
java.sql.ResultSet sqlRst=null;
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
conn=java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","lilin");
preparedStmt=conn.prepareStatement("select Name,Password from User where Name like?");
String Name=request.getParameter("userID");
String Pass=request.getParameter("password");
preparedStmt.setString(1,"%"+Name+"%");
sqlRst=preparedStmt.executeQuery();
while(sqlRst.next()){
String Name1=new String(sqlRst.getString("Name").getBytes("iso-8859-1"));
if(Name1.equals(Name)){
if(Pass.equals(sqlRst.getString("Password"))){
%>
<jsp:forward page="Catalog.jsp"></jsp:forward>
<%
}
}
}
%>
<jsp:forward page="Register.html"></jsp:forward>
<%
}catch(java.sql.SQLException e){
out.println(e.toString());
}finally{if(sqlRst!=null)try{sqlRst.close();}catch(java.sql.SQLException e1){
out.println(e1.toString());
}finally{
try{
if(preparedStmt!=null)preparedStmt.close();
}catch(java.sql.SQLException e2){
out.println(e2.toString());
}finally{
try{
if(conn!=null)conn.close();
}catch (java.sql.SQLException e3){
out.println(e3.toString());
}
}
}
}
%>
密码错误
<a href=" http://localhost:8080/20077610418_2/jsp/dl.html">回到登陆界面
%>
</body>
</html>
===================================getzhuce.jsp==============================
<%--
Document : Register
Created on : 2009-12-6, 15:29:24
Author : Administrator
--%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.util.*" %>
<%@page import="java.io.*" %>
<%@page import="java.lang.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>注册</title>
</head>
<body>
<%
String Name=request.getParameter("userID");
String Pass=request.getParameter("password");
java.sql.Connection conn=null;
java.lang.String strConn;
java.sql.PreparedStatement preparedStmt=null;
java.sql.ResultSet sqlRst=null;
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
conn=java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","lilin");
preparedStmt=conn.prepareStatement("insert into User(Name,Password)values(?,?)");
preparedStmt.setString(1,Name);
preparedStmt.setString(2,Pass);
preparedStmt.executeUpdate();
}catch(java.sql.SQLException e){
out.println(e.toString());
}finally{if(sqlRst!=null)try{sqlRst.close();}catch(java.sql.SQLException e1){
out.println(e1.toString());
}finally{
try{
if(preparedStmt!=null)preparedStmt.close();
}catch(java.sql.SQLException e2){
out.println(e2.toString());
}finally{
try{
if(conn!=null)conn.close();
}catch (java.sql.SQLException e3){
out.println(e3.toString());
}
}
}
}
%>
<%=Name%>
注册成功
<a href="dl.html">返回登陆界面
</body>
</html>