📄 see.java
字号:
package guestbook;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import javax.sql.DataSource;import java.sql.*;public class see extends HttpServlet { private static final String CONTENT_TYPE = "text/html; charset=GB2312"; private DataSource dataSource=null; //Initialize global variables public void init() throws ServletException { Init init=new Init(getServletContext().getRealPath("/")); dataSource=LinkDB.getDB(); if (dataSource==null) { LinkDB.setDB(init.getDriverName(),init.getDBURL(),init.getDBUser(),init.getDBPassword()); dataSource=LinkDB.getDB(); } } //Process the HTTP Get request public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType(CONTENT_TYPE); PrintWriter out = response.getWriter(); if(!Head.checkUserLogin(request)&&!Head.checkAdminLogin(request)){ out.println("<script>alert('只有登陆用户才能查看信息');self.close();</script>"); return; } String name=request.getParameter("name"); Connection conn=null; Statement stmt=null; ResultSet rs=null; try{ conn=dataSource.getConnection(); stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); rs=stmt.executeQuery("select * from userinfo where username='"+name+"'"); if(rs.next()){ out.println("<html><head><title>"+name+"的资料</title></head>"); out.println("<body>"); out.println("用 户 名： "+rs.getString("username").trim()+"<br>"); if(Head.checkAdminLogin(request)) out.println("密 码： "+rs.getString("userpassword").trim()+"<br>"); out.println("真实姓名： "+rs.getString("usertruename").trim()+"<br>"); out.println("昵 称： "+rs.getString("usernick").trim()+"<br>"); out.println("邮 箱： "+rs.getString("useremail").trim()+"<br>"); out.println(" Q Q ： "+rs.getString("userqq").trim()+"<br>"); out.println("性 别： "+rs.getString("usersex").trim()+"<br>"); out.println("电 话： "+rs.getString("userphone").trim()+"<br>"); out.println("地 址： "+rs.getString("useraddress").trim()+"<br>"); out.println("爱 好： "+rs.getString("userlike").trim()+"<br>"); out.println("</body></html>"); } else{ out.println("<script>alert('用户"+name+"不存在');self.close();</script>"); } } catch(SQLException e){ out.println(e); } finally{ try{ rs.close(); stmt.close(); conn.close(); LinkDB.shutdownDataSource(dataSource); } catch(SQLException e){ out.println(e); } } }}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -