登陆界面:login.jsp
<%@page contentType="text/html" pageEncoding="gbk"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<title>登陆</title>
</head>
<body>
<center>
<form name="form1" method="post" action="conf.jsp">
<h1>用户登录</h1>
<p>用户名:
<input type="text" name="name">
</p>
<p>用户密码:
<input type="password" name="password">
</p>
<p>
<input type="submit" name="Submit" value="登陆">
<input type="reset" name="Submit2" value="重置">
</p>
</form>
</center>
</body>
</html>
登录验证界面:conf.jsp
<%@page import ="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ page import ="java.util.*"%>
<%
Class.forName("org.gjt.mm.mysql.Driver");
Connection conn = null;
String url = "jdbc:mysql://localhost:3306/tf";
String user = "root";
String password = "123";
conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
String name = request.getParameter("name");
byte b[] = name.getBytes("ISO-8859-1");
name = new String(b);
String password2 = request.getParameter("password");
String strSQL = "select * from member where name='" + name + "' and password='" + password2 + "'";
ResultSet rs = stmt.executeQuery(strSQL);
int count = 0;
while (rs.next()) {
count++;
}
if (count > 0) {
%>
<jsp:forward page="chenggong.jsp"></jsp:forward>
<%} else {
%>
<jsp:forward page="shibai.jsp"></jsp:forward>
<% }
%>