jsp操作数据库之查询

图片：

代码如下：

<%!
   public static final String DBDRIVER="org.gjt.mm.mysql.Driver";
   public static final String DBURL="jdbc:mysql://localhost:3306/user";
   public static final String DBUSER="root";
   public static final String DBPASS="***********";
%>
<% 
   Connection conn=null;
   PreparedStatement pst=null;
   ResultSet rs=null;
%>
<%
  try{
	  Class.forName(DBDRIVER);
	  conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);
	  request.setCharacterEncoding("utf-8");
	  String sql_select="select * from user_table";
	  pst=conn.prepareStatement(sql_select);
	  rs=pst.executeQuery();
%>
<table border="1">
<tr><td>id</td><td>用户名</td><td>密码</td><td>用户类型</td><td colspan="2" align="center">数据操作</td></tr>
<% 
  while(rs.next()){
%>
 <tr>
 <td><%= rs.getString(1) %></td>
 <td><%= rs.getString("username")%> </td>
 <td><%= rs.getString("password")%> </td>
 <td><%= rs.getString("type")%>     </td>
 <td><button><a href="delete.jsp?id=<%=rs.getString("id")%>">删除该记录</a></button></td>
 <td><button><a href="update.jsp?id=<%=rs.getString("id")%>">更新该记录</a></button></td>
 </tr>
<%
   }
  }
catch(Exception e){
	  out.println(e);
}  
%>
</table>