用户表： uid (主键，自动增长) uname upwd
使用分层实现注册。（必做）
使用分层实现登录。（选做）
1.登陆界面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 style="background:url(images/2.jpg)"> <div class="contentArea"> <form name="form1" method="post" action="control.jsp" > <table> <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> </tr> </table> </form> </body> </html>
2.数据处理control.jsp
<%@page import="com.gd.dao.StuDao"%> <%@page import="com.gd.bean.Stu"%> <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <% Stu s = new Stu(); 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){ //跳转注册成功页面 request.getRequestDispatcher("welcome.jsp").forward(request,response); }else{ //错误页面 request.getRequestDispatcher("no.jsp").forward(request,response); } %>
2.注册成功界面welcome.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> </head> <body> <% String uname = (String) request.getSession().getAttribute("uname"); %> <body style="background:url(images/2.jpg)"> <div class="contentArea"> <h1 style="color: red">欢迎<%=uname%></h1><br> <h4 style="color: blue">哦耶，注册成功了呢-_-</h4><br> </html>
3.注册失败界面no.jsp
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <html> <head> </head> <body style="background:url(images/2.jpg)"> <div class="contentArea"> <h1>注册失败</h1><hr> <h2>点击重新<a href="index.jsp">注册</a></h2> </body> </html>
4.src-pacage-com.gb.bean-class-Stu.java界面
package com.gd.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(); } }
5.src-pacage-com.gb.dao-class-StuDao.java界面
package com.gd.dao; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import com.gd.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/mysql", "root", ""); //写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; } //删除学生 //登录 //查询全部 //修改学生信息 }
