数据库操作

首先创建登录页面

<div class="container">
    <div class="row clearfix">
        <div class="col-md-12 column">
            <form role="form" method="post" action="index.jsp">
                <div class="form-group">
                    <label for="exampleInputEmail1">用户名：</label><input name="username" class="form-control" id="exampleInputEmail1" type="text" />
                </div>
                <div class="form-group">
                    <label for="exampleInputPassword1">密码：</label><input name="password" class="form-control" id="exampleInputPassword1" type="password" />
                </div>

                <div class="checkbox">

                </div> <button class="btn btn-default" type="submit">登录</button>
            </form>
        </div>
    </div>
</div>

登录成功后进入操作页面

<%
    Class.forName("com.mysql.jdbc.Driver");
    String url="jdbc:mysql://localhost:3306/mydatabase";
    Connection connection= DriverManager.getConnection(url,"root","root");
    String sql="select * from user ";
    PreparedStatement pstm=connection.prepareStatement(sql);
    ResultSet rs=pstm.executeQuery();
%>
<div class="container">
    <div class="row clearfix">
        <div class="col-md-12 column">
            <h2 align="center">欢迎登陆！</h2>
<div > <a href="insert.jsp" style="text-decoration: none; color:black;" ><font size="5">插入</font></a></div>
            <table class="table table-hover table-striped">

                <thead>
                <tr>
                    <th>
                        编号
                    </th>
                    <th>
                        用户名
                    </th>
                    <th>
                        密码
                    </th>
                    <th>
                        操作
                    </th>
                    <th >
                    </th>
                </tr>
                </thead>
                <tbody>
              <%
                   while( rs.next())
                    {
                        out.print("<tr>");
                        out.print(
                                "<td>"+rs.getString("id")+
                                "</td><td>"+rs.getString("username")+
                                "</td><td>"+rs.getString("password")+
                                "</td><td COLSPAN=2><a href='Delete.jsp?id="+rs.getString("id")+"'>删除</a>"
                                +"&nbsp;&nbsp;&nbsp;&nbsp;<a href='Update.jsp?id="+rs.getString("id")+"'>修改</a>"+"</td>");
                                out.print("</tr>");

                    }%>

                </tbody>
            </table>
        </div>
    </div>
</div>

点击删除直接删除一行信息，点击修改进入修改页面

<form  action="Update ok.jsp" method="post">

    <%
    Class.forName("com.mysql.jdbc.Driver");
    String url="jdbc:mysql://localhost:3306/mydatabase";
    Connection connection= DriverManager.getConnection(url,"root","root");
    String sql="select * from user where id=?";
    PreparedStatement pstm=connection.prepareStatement(sql);
    pstm.setInt(1,Integer.parseInt(request.getParameter("id")));
    ResultSet rs=pstm.executeQuery();
        session.setAttribute("ID",request.getParameter("id"));
%>

<div class="container">
    <div class="row clearfix">
        <div class="col-md-12 column">
            <h2 align="center">修改用户！</h2>
            <table class="table table-hover table-striped">
                <thead>
                <tr>
                    <th></th>
                    <th>
                        编号
                    </th>
                    <th>
                        用户名
                    </th>
                    <th>
                        密码
                    </th>

                </tr>
                </thead>
                <tbody>
                <%
                    while( rs.next())
                    {
                        out.print("<tr>");
                        out.print("<td>原信息</td>"+
                              "<td>"+rs.getString("id")+
                                        "</td><td>"+rs.getString("username")+
                                        "</td><td>"+rs.getString("password")+
                                        "</td>");
                        out.print("</tr>");

                    }%>


<tr>


    <td>修改信息</td>
    <td><input type="text" name="UpdateId" ></td>
    <td><input type="text" name="Updatesername"></td>
    <td><input type="text" name="UpdatePassword"></td>
</tr>
                    <tr><td colspan="4" style="text-align: center;"><input type="submit" value="提交"></td></tr>

                </tbody>
            </table>
        </div>
    </div>
</div>
</form>

点击插入，进入插入页面

<form  action="insert ok.jsp" method="post">
    <div class="container">
        <div class="row clearfix">
            <div class="col-md-12 column">
                <h2 align="center">插入用户！</h2>
                <table class="table table-hover table-striped">
                    <thead>
                    <tr>
                        <th></th>
                        <th>
                            编号
                        </th>
                        <th>
                            用户名
                        </th>
                        <th>
                            密码
                        </th>

                    </tr>
                    </thead>
                    <tbody>
                    <tr>
                        <td>修改信息</td>
                        <td><input type="text" name="InsertId" ></td>
                        <td><input type="text" name="Insertname"></td>
                        <td><input type="text" name="InsertPassword"></td>
                    </tr>
                    <tr><td colspan="4" style="text-align: center;"><input type="submit" value="提交"></td></tr>

                    </tbody>
                </table>
            </div>
        </div>
    </div>
</form>