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

2019-11-14 23:20:56

字体：大中小

来源：转载

供稿：网友

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

　　开始本篇总结之前，首先聊一聊上一篇中存在的一点小问题，上上篇总结数据库创建表时，存在一个问题，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>

　　效果图：