验证码登陆 简单学生管理

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DBUtil {
    static String driver = "oracle.jdbc.driver.OracleDriver";
    static String url = "jdbc:oracle:thin:@localhost:1521:orcl";
    static String username = "superyang";
    static String password = "orcl";
    
    //==========添加驱动，连接数据库 方法==============================
    public static Connection getConnection(){            
        Connection conn = null;
        
        try {    //1.添加驱动        
            Class.forName(driver);            
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        try {    //2.创建数据库连接对象
            conn = DriverManager.getConnection(url,username,password);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return conn;        
    }
    
    //==========释放资源方法=====================================
    public static void free(ResultSet rs,Statement sm,Connection conn){
        
            try {
                
                if(rs!=null){
                    rs.close();
                }
                
                if(sm!=null){
                    sm.close();
                }
                
                if(conn!=null){
                    conn.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        
    }
}

import java.awt.Color;
import java.awt.Font;
import java.awt.Graphics;
import java.awt.image.BufferedImage;
import java.io.IOException;
import java.util.Random;
import javax.imageio.ImageIO;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.xml.ws.Response;

public class ImageServlet extends HttpServlet{
    @Override
    public void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        //通知浏览器不要缓存
        resp.setHeader("Expires", "-1");
        resp.setHeader("Cache-Control", "no-cache");
        resp.setHeader("Prama", "no-cache");
        
        int width=120;
        int height=50;
        //在内存中创建一幅图
        BufferedImage bu = new BufferedImage(width, height,BufferedImage.TYPE_INT_RGB);
        //得到一个画笔
        Graphics gr = bu.getGraphics();
        //画边框
        gr.setColor(Color.gray);        
        gr.drawRect(0, 0, width, height);
        //背景
        gr.setColor(Color.pink);
        gr.fillRect(1, 1, width-2, height-2);
        //干扰线
        Random ran = new Random();
        gr.setColor(Color.black);
        for(int i=0;i<=10;i++){            
            gr.drawLine(ran.nextInt(width), ran.nextInt(height), ran.nextInt(width), ran.nextInt(height));
        }
        //验证码
        gr.setColor(Color.red);
        gr.setFont(new Font("宋体", Font.BOLD|Font.ITALIC, 35));
        int x =18;
        String s ="";
        for(int j=0;j<4;j++){
            s+=ran.nextInt(10)+"";
            gr.drawString(s.substring(j,j+1), x, 35);
            x+=25;
            
        }
        req.getSession().setAttribute("racode", s);
        //System.out.println(s);
        //输出到网页上
        ImageIO.write(bu, "jpg", resp.getOutputStream());
    }
    
    
    
    @Override
    public void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doGet(req, resp);
    }
    
    
    
}

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class Register extends HttpServlet{
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("UTF-8");
        resp.setCharacterEncoding("UTF-8");
        String rid = req.getParameter("rid");  //得到请求参数
        String rname = req.getParameter("rname");
        String rsex = req.getParameter("rsex");
        String rage = req.getParameter("rage");
        String raddress = req.getParameter("raddress");
        String rpass = req.getParameter("rpass");
        String rsf = req.getParameter("rsf");
        
        Connection conn = DBUtil.getConnection();
        PreparedStatement ps = null;
        ResultSet rs = null;
        String sql = "insert into users values(?,?,?,?,?,?,?)";
        try {
            ps = conn.prepareStatement(sql);
            ps.setString(1, rid);
            ps.setString(2, rname);
            ps.setString(3, rsex);
            ps.setString(4, rage);
            ps.setString(5, raddress);
            ps.setString(6, rpass);    
            ps.setString(7, rsf);    
            
            int i =ps.executeUpdate();
            if(i>0){
                
                //req.setAttribute("reg", "reg");
                resp.sendRedirect("regi.jsp");            
            }else{
                System.out.println("用户操作失败");    
                resp.sendRedirect("index.jsp");                
            }
            DBUtil.free(rs, ps, conn);
        } catch (SQLException e) {    
            //e.printStackTrace();
            System.out.println("用户异常操作失败");    
            resp.sendRedirect("index.jsp");
        }
        
        
    }
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doPost(req, resp);
    }
}

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class Login extends HttpServlet {
    @Override
    public void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("UTF-8");
        resp.setCharacterEncoding("UTF-8");
        String uid = req.getParameter("uid");  //得到请求参数
        String upass = req.getParameter("upass");
        String usf = req.getParameter("usf");
        String code = req.getParameter("code");
        String racode = (String)req.getSession().getAttribute("racode");
        Connection conn = DBUtil.getConnection();
        PreparedStatement ps = null;
        ResultSet rs = null;
        boolean flog = false;
        if(racode.equals(code)){            
        //System.out.println(code+"==="+racode);
        if(usf.equals("学生")){
            String sql = "select name from users where id=? and password=? and sf=?";
            try {
                ps = conn.prepareStatement(sql);
                ps.setString(1, uid);
                ps.setString(2, upass);
                ps.setString(3, usf);
                rs = ps.executeQuery();
                while(rs.next()){
                    System.out.println("学生登陆成功,2秒后跳转页面");
                    req.getSession().setAttribute("showname", rs.getString(1));
                    //req.getSession().setAttribute("ssf", "学生");    
                    if(rs.getString(1)==null){
                        resp.sendRedirect("index.jsp");
                    }
                    flog=true;
                }
                if(flog=false){
                    System.out.println("登陆错误，请重新选择");//
                    resp.sendRedirect("index.jsp");
                }else{
                    resp.sendRedirect("logins.jsp");
                }            
            } catch (Exception e) {                
                System.out.println("登陆错误，请重新选择");                
            }
        }else if(usf.equals("教师")){
            String sql = "select name from users where id=? and password=? and sf=?";
            try {
                ps = conn.prepareStatement(sql);
                ps.setString(1, uid);
                ps.setString(2, upass);
                ps.setString(3, usf);
                rs = ps.executeQuery();
                while(rs.next()){
                    System.out.println("教师登陆成功,2秒后跳转页面");
                    req.getSession().setAttribute("showname", rs.getString(1));
                    //req.setAttribute("tsf", "教师");
                    if(rs.getString(1)==null){
                        resp.sendRedirect("index.jsp");
                    }
                    flog=true;
                }
                if(flog=false){
                    System.out.println("登陆错误，请重新选择");//
                    resp.sendRedirect("index.jsp");
                }else{
                    resp.sendRedirect("logint.jsp");
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        }else{
            System.out.println("验证码输入错误");            
        }
    } 
    @Override
    public void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doGet(req, resp);
    }
}

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class Insertstu extends HttpServlet{
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("UTF-8");
        resp.setCharacterEncoding("UTF-8");
        String rid = req.getParameter("rid");  //得到请求参数
        String rname = req.getParameter("rname");
        String rsex = req.getParameter("rsex");
        String rage = req.getParameter("rage");
        String raddress = req.getParameter("raddress");
        String rpass = req.getParameter("rpass");
        String rsf = req.getParameter("rsf");
        
        Connection conn = DBUtil.getConnection();
        PreparedStatement ps = null;
        ResultSet rs = null;
        String sql = "insert into users values(?,?,?,?,?,?,?) and sf='学生'";
        try {
            ps = conn.prepareStatement(sql);
            ps.setString(1, rid);
            ps.setString(2, rname);
            ps.setString(3, rsex);
            ps.setString(4, rage);
            ps.setString(5, raddress);
            ps.setString(6, rpass);    
            ps.setString(7, rsf);    
            
            int t =ps.executeUpdate();
            if(t>0){
                System.out.println("学生信息创建成功");    
                //req.getSession().setAttribute("ins", "ins");
                resp.sendRedirect("success.jsp");                
            }else{
                System.out.println("用户操作失败");    
                resp.sendRedirect("error.jsp");
                
            }
            
        } catch (SQLException e) {    
            //e.printStackTrace();
            System.out.println("用户操作异常失败");    
            resp.sendRedirect("error.jsp");
        }    
    }
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doPost(req, resp);
    }
}

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class Deletestu extends HttpServlet{
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("UTF-8");
        resp.setCharacterEncoding("UTF-8");
        String rid = req.getParameter("rid");  //得到请求参数
        
        Connection conn = DBUtil.getConnection();
        PreparedStatement ps = null;
        ResultSet rs = null;
        String sql = "delete from users where id=? and sf='学生'";
        try {
            ps = conn.prepareStatement(sql);
            ps.setString(1, rid);
            int i =ps.executeUpdate();
            if(i>0){
                //req.setAttribute("del", "del");
                resp.sendRedirect("success.jsp");    
            }else{
                System.out.println("用户操作失败");    
                resp.sendRedirect("error.jsp");                
            }
            DBUtil.free(rs, ps, conn);
        } catch (SQLException e) {    
            //e.printStackTrace();
            System.out.println("用户异常操作失败");    
            resp.sendRedirect("error.jsp");
        }    
    }
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doPost(req, resp);
    }
}

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class Updatestu extends HttpServlet{
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("UTF-8");
        resp.setCharacterEncoding("UTF-8");
        String rid = req.getParameter("rid");  //得到请求参数
        String rname = req.getParameter("rname");
        String rsex = req.getParameter("rsex");
        String rage = req.getParameter("rage");
        String raddress = req.getParameter("raddress");
        String rpass = req.getParameter("rpass");
        String rsf = req.getParameter("rsf");
        
        Connection conn = DBUtil.getConnection();
        PreparedStatement ps = null;
        ResultSet rs = null;
        String sql = "update users set name=?,sex=?,age=?,address=?,password=?,sf=? where id=? and sf='学生'";
        try {
            ps = conn.prepareStatement(sql);            
            ps.setString(1, rname);
            ps.setString(2, rsex);
            ps.setString(3, rage);
            ps.setString(4, raddress);
            ps.setString(5, rpass);    
            ps.setString(6, rsf);    
            ps.setString(7, rid);            
            int i =ps.executeUpdate();
            if(i>0){
                //req.setAttribute("upd", "upd");
                resp.sendRedirect("success.jsp");                
            }else{
                System.out.println("用户操作失败");    
                resp.sendRedirect("error.jsp");                
            }
            DBUtil.free(rs, ps, conn);
        } catch (SQLException e) {    
            //e.printStackTrace();
            System.out.println("用户异常操作失败");    
            resp.sendRedirect("error.jsp");
        }            
    }
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doPost(req, resp);
    }
}

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class Selectstu extends HttpServlet{
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("UTF-8");
        resp.setCharacterEncoding("UTF-8");
        String rid = req.getParameter("rid");  //得到请求参数
        
        Connection conn = DBUtil.getConnection();
        PreparedStatement ps = null;
        ResultSet rs = null;
        String sql = "select * from users where id=? and sf='学生'";
        try {
            ps = conn.prepareStatement(sql);
            ps.setString(1, rid);
            rs = ps.executeQuery();  //执行语句
            while(rs.next()){
                
                req.getSession().setAttribute("id", rs.getString(1));
                req.getSession().setAttribute("name", rs.getString(2));
                req.getSession().setAttribute("sex", rs.getString(3));
                req.getSession().setAttribute("age", rs.getString(4));
                req.getSession().setAttribute("address", rs.getString(5));
                req.getSession().setAttribute("password", rs.getString(6));
                req.getSession().setAttribute("sf", rs.getString(7));
            }        
            int i =ps.executeUpdate();
            if(i>0){    
                resp.sendRedirect("sele.jsp");    
            }else{
                System.out.println("用户操作失败");    
                resp.sendRedirect("error.jsp");                
            }            
            DBUtil.free(rs, ps, conn);
        } catch (SQLException e) {    
            System.out.println("用户异常操作失败");    
            resp.sendRedirect("error.jsp");
        }    
    }
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doPost(req, resp);
    }
}

二：JSP

<%@ page language="java" contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <title>首页</title>    
        <script type="text/javascript" >
            function tofresh(){
                document.location.href="index.jsp";
            }
            var b=true;
            function checkname(obj){
                var name = obj.value;
                var pattern=/^d{4}$/;    
                if(name.match(pattern)==null){
                    document.getElementById("user").innerHTML="<font color='red'>请输入4位数字ID</font>";
                    document.getElementById("username").value="";
                    b = false;
                }else{
                    document.getElementById("user").innerHTML="<font color='green'>ID合法</font>";
                    
                }    
            }
            function checkpass1(obj){
                var pass = obj.value;
                var pattern=/^d{6}$/;    
                if(pass.match(pattern)==null){
                    document.getElementById("pass1").innerHTML="<font color='red'>6位数字密码</font>";
                    document.getElementById("pw1").value="";
                    b = false;
                }else{
                    document.getElementById("pass1").innerHTML="<font color='green'>密码合法</font>";
                    
                }    
            }
            function checksf(obj){
                var sf = obj.value;
                    
                if((sf=="学生")||(sf=="教师")){
                    document.getElementById("shenf").innerHTML="<font color='green'>已选择</font>";
                }else{                    
                    document.getElementById("shenf").innerHTML="<font color='red'>请重新选择</font>";
                    document.getElementById("sf").value="";
                    b = false;
                }    
            }
            function checkyzm(obj){
                var name = obj.value;
                var pattern=/^d{4}$/;    
                if(name.match(pattern)==null){
                    document.getElementById("codeyzm").innerHTML="<font color='red'>请输入4位数字验证码</font>";
                    document.getElementById("yzm").value="";
                    b = false;
                }else{
                    document.getElementById("codeyzm").innerHTML="<font color='green'>验证码格式合法</font>";
                    
                }    
            }
            function subm(){
                return b;
            }
        </script>
        
    </head>
    <body bgcolor=rgb(180,205,230)>
        <form action="login" method="post" onsubmit="return subm()">
            <div align="center">
            <h1>欢迎登陆学生管理系统</h1><hr  color="red"><br/>
            <table border="1" cellpadding="0" cellspacing="0" name="mytable" bgcolor="white">
                <tr>
                    <td>用户ID:</td>
                    <td><input type="text" name="uid" id="username" onblur="checkname(this)"></td>
                    <td><div id="user"><font color="red">*<font></div></td>
                </tr>
                <tr>
                    <td>登陆密码:</td>
                    <td><input type="password" name="upass" id="pw1" onblur="checkpass1(this)"></td>
                    <td><div id="pass1"><font color="red">*<font></div></td>
                </tr>                
                <tr>
                    <td>登陆身份:</td>
                    <td>
                        <select name="usf" id="sf" onblur="checksf(this)">
                            <option value="" selected="seleected">==请选择==</option>
                            <option value="学生" >学生</option>
                            <option value="教师" >教师</option>
                        </select>
                    </td>
                    <td><div id="shenf"><font color="red">*<font></div></td>
                </tr>
                <tr>
                    <td>验证码:</td>
                    <td><input type="text" name="code" id="yzm" onblur="checkyzm(this)"></td>
                    <td><div id="codeyzm"><font color="red">*<font></div></td>
                </tr>    
                <tr>
                    <td><img alt="验证码" src="ImageServlet"></td>            
                    <td><a href="javascript:tofresh()">看不清，请再换一张</a></td>
                </tr>    
            </table>                
            <br/>
                <input type="submit" value="登陆" >
                <a href="register.jsp"><input type="button" value="注册"></a>
            </div>
        </form>
    </body>
</html>

<%@ page language="java" contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <title>jump</title>
    </head>
    <body bgcolor=rgb(180,205,230)>
        <%                         
            request.setCharacterEncoding("UTF-8");
            if(session.getAttribute("showname")!=null){    
        %>

            <%        
                response.setHeader("refresh","2;smenu.jsp");
            %>
                <h2>登陆成功，两秒后跳转</h2>
                <h1>如果没有跳转，请点击<a href="smenu.jsp">这里</a></h1>
        <%    
        }else{
        %>
        <div align="right" class="fd">    
            请先<a href="index.jsp">登录</a>
        </div>
        <%    
        }
        %>
    </body>
</html>

<%@ page language="java" contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <title>jump</title>
    </head>
    <body bgcolor=rgb(180,205,230)>
        <%                         
            request.setCharacterEncoding("UTF-8");
            if(session.getAttribute("showname")!=null){    
        %>
            
            <%        
                response.setHeader("refresh","2;tmenu.jsp");
            %>
                <h2>登陆成功，两秒后跳转</h2>
                <h1>如果没有跳转，请点击<a href="tmenu.jsp">这里</a></h1>
        <%    
        }else{
        %>
        <div align="right" class="fd">    
            请先<a href="index.jsp">登录</a>
        </div>
        <%    
        }
        %>
    </body>
</html>

<%@ page language="java" contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <title>Insert title here</title>
    </head>
    <body bgcolor=rgb(180,205,230)>
        <%                         
            request.setCharacterEncoding("UTF-8");
            if(session.getAttribute("showname")!=null){    
        %>
            <%
                session.invalidate();
                response.setHeader("refresh","1;index.jsp");
            %>
            <h2>注销成功，</h2>
            <h1>如果没有跳转，请点击<a href="index.jsp">这里</a></h1>
        <%    
        }else{
        %>
        <div align="right" class="fd">    
            请先<a href="index.jsp">登录</a>
        </div>
        <%    
        }
        %>
    </body>
</html>

<%@ page language="java" contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <title>jump</title>
    </head>
    <body bgcolor=rgb(180,205,230)>
            
            <% 
            request.setCharacterEncoding("UTF-8");
            %>        
            <h2>操作出现错误。</h2>
    
    </body>
</html>

<%@ page language="java" contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <title>Insert title here</title>
        
        
    </head>
    <body bgcolor=rgb(180,205,230)>
        <% 
        request.setCharacterEncoding("UTF-8");
        if(session.getAttribute("showname")!=null){    
        %>    
             <div align="right" class="fd">                    
                <%=session.getAttribute("showname") %>
                <a href="index.jsp" >注销</a>
            </div>     
        
         
            <ol>
                
                <li>更改个人信息</li>
                <li>查看个人信息</li>                
            </ol>
            
            
        <%    
        }else{
        %>
        <div align="right" class="fd">    
            请先<a href="index.jsp">登录</a>
        </div>
        <%    
        }
        %>
    
    </body>
</html>

<%@ page language="java" contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <title>Insert title here</title>

    </head>
    <body bgcolor=rgb(180,205,230)>
        
            <%                         
            request.setCharacterEncoding("UTF-8");
            if(session.getAttribute("showname")!=null){    
            %>    
                 <div align="right" class="fd">                    
                    <%=session.getAttribute("showname") %>
                    <a href="index.jsp" >注销</a>
                </div>     
                  <h1>学生管理界面</h1><hr color="red"><br/>                     
                <ul>
                    <a href="insert_student.jsp" target="iframe_a"><li>添加学生信息</li></a>
                    <a href="delete_student.jsp" target="iframe_a"><li>删除学生信息</li></a>
                    <a href="update_student.jsp" target="iframe_a"><li>更改学生信息</li></a>
                    <a href="select_student.jsp" target="iframe_a"><li>查看学生信息</li></a>
                                
                </ul>
                <div align="right">
                    <iframe src="#" name="iframe_a"  width="700" height="700" frameborder="0">                
                    </iframe>        
                </div>
            <%    
            }else{
            %>
            <div align="right" class="fd">    
                请先<a href="index.jsp">登录</a>
            </div>
            <%    
            }
            %>
    
    </body>
</html>

<%@ page language="java" contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <title>jump</title>
    </head>
    <body bgcolor=rgb(180,205,230)>
        
            <% 
            request.setCharacterEncoding("UTF-8");
            %>        
            <h2>操作成功，请选择。</h2>
            
    </body>
</html>

<%@ page language="java" contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <title>jump</title>
    </head>
    <body bgcolor=rgb(180,205,230)>
        <%                         
            request.setCharacterEncoding("UTF-8");
            if(session.getAttribute("showname")!=null){    
        %>
            
            <%        
                response.setHeader("refresh","2;index.jsp");
            %>
                <h2>注册成功，两秒后跳转至首页</h2>
                <h1>如果没有跳转，请点击<a href="index.jsp">这里</a></h1>
        <%    
        }else{
        %>
        <div align="right" class="fd">    
            请先<a href="index.jsp">登录</a>
        </div>
        <%    
        }
        %>
    </body>
</html>

<%@ page language="java" contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <title>注册</title>
        <script type="text/javascript" >
            function checkid(obj){
                var id=obj.value;
                var pa=/^d{4}$/;
                if(id.match(pa)==null){
                    document.getElementById("userid").innerHTML="<font color='red'>请输入4位数字ID</font>";
                    document.getElementById("rid").value="";
                }else{
                    document.getElementById("userid").innerHTML="<font color='green'>ID合法</font>";
                }
            }
            function checkname(obj){
                var name = obj.value;
                var pa=/^D{1,20}$/;    
                if(name.match(pa)==null){
                    document.getElementById("username").innerHTML="<font color='red'>请输入用户名</font>";
                    document.getElementById("rname").value="";
                    b = false;
                }else{
                    document.getElementById("username").innerHTML="<font color='green'>用户名合法</font>";                
                }    
            }
            function checksex(obj){
                var sex=obj.value;
                var pa=/^D$/;
                if(sex.match(pa)==null){
                    document.getElementById("usersex").innerHTML="<font color='red'>请输入性别</font>";
                    document.getElementById("rsex").value="";
                }else{
                    document.getElementById("usersex").innerHTML="<font color='green'>性别输入合法</font>";
                }
            }
            function checkage(obj){
                var age = obj.value;
                var pa=/^d{1,3}/;    
                if(age.match(pa)==null){
                    document.getElementById("userage").innerHTML="<font color='red'>请输入年龄</font>";
                    document.getElementById("rage").value="";
                    b = false;
                }else{
                    document.getElementById("userage").innerHTML="<font color='green'>年龄输入合法</font>";                
                }    
            }
            function checkaddr(obj){
                var raddr = obj.value;
                var pa=/^D{1,20}/;    
                if(raddr.match(pa)==null){
                    document.getElementById("useraddr").innerHTML="<font color='red'>请输入地址</font>";
                    document.getElementById("raddr").value="";
                    b = false;
                }else{
                    document.getElementById("useraddr").innerHTML="<font color='green'>地址输入合法</font>";                
                }    
            }
            function checkpass(obj){
                var rpass = obj.value;
                var pa=/^d{6}/;    
                if(rpass.match(pa)==null){
                    document.getElementById("userpass").innerHTML="<font color='red'>请输入密码</font>";
                    document.getElementById("rpass").value="";
                    b = false;
                }else{
                    document.getElementById("userpass").innerHTML="<font color='green'>密码输入合法</font>";                
                }    
            }
            function checksf(obj){
                var rsf = obj.value;
                    
                if((rsf=="学生")||(rsf=="教师")){
                    document.getElementById("usersf").innerHTML="<font color='green'>已选择</font>";
                }else{                    
                    document.getElementById("usersf").innerHTML="<font color='red'>请重新选择</font>";
                    document.getElementById("rsf").value="";
                    b = false;
                }    
            }            
        </script>    
    </head>
    <body bgcolor=rgb(180,205,230)>
        <div align="center">
        <form action="checkregister" method="post">        
            <table border="1" cellpadding="0" cellspacing="0" name="mytable" bgcolor="white"> 
                <tr>
                    <td>用户ID:</td>
                    <td><input type="text" name="rid" id="rid" onblur="checkid(this)"></td>
                    <td><div id="userid"><font color="red">*<font></div></td>
                </tr>
                <tr>
                    <td>姓名:</td>
                    <td><input type="text" name="rname" id="rname" onblur="checkname(this)"></td>
                    <td><div id="username"><font color="red">*<font></div></td>
                </tr>
                <tr>
                    <td>性别:</td>
                    <td><input type="text" name="rsex" id="rsex" onblur="checksex(this)"></td>
                    <td><div id="usersex"><font color="red">*<font></div></td>
                </tr>
                <tr>
                    <td>年龄:</td>
                    <td><input type="text" name="rage" id="rage" onblur="checkage(this)"></td>
                    <td><div id="userage"><font color="red">*<font></div></td>
                </tr>
                <tr>
                    <td>地址:</td>
                    <td><input type="text" name="raddr" id="raddr" onblur="checkaddr(this)"></td>
                    <td><div id="useraddr"><font color="red">*<font></div></td>
                </tr>
                <tr>
                    <td>密码:</td>
                    <td><input type="password" name="rpass" id="rpass" onblur="checkpass(this)"></td>
                    <td><div id="userpass"><font color="red">*<font></div></td>
                </tr>
                <tr>
                    <td>身份:</td>
                        <td>
                            <select name="rsf" id="rsf" onblur="checksf(this)">
                                <option value="学生" selected="seleected">学生</option>
                                <option value="教师" >教师</option>
                            </select>
                        </td>
                    <td><div id="usersf"><font color="red">*<font></div></td>
                </tr>
                </table>                        
            </form>
                <input type="submit" value="注册">
                <input type="reset" ><br/>    
            </div>    
    </body>
</html>

<%@ page language="java" contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head bgcolor=rgb(180,205,230)>
        <title>注册</title>
        <script type="text/javascript" >
            function checkid(obj){
                var id=obj.value;
                var pa=/^d{4}$/;
                if(id.match(pa)==null){
                    document.getElementById("userid").innerHTML="<font color='red'>请输入4位数字ID</font>";
                    document.getElementById("rid").value="";
                }else{
                    document.getElementById("userid").innerHTML="<font color='green'>ID合法</font>";
                }
            }
            function checkname(obj){
                var name = obj.value;
                var pa=/^D{1,20}$/;    
                if(name.match(pa)==null){
                    document.getElementById("username").innerHTML="<font color='red'>请输入用户名</font>";
                    document.getElementById("rname").value="";
                    b = false;
                }else{
                    document.getElementById("username").innerHTML="<font color='green'>用户名合法</font>";                
                }    
            }
            function checksex(obj){
                var sex=obj.value;
                var pa=/^D$/;
                if(sex.match(pa)==null){
                    document.getElementById("usersex").innerHTML="<font color='red'>请输入性别</font>";
                    document.getElementById("rsex").value="";
                }else{
                    document.getElementById("usersex").innerHTML="<font color='green'>性别输入合法</font>";
                }
            }
            function checkage(obj){
                var age = obj.value;
                var pa=/^d{1,3}/;    
                if(age.match(pa)==null){
                    document.getElementById("userage").innerHTML="<font color='red'>请输入年龄</font>";
                    document.getElementById("rage").value="";
                    b = false;
                }else{
                    document.getElementById("userage").innerHTML="<font color='green'>年龄输入合法</font>";                
                }    
            }
            function checkaddr(obj){
                var raddr = obj.value;
                var pa=/^D{1,20}/;    
                if(raddr.match(pa)==null){
                    document.getElementById("useraddr").innerHTML="<font color='red'>请输入地址</font>";
                    document.getElementById("raddr").value="";
                    b = false;
                }else{
                    document.getElementById("useraddr").innerHTML="<font color='green'>地址输入合法</font>";                
                }    
            }
            function checkpass(obj){
                var rpass = obj.value;
                var pa=/^d{6}/;    
                if(rpass.match(pa)==null){
                    document.getElementById("userpass").innerHTML="<font color='red'>请输入密码</font>";
                    document.getElementById("rpass").value="";
                    b = false;
                }else{
                    document.getElementById("userpass").innerHTML="<font color='green'>密码输入合法</font>";                
                }    
            }
            function checksf(obj){
                var rsf = obj.value;
                    
                if((rsf=="学生")){
                    document.getElementById("usersf").innerHTML="<font color='green'>已选择</font>";
                }else{                    
                    document.getElementById("usersf").innerHTML="<font color='red'>请重新选择</font>";
                    document.getElementById("rsf").value="";
                    b = false;
                }    
            }            
        </script>
    </head>
    <body bgcolor=rgb(180,205,230)>
        <%                         
            request.setCharacterEncoding("UTF-8");
            if(session.getAttribute("showname")!=null){    
        %>
            <div align="left">
            <form action="insertstu" method="post">
                <table border="1" cellpadding="0" cellspacing="0" name="mytable" bgcolor="white">
                <tr>
                    <td>用户ID:</td>
                    <td><input type="text" name="rid" id="rid" onblur="checkid(this)"></td>
                    <td><div id="userid"><font color="red">*<font></div></td>
                </tr>
                <tr>
                    <td>姓名:</td>
                    <td><input type="text" name="rname" id="rname" onblur="checkname(this)"></td>
                    <td><div id="username"><font color="red">*<font></div></td>
                </tr>
                <tr>
                    <td>性别:</td>
                    <td><input type="text" name="rsex" id="rsex" onblur="checksex(this)"></td>
                    <td><div id="usersex"><font color="red">*<font></div></td>
                </tr>
                <tr>
                    <td>年龄:</td>
                    <td><input type="text" name="rage" id="rage" onblur="checkage(this)"></td>
                    <td><div id="userage"><font color="red">*<font></div></td>
                </tr>
                <tr>
                    <td>地址:</td>
                    <td><input type="text" name="raddr" id="raddr" onblur="checkaddr(this)"></td>
                    <td><div id="useraddr"><font color="red">*<font></div></td>
                </tr>
                <tr>
                    <td>密码:</td>
                    <td><input type="password" name="rpass" id="rpass" onblur="checkpass(this)"></td>
                    <td><div id="userpass"><font color="red">*<font></div></td>
                </tr>
                <tr>
                    <td>身份:</td>
                        <td>
                            <select name="rsf" id="rsf" onblur="checksf(this)">
                                <option value="学生" selected="seleected">学生</option>
                            </select>
                        </td>
                    <td><div id="usersf"><font color="red">*<font></div></td>
                </tr>
                </table>                    
                
            </form>
                <input type="submit" value="注册">
                <input type="reset" ><br/>
            </div>
        <%    
        }else{
        %>
        <div align="right" class="fd">    
            请先<a href="index.jsp">登录</a>
        </div>
        <%    
        }
        %>
    </body>
</html>

<%@ page language="java" contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <title>删除</title>
    </head>
    <body bgcolor=rgb(180,205,230)>
        <%                         
            request.setCharacterEncoding("UTF-8");
            if(session.getAttribute("showname")!=null){    
        %>    
    
            <form action="deletestu" method="post">
                学生ID<input type="text" name="rid"><br/>                
                <input type="submit" value="删除">
                <input type="reset" ><br/>
            </form>
        <%    
        }else{
        %>
        <div align="right" class="fd">    
            请先<a href="index.jsp">登录</a>
        </div>
        <%    
        }
        %>        
    </body>
</html>

<%@ page language="java" contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <title>注册</title>
    </head>
    <body bgcolor=rgb(180,205,230)>
        <%                         
            request.setCharacterEncoding("UTF-8");
            if(session.getAttribute("showname")!=null){    
        %>
            <form action="updatestu" method="post">
                要更改的学生ID<input type="text" name="rid"><br/>
                <h4>请输入更改后的信息：</h4>
                学生姓名:<input type="text" name="rname"><br/>
                学生性别:<input type="text" name="rsex"><br/>
                学生年龄:<input type="text" name="rage"><br/>
                学生地址:<input type="text" name="raddress"><br/>
                学生密码:<input type="text" name="rpass"><br/>            
                身份:<select name="rsf">
                            <option value="学生" selected="seleected">学生</option>                        
                    </select><br/>
                    
                <input type="submit" value="确认更改">
                <input type="reset" ><br/>
            </form>
        <%    
        }else{
        %>
        <div align="right" class="fd">    
            请先<a href="index.jsp">登录</a>
        </div>
        <%    
        }
        %>
    </body>
</html>

<%@ page language="java" contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <title>查询</title>
    </head>
    <body bgcolor=rgb(180,205,230)>
        <%                         
            request.setCharacterEncoding("UTF-8");
            if(session.getAttribute("showname")!=null){    
        %>
            <form action="selectstu" method="post">
                学生ID<input type="text" name="rid"><br/>    
                <input type="submit" value="查询">
                <input type="reset" ><br/>
            </form>
        <%    
        }else{
        %>
        <div align="right" class="fd">    
            请先<a href="index.jsp">登录</a>
        </div>
        <%    
        }
        %>    
    </body>
</html>

<%@ page language="java" contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <title>jump</title>
    </head>
    <body bgcolor=rgb(180,205,230)>
        <%                         
            request.setCharacterEncoding("UTF-8");
            if(session.getAttribute("showname")!=null){    
        %>
        
            <div align="left" >
            <table border="1" cellpadding="5" cellspacing="0" bgcolor="gray">
                <tr>
                    <td>ID:</td>
                    <td><%=session.getAttribute("id") %></td>
                </tr>
                <tr>
                    <td>姓名:</td>
                    <td><%=session.getAttribute("name") %></td>
                </tr>
                <tr>
                    <td>性别:</td>
                    <td><%=session.getAttribute("sex") %></td>
                </tr>
                <tr>
                    <td>年龄:</td>
                    <td><%=session.getAttribute("age") %></td>
                </tr>
                <tr>
                    <td>地址:</td>
                    <td><%=session.getAttribute("address") %></td>
                </tr>
                <tr>
                    <td>密码:</td>
                    <td><%=session.getAttribute("password") %></td>
                </tr>
                <tr>
                    <td>身份:</td>
                    <td><%=session.getAttribute("sf") %></td>
                </tr>
                            
            </table>
            </div>
        <%    
        }else{
        %>
        <div align="right" class="fd">    
            请先<a href="index.jsp">登录</a>
        </div>
        <%    
        }
        %>
    </body>
</html>