1. 查看：
<%@ page contentType="text/html;charset=GB2312" %> <%@ page import="java.sql.*" %> <HTML><style type="text/css"> <!-- body { background-color: #99CCFF; } --> </style> <BODY> <font color="#FFFFFF"> <center> <% Connection con; Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root","123456"); Statement sql; ResultSet rs; try { sql=con.createStatement(); rs=sql.executeQuery("SELECT * FROM student"); out.print("<Table Border>"); out.print("<TR><td colspan=5 align=center>考生数据</td></tr>"); out.print("<TR><td colspan=5 align=center><a href='https://www.jb51.net/add.jsp' target='_self'>添加考生信息</a></td></tr>"); out.print("<TR>"); out.print("<Td width=50 >"+"姓名"); out.print("<Td width=100 >"+"年龄"); out.print("<Td width=100>"+"出生日期"); out.print("<Td width=100 colspan=2>"+"操作"); out.print("</TR>"); while(rs.next()) { out.print("<TR>"); out.print("<TD >"+rs.getString(2)+"</TD>"); out.print("<TD >"+rs.getString(3)+"</TD>"); out.print("<TD >"+rs.getString(4)+"</TD>"); String idstr=rs.getString(1); out.print("<TD><a href='delete.jsp?id="+idstr+"'>删除</a></TD>"); out.print("<TD><a href='update.jsp?id="+idstr+"'>修改</a></TD>"); out.print("</TR>") ; } out.print("</Table>"); con.close(); } catch(SQLException e1) { out.print("SQL异常！！！！"); } %> </center> </BODY> </HTML>
2. add 添加：
<%@ page contentType="text/html;charset=gb2312" %> <HTML><HEAD> <style type="text/css"> <!-- body { background-image: url(); background-color: #CCCCFF; } .STYLE5 {font-family: "Courier New", Courier, monospace; font-size: 14px; } .STYLE6 { font-family: "Courier New", Courier, monospace; font-size: 24px; } --> </style> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"></HEAD> <BODY> <Font size=2> <p>添加考生信息</p> <CENTER> <FORM action="insert.jsp" name=form> <table> <tr><td><span>姓名:</span></td> <td><Input type=text size="15" ></td></tr> <tr> <td><span>年龄:</span></td> <td><Input type=text size="15"></td></tr> <tr> <td><span>出生年月:</span></td> <td><Input type=text size="15"></td></tr> </table> <table> <tr><td wnameth="42"><Input type=submit value="添加"></td> <td wnameth="50"> </td> <td wnameth="50"><Input type="reset" value="重置"></td> <td wnameth="42"> </td> </tr> </table> </Form></CENTER> </Body></HTML>
3. delete 删除：
<%@ page contentType="text/html;charset=gb2312" %> <%@ page import="java.sql.*" %> <html> <head> <title>删除操作</title> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"><style type="text/css"> <!-- body { background-color: #FFCCFF; } --> </style></head> <body> <center> <% Connection con; Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root","123456"); Statement stmt; Statement s; ResultSet rs; String id=request.getParameter("id"); try { stmt=con.createStatement(); String sql="delete from student whereSELECT * FROM student"); out.print("<Table Border>"); out.print("<TR><td colspan=5 align=center>考生数据</td></tr>"); out.print("<TR><td colspan=5 align=center><a href='https://www.jb51.net/add.jsp' target='_self'>添加考生信息</a></td></tr>"); out.print("<TR>"); out.print("<Td width=50 >"+"姓名"); out.print("<Td width=100 >"+"年龄"); out.print("<Td width=100>"+"出生日期"); out.print("<Td width=100 colspan=2>"+"操作"); out.print("</TR>"); while(rs.next()) { out.print("<TR>"); out.print("<TD >"+rs.getString(2)+"</TD>"); out.print("<TD >"+rs.getString(3)+"</TD>"); out.print("<TD >"+rs.getString(4)+"</TD>"); String idstr=rs.getString(1); out.print("<TD >"+idstr+"</TD>"); out.print("<TD><a href='delete.jsp?id="+idstr+"'>删除</a></TD>"); out.print("<TD><a href='update.jsp?id="+idstr+"'>修改</a></TD>"); out.print("</TR>") ; } out.print("</Table>"); con.close(); } catch(SQLException e1) { out.print("SQL异常！！！！"); } %> </center> </body> </html>
4. update 示例1：