<%@ 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("数据库链接失败！");
}
%>
