JAVAWeb

1.数据库：person表
a)包含字段：uid(vchar)、uname(vchar)、upwd(vchar)
2.要求：结合注册模块，要求登陆用户名、密码与数据库中已经存在的用户名、密码匹配。使用preparedStatment对象
3.关键：首先查询数据库，判断是否存在提交的用户名密码。
a)If(rs.next()) { boolean flag = true}
b)通过旗标进行分支跳转

三、实验成果（对应实验内容的代码）
源代码：
Register.html

Login:
age:
Password:

Handle.jsp
<%@page import=“java.sql.*” %>

<% request.setCharacterEncoding("GB2312") ; String name = request.getParameter("name"); String pwd = request.getParameter("password"); String sage = request.getParameter("age"); int age = Integer.parseInt(sage);

   		Class.forName("com.mysql.jdbc.Driver");
   		Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123456");
   		Statement stmt = conn.createStatement();
   		String sql = "insert into person(name,age,password) values('" + name + "',"+ age +"," + "'" + pwd +"')";
   		stmt.executeUpdate(sql);
    %>

Login.html

<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="this is my page">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">

<!--<link rel="stylesheet" type="text/css" href="./styles.css">-->

用户名:
密码:

Check.jsp
<%@ page language=“java” contentType=“text/html; charset=gb2312”%>
<%@page import=“java.sql.*” %>

<% String driver = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql://localhost:3306/test"; String user = "root"; String pwd = "123456"; boolean ok = false;

	String username = request.getParameter("login");
	String password = request.getParameter("password");
	try
	{
		Class.forName(driver);
		Connection conn = DriverManager.getConnection(url,user,pwd);
		PreparedStatement pstmt = conn.prepareStatement
		("select * from person where name=? and password=?");
		pstmt.setString(1,username);
		pstmt.setString(2,password);
		ResultSet rs = pstmt.executeQuery();
		
		if(rs.next())
		{
			ok = true;
			session.setAttribute("ok",username);
	%>		
			<jsp:forward page="success.jsp"></jsp:forward>
	<%}
	    else
	    {
	 %>   
	 		<jsp:forward page="error.jsp"></jsp:forward>
	 <%  }
	}
	catch(Exception e)
	{
		e.printStackTrace();
	}
 %>

Success.jsp
<%@ page language=“java” contentType=“text/html; charset=gb2312”%>

<% if(session.getAttribute("ok")!=null) { %>

<%=session.getAttribute("ok") %>欢迎你！

<%	}
	else
	{
		response.setHeader("refresh","3;url=login.html");
%>
		你还没有登录，请登录！3秒内跳转回登录页面！				
<%}
 %>

Error.jsp
<%@ page language=“java” contentType=“text/html; charset=gb2312”%>

用户名和密码错误！3秒内跳转回登录页面！ <%

	response.setHeader("refresh","3;url=login.html");
 %>