📄 user_info.jsp~1~
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>查看用户信息</title><style type="text/css"><!--.style1 { font-size: 24px; color: #FF0000;}body,td,th { color: #000000;}body { background-color: #FFFFCC;}.style2 {font-size: 12px}--></style></head><jsp:useBean id="dbconn" scope="page" class="org.DBConnection"/><body><div align="center"> <p> <% int i=Integer.parseInt(request.getParameter("user_id")); Connection conn=dbconn.getConnection(); Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); String sql="select * from users where user_id="+i; ResultSet rs=stmt.executeQuery(sql); if(rs.next())%> <p> </p> <span class="style1">用户信息</span></p> </div><table width="403" border="1" align="center"> <tr> <td width="117" bgcolor="#CCCCFF">user_id</td> <td width="270"><%=rs.getInt("user_id")%></td> </tr> <tr> <td bgcolor="#CCCCFF">user_name</td> <td><%=rs.getString("user_name")%></td> </tr> <tr> <td bgcolor="#CCCCFF">name</td> <td><%=rs.getString("name")%></td> </tr> <tr> <td bgcolor="#CCCCFF">sex</td> <td><%=rs.getString("sex")%></td> </tr> <tr> <td bgcolor="#CCCCFF">age</td> <td><%=rs.getString("age")%></td> </tr> <tr> <td bgcolor="#CCCCFF">tel</td> <td><%=rs.getString("tel")%></td> </tr> <tr> <td bgcolor="#CCCCFF">address</td> <td><%=rs.getString("address")%></td> </tr> <tr> <td bgcolor="#CCCCFF">email</td> <td><%=rs.getString("email")%></td> </tr></table><%rs.close();stmt.close();conn.close();%><p align="center"><a href="del_user.jsp" class="style2">返回</a></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -