用户表： 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="upass" id="pass"></td>
</tr>
验证码：<img src="yanzhengma.jsp"/>
<input type="text" name="code"/>
<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.tea"%>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
tea t = new tea();
String uname = request.getParameter("uname");
t.setUname(uname);
String upass = request.getParameter("upass");
t.setUpass(upass);
Studao sd=new Studao();
if(sd.addStu(t)>0){
//跳转注册成功页面
request.getRequestDispatcher("yes.jsp").forward(request,response);
}else{
//错误页面
request.getRequestDispatcher("no.jsp").forward(request,response);
}
%>
3.yanzhengma.jsp
<%@ page contentType="image/jpeg" language="java" import="java.util.*,java.awt.*,java.awt.image.*,javax.imageio.*" pageEncoding="utf-8"%>
<%!
Color getRandColor(int fc,int bc){
Random random = new Random();
if(fc > 255){
fc = 255;
}
if(bc < 255){
bc = 255;
}
int r = fc +random.nextInt(bc-fc);
int g = fc +random.nextInt(bc-fc);
int b = fc +random.nextInt(bc-fc);
return new Color(r,g,b);
}
%>
<%
//设置页面不缓存
response.setHeader("Pragma","no-cache");
response.setHeader("Cache-Control","no-catch");
response.setDateHeader("Expires",0);
//在内存中创建图象
int width = 60;
int height = 20;
BufferedImage image = new BufferedImage(width,height,BufferedImage.TYPE_INT_RGB);
//创建图象
Graphics g = image.getGraphics();
//生成随机对象
Random random = new Random();
//设置背景色
g.setColor(getRandColor(200,250));
g.fillRect(0,0,width,height);
//设置字体
g.setFont(new Font("Tines Nev Roman",Font.PLAIN,18));
//随机产生干扰线
g.setColor(getRandColor(160,200));
for(int i = 0; i < 255; i++){
int x = random.nextInt(width);
int y = random.nextInt(height);
int xl = random.nextInt(12);
int yl = random.nextInt(12);
}
//随机产生认证码,4位数字
String sRand = "";
for(int i = 0; i < 4; i++){
String rand = String.valueOf(random.nextInt(10));
sRand += rand;
//将认证码显示到图象中
g.setColor(new Color(20 + random.nextInt(110),20 + random.nextInt(110),20 + random.nextInt(110)));
g.drawString(rand,13*i+6,16);
}
session.setAttribute("rCode",sRand);
//图像生效
g.dispose();
//输出图像到页面
ImageIO.write(image,"JPEG",response.getOutputStream());
out.clear();
out = pageContext.pushBody();
%>
4.yes.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">欢迎亲</h1><br>
<h4 style="color: blue">注册成功</h4><br>
</html>
5.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>
6.com.gd.bean.tea.java
package com.gd.bean;
public class tea {
private int uid;
private String uname;
private String upass;
//访问器
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 getUpass() {
return upass;
}
public void setUpass(String upass) {
this.upass = upass;
}
//构造器
public tea(int uid, String uname, String upass) {
super();
this.uid = uid;
this.uname = uname;
this.upass = upass;
}
public tea() {
super();
}
}
7.com.gd.dao.Studao.java
package com.gd.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import com.gd.bean.tea;
public class Studao {
//学生数据访问类
//添加学生
public int addStu(tea t){
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 tea values(?,?,?)";
//执行
PreparedStatement ps=con.prepareStatement(sql);
ps.setInt(1, t.getUid());
ps.setString(2, t.getUname());
ps.setString(3, t.getUpass());
i=ps.executeUpdate();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return i;
}
//删除学生
//登录
//查询全部
//修改学生信息
}