JSP网站开发基础总结《五》

浏览数：28 / 时间：2015年06月09日

　　开始本篇总结之前，首先聊一聊上一篇中存在的一点小问题，上上篇总结数据库创建表时，存在一个问题，name、year、form好像属于关键字，不能做为表的属性，所以大家注意一下，在创建表时保证表的属性不存在冲突，故而上一篇中关于sql语句的地方大家需要修改一下表的属性名。

　　下面开始本篇关于JSP与MYSQL的交互连接，为了方便总结，我将以创建一个学生信息管理系统为目标，本篇就以登录功能的实现为主体进行总结。

　1、创建管理员表：

　　技术分享

　2、创建一个管理员类：

public class Manager {
    private int id;
    private String name ; 
    private String password;
    private int key;
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
    public int getKey() {
        return key;
    }
    public void setKey(int key) {
        this.key = key;
    }    
}

　3、添加用户名、密码判断方法：

public class ManagerMaImp {
    //登录验证
    public boolean getByName(String name, String password){
        System.out.println(name+"    "+password);
        boolean flag = false;
        Connection conn = null;
        Statement st = null;
        ResultSet rs = null;
        conn = DBO.getConnection();
        String sql = "select * from manager where user_name=‘"+name+"‘ and pwd=‘"+password+"‘ and num="+1;
        try {
            st = conn.createStatement();
            rs = st.executeQuery(sql);
            if(rs.next()){
                flag = true;
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return flag;
    }
}

　4、设计登录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>学生管理系统登录</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">

  </head>
  
  <body>
    <center>
        <h1>学生管理系统登录</h1>
        <hr/>
        <form action="login" method="post" > 
            <table>
                <tr>
                    <td>姓名：</td><td><input type="text" name="name" /></td>
                </tr>
                <tr>
                    <td>密码：</td><td><input type="password" name="pwd" /></td>
                </tr>
                <tr>
                    <td colspan="2" align="center"><input type="submit" value="登录"/></td>
                </tr>
            </table>   
        </form>     
    </center>
  </body>
</html>

　　效果图：

　　技术分享

　5、用于身份判断的select：

public class login extends HttpServlet {

    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        doPost(request, response);
    }

    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");
        String name = request.getParameter("name");
        String password = request.getParameter("pwd");
        ManagerMaImp mmi = new ManagerMaImp();
        boolean flag = mmi.getByName(name, password);
        if(flag){
            StudentMaImp smi = new StudentMaImp();
            List<Student> list = new ArrayList<Student>();
            list = smi.getAll();
            request.setAttribute("list", list);
            request.getRequestDispatcher("All.jsp").forward(request, response);
        }else{
            response.sendRedirect("Login.jsp");
        }
    }

}

　6、主界面（All.jsp）：

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@page import="com.mysql.jsp.student.Student"%>
<%
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>遍历数据库</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">

  </head>
  
  <body>
  <% List<Student> list = (List<Student>)request.getAttribute("list"); %>
    <center>
        <h1>遍历数据库中的数据</h1>
        <hr/>
        <form action="get" method="post">
            <table width="80%">
                <tr>
                    <td><a href="Add.jsp">添加</a></td><td>&nbsp;</td><td>精确查找:<input type="text" name="queding"/></td><td>&nbsp;</td><td>模糊查找:<input type="text" name="mohu"/></td>
                </tr>
            </table>
        </form>
        <table border="1" width="80%">
            <TR>
                <TD>ID</TD><td>姓名</td><td>性别</td><td>年龄</td><td>家乡</td><td>学校</td><td colspan="2">操作</td>
            </TR>
            <%
                if(list.size()!=0){
                    for(int i=0; i<list.size(); i++){
                        Student student = list.get(i);
            %>
                    <tr><TD><%=student.getId() %></TD><td><%=student.getName() %></td><td><%if(student.getSex()==1){ %>男<%}else{ %>女<%} %></td><td><%=student.getYear() %></td><td><%=student.getFrom() %></td><td><%=student.getSchool() %></td><td><a href="getId?id=<%=student.getId() %>">修改</a></td><td><a href="del?id=<%=student.getId() %>">删除</a></td></tr>
            <%
                    }
                }
             %>
        </table>
    </center>
  </body>
</html>