?? loginservlet.java~27~
字號:
package espc;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.util.*;import java.sql.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2006</p> * <p>Company: </p> * @author not attributable * @version 1.0 */public class LoginServlet extends HttpServlet { private static final String CONTENT_TYPE = "text/html; charset=GB2312"; String user="",password="",realpassword="",role="",devid="0",qdataid=""; String IP_Address; DbConnection db; //Initialize global variables public void init() throws ServletException { } //Process the HTTP Get request public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType(CONTENT_TYPE); PrintWriter out = response.getWriter(); out.println("<html>"); out.println("<head><title>LoginServlet</title></head>"); out.println("<body bgcolor=\"#ffffff\">"); out.println("<p>The servlet has received a " + request.getMethod() + ". This is the reply.</p>"); out.println("</body></html>"); } //Process the HTTP Post request public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { IP_Address = request.getRemoteAddr(); ServletInputStream sis = request.getInputStream(); //讀取請求設置 BufferedInputStream bis = new BufferedInputStream(sis); ObjectInputStream ois = new ObjectInputStream(bis); // send response setup response.setStatus (HttpServletResponse.SC_OK); //輸出響應設置 ServletOutputStream sos = response.getOutputStream (); BufferedOutputStream bos = new BufferedOutputStream (sos); ObjectOutputStream oos = new ObjectOutputStream (bos); String command=new String(""); try { //讀入數據 command = ois.readUTF(); System.out.println("Command:" + command); if (command.equalsIgnoreCase("login")) { login(ois, oos); } } catch (Exception ex) { ex.printStackTrace(); } oos.flush(); oos.close();// doGet(request, response); } void login(ObjectInputStream ois,ObjectOutputStream oos) { synchronized(this) { try{ user=ois.readUTF(); password=ois.readUTF(); String bCommand =" "; String bMessage ="Servlet Message:Good Link!"; ResultSet rs=null; ViewQueryBean bb=new ViewQueryBean(); String sql="select *from user_info where user_name='"+user+"' and password='"+password+"'"; System.out.println("這是一句測試語句!!!!!!!!"); bb.openConnection(); System.out.println("!!!!!!!!!!!!!!!!!!!!!!!!!!!!!"); bb.executeQuery(sql);// bb=DbConnection.getconn();// Statement sm=bb.createStatement();// ResultSet rs=sm.executeQuery("select * from user_info where user_name='"+user+"' and password='"+password+"'"); if (bb.next()){ bCommand ="ok"; } //返回數據 oos.writeObject(bCommand); oos.writeObject(IP_Address); oos.writeObject(bMessage); db.close(); } catch (Exception ex) { ex.printStackTrace(); } } } //Clean up resources public void destroy() { }}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -