jsp第十周作业
数据库test 中建个表 stu(stuid 主键 自动增长 ,用户名,密码,年龄)
1.设计一个注册页面,实现用户注册功能
2.设计一个登陆页面,实现用户名密码登陆
3.两个页面可以互相超链接
package com.cui; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class BaseDao { public static Connection getConnection() { Connection con = null; try { Class.forName("com.mysql.jdbc.Driver"); con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8","root","123456"); System.out.println(con); } catch (Exception e) { e.printStackTrace(); } return con; } protected static void closeAll(Connection con,PreparedStatement ps,ResultSet rs){ try { if(rs != null) rs.close(); if(ps != null) ps.close(); if(con != null) con.close(); } catch (SQLException e) { e.printStackTrace(); } } }
package com.cui;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class StuDao {
public int Register(String uname, String password, int age) {
int i = -1;
Connection con = BaseDao.getConnection();
String sql = "insert into stu(uname,password,age)values(?,?,?)";
PreparedStatement pred = null;
try {
pred=con.prepareStatement(sql);
pred.setString(1, uname);
pred.setString(2, password);
pred.setInt(3, age);
i = pred.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
BaseDao.closeAll(con, pred, null);
}
return i;
}
public boolean Login(String uname, String password) {
boolean f = false;
Connection con = BaseDao.getConnection();
String sql = "select * from stu where uname=? and password=?";
PreparedStatement pred = null;
ResultSet resultSet = null;
try {
pred = con.prepareStatement(sql);
pred.setString(1, uname);
pred.setString(2, password);
resultSet = pred.executeQuery();
while (resultSet.next()) {
f = true;
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
BaseDao.closeAll(con, pred, resultSet);
}
return f;
}
}
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <% request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); %> <!DOCTYPE HTML> <html> <head> <title>登录</title> </head> <body> <form action="dologin.jsp" method="post"> 账号<input type="text" name="uname"><br> 密码<input type="password" name="password"><br> <input type="submit" value="登录"> <a href="register.jsp">注册</a> </form> </body> </html>
<%@page import="com.cui.StuDao"%> <%@page import="javax.xml.bind.ParseConversionEvent"%> <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <% request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); %> <!DOCTYPE HTML> <html> <head> <title></title> </head> <body> <% String uname = request.getParameter("uname"); String password = request.getParameter("password"); StuDao sd=new StuDao(); if(sd.Login(uname, password)){ request.getRequestDispatcher("index.jsp").forward(request, response); }else{ out.print("登陆失败,3秒后跳回主页"); response.setHeader("refresh", "3;url=login.jsp"); } %> </body> </html>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> 登录成功
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <% request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); %> <!DOCTYPE HTML> <html> <head> <title>注册</title> </head> <body> <form action="doregister.jsp" method="post"> 账号<input type="text" name="uname"><br> 密码<input type="password" name="password"><br> 年龄<input type="number" name="age"><br> <input type="submit" value="注册"> <input type="reset" value="重置"> </form> </body> </html>
<%@page import="com.cui.StuDao"%> <%@page import="javax.xml.bind.ParseConversionEvent"%> <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <% request.setCharacterEncoding("utf-8"); response.setCharacterEncoding("utf-8"); %> <!DOCTYPE HTML> <html> <head> <title></title> </head> <body> <% String uname = request.getParameter("uname"); String password = request.getParameter("password"); String age = request.getParameter("age"); int age1 = age == null ? -1 : Integer.parseInt(age); StuDao sd=new StuDao(); int i=sd.Register(uname, password, age1); if(i>0){ request.getRequestDispatcher("login.jsp").forward(request, response); } %> </body> </html>