第十周作业
数据库test 中建个表 stu(stuid 主键 自动增长 ,用户名,密码,年龄)
1.设计一个注册页面,实现用户注册功能
2.设计一个登陆页面,实现用户名密码登陆
3.两个页面可以互相超链接
package com.a98.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class BaseDao {
public Connection getConnection() {
Connection con = null;
try {
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123456");
} catch (Exception e) {
e.printStackTrace();
}
return con;
}
protected 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.a98.jdbc;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class StuDao extends BaseDao {
public int Register(String uname, String password, int age) {
int i = -1;
Connection con = 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 {
closeAll(con, pred, null);
}
return i;
}
public boolean Login(String uname, String password) {
boolean f=false;
Connection con = 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 {
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> <h1>注册</h1> <form action="doregister.jsp" method="post"> <table> <tr> <td>用户名</td> <td><input type="text" name="uname"></td> </tr> <tr> <td>密码</td> <td><input type="password" name="password"></td> </tr> <tr> <td>年龄</td> <td><input type="number" name="age"></td> </tr> <tr> <td><input type="submit" value="注册"></td> <td><input type="reset" value="重置"></td> </tr> </table> </form> </body> </html>
<%@page import="qmt.StuDao"%> <%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <html> <head> <title>判断</title> </head> <body> <% String uname = request.getParameter("uname"); String pwd = request.getParameter("pwd"); qmt.StuDao sd = new qmt.StuDao(); if (sd.login(uname, pwd)) { %> <h1>登录成功</h1> <% } else { %> <h1>登录失败,3秒后返回登录界面</h1> <% response.setHeader("refresh", "3;url=login.jsp"); } %> </body> </html>