package com.vitamin.servlet; import java.io.IOException; import java.io.PrintWriter; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.vitamin.DataAccess.*; import java.sql.*; publicclass Hello extends HttpServlet { /** *//** * Constructor of the object. */ public Hello() { super(); } /** *//** * Destruction of the servlet. <br> */ publicvoid destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } /** *//** * The doGet method of the servlet. <br> * * This method is called when a form has its tag value method equals to get. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ publicvoid doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); PrintWriter out = response.getWriter(); out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">"); out.println("<HTML>"); out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>"); out.println(" <BODY>"); out.print(" This is "); out.print(this.getClass()); out.println(", using the GET method"); out.println(" </BODY>"); out.println("</HTML>"); out.flush(); out.close(); } /** *//** * The doPost method of the servlet. <br> * * This method is called when a form has its tag value method equals to post. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ publicvoid doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html"); response.setCharacterEncoding("GBK"); PrintWriter out = response.getWriter(); request.setCharacterEncoding("GBK"); String name = request.getParameter("name"); String pwd = request.getParameter("password"); DBbase myDb =new DBbase(); ResultSet rs =null; int result =0; String sql ="select count(*) as count from users where username = '"+name+"' and password = '"+pwd+"'"; try { rs = myDb.executeQuery(sql); if(rs.next()) { result = rs.getInt("count"); } } catch(SQLException ex) { ex.printStackTrace(); } if(result>0) { out.println("合法用户"); } else { out.println("非法用户"); } } /** *//** * Initialization of the servlet. <br> * * @throws ServletException if an error occure */ publicvoid init() throws ServletException { // Put your code here } }