<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %> <% //连接数据库 try { Class.forName("org.gjt.mm.mysql.Driver").newInstance(); Connection connection= java.sql.DriverManager.getConnection("jdbc:mysql://localhost/dangyuan","root","789+"); Statement statement = connection.createStatement(); String sql="SELECT * FROM admin"; ResultSet rs = statement.executeQuery(sql); ResultSetMetaData rmeta = rs.getMetaData(); int numClumns=rmeta.getColumnCount(); while(rs.next()) { %> <tr bgcolor="#CCCCCC"> <td><div align="center"><%=rs.getString(1)%></div></td> <td><div align="center"><%=rs.getString(2)%></div></td> <td><div align="center"> <form id="<%="form" + rs.getString(1)%>" method="post" action="del.jsp" > <input type="hidden" name="id" id="id" value="<%=rs.getString(1)%>"/> <input type="submit" name="删除" id="删除" value="删除" /> </form> </div></td> </tr> <% } %> <p> <% out.println("<br>"); out.println("数据库操作成功,恭喜你!"); rs.close(); statement.close(); connection.close(); } catch(Exception e) { e.printStackTrace(); out.println("数据库链接失败!"); } %>