用户表： uid (主键，自动增长) uname upwd
使用分层实现注册。（必做）
使用分层实现登录。（选做）
index.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>"> <title>My JSP 'index.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> </head> <body> <form name="form1" method="post" action="control.jsp" > <table> <tr> <td>编号：</td> <td> <input type="text" name="sid" id="userName" ></td> </tr> <tr> <td>用户名：</td> <td> <input type="text" name="uname" id="userName" ></td> </tr> <tr> <td>输入登录密码：</td> <td><input type="password" name="upwd" id="pwd"></td> </tr> <tr> <td colspan="2"><input type="submit" value="注册" ></td> <td colspan="2" style=""><input type="submit" value="登录" ></td> </tr> </table> </form> </body> </html>
control.jsp
<%@page import="com.mfb.dao.StuDao"%> <%@page import="com.mfb.bean.Stu"%> <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <% Stu s = new Stu(); int id = Integer.parseInt(request.getParameter("sid")); s.setUid(id); String uname = request.getParameter("uname"); s.setUname(uname); String upwd = request.getParameter("upwd"); s.setUpwd(upwd); StuDao sd = new StuDao(); if (sd.addStu(s) > 0) { //跳转注册成功页面 out.print("注册成功"); } else { //错误页面 out.print("注册失败，请重新输入"); } %>
Stu.java
package com.mfb.bean;
public class Stu {
private int uid;
private String uname;
private String upwd;
// 访问器
public int getUid() {
return uid;
}
public void setUid(int uid) {
this.uid = uid;
}
public String getUname() {
return uname;
}
public void setUname(String uname) {
this.uname = uname;
}
public String getUpwd() {
return upwd;
}
public void setUpwd(String upwd) {
this.upwd = upwd;
}
// 构造器
public Stu(int uid, String uname, String upwd) {
super();
this.uid = uid;
this.uname = uname;
this.upwd = upwd;
}
public Stu() {
super();
}
}
StuDao.java
package com.mfb.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import com.mfb.bean.Stu;
public class StuDao {
// 学生数据访问类
// 添加学生
public int addStu(Stu s) {
int i = 0;
try {
// 加载驱动
Class.forName("com.mysql.jdbc.Driver");
// 建立连接
Connection con = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/log", "root", "421317");
// 写SQL语句
String sql = "insert into stu values(?,?,?)";
// 执行
PreparedStatement ps = con.prepareStatement(sql);
ps.setInt(1, s.getUid());
ps.setString(2, s.getUname());
ps.setString(3, s.getUpwd());
i = ps.executeUpdate();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return i;
}
}
