毕业生信息查询系统的设计与实现
package com.kong.control; import com.kong.data.*; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.RequestDispatcher; import javax.servlet.ServletConfig; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession;
public class HandleLogin extends HttpServlet { public HandleLogin() { super(); }
public void init(ServletConfig config) throws ServletException { super.init(config);
try { Class.forName(\ }catch(Exception e){} }
public String handleString(String s)
{ try{ byte bb[]=s.getBytes(\ s=new String(bb); }
catch(Exception ee){} return s; }
public void destroy() { super.destroy(); // Just puts \ // Put your code here }
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request,response); }
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { Connection con;
PreparedStatement sql; Login loginBean=null;
32
毕业生信息查询系统的设计与实现
HttpSession session=request.getSession(true);
//session中login对象存在
try{ loginBean=(Login)session.getAttribute(\ if(loginBean==null)
{ loginBean=new Login();
session.setAttribute(\ } }
catch(Exception ee)
{ loginBean=new Login();
session.setAttribute(\ }
//取name,password,category;
String name=request.getParameter(\ password=request.getParameter(\ category=request.getParameter(\ logo=null;
name=handleString(name);
password=handleString(password); category=handleString(category);
if(category.equals(\
String uri=\
boolean boo=(name.length()>0)&&(password.length()>0);
if(boo) {
try{ con=DriverManager.getConnection(uri,\ String condition=\=?\
sql=con.prepareStatement(condition); sql.setString(1,name);
sql.setString(2,password);
ResultSet rs=sql.executeQuery(); boolean m=rs.next(); if(m==true) {
logo=\
loginBean.setName(name);
//loginBean.setPassword(password); loginBean.setCategory(category); loginBean.setLogo(logo);
response.sendRedirect(\ } else {
response.sendRedirect(\
33
毕业生信息查询系统的设计与实现
}
sql.close(); con.close(); }
catch(SQLException exp) {
response.sendRedirect(\ } } else {
response.sendRedirect(\ } }
else if(category.equals(\
String uri=\ boolean boo=(name.length()>0)&&(password.length()>0);
if(boo) {
try{ con=DriverManager.getConnection(uri,\ String condition=\password =?\
sql=con.prepareStatement(condition); sql.setString(1,name);
sql.setString(2,password);
ResultSet rs=sql.executeQuery(); boolean m=rs.next(); if(m==true) {
logo=\
loginBean.setName(name);
loginBean.setPassword(password); loginBean.setCategory(category); loginBean.setLogo(logo);
response.sendRedirect(\ } else {
response.sendRedirect(\ }
sql.close(); con.close(); }
catch(SQLException exp) {
//response.sendRedirect(\
34
毕业生信息查询系统的设计与实现
} } else {
response.sendRedirect(\ }
}else if(category.equals(\
String uri=\
boolean boo=(name.length()>0)&&(password.length()>0);
if(boo) {
try{ con=DriverManager.getConnection(uri,\ String condition=\=?\
sql=con.prepareStatement(condition); sql.setString(1,name);
sql.setString(2,password);
ResultSet rs=sql.executeQuery(); boolean m=rs.next(); if(m==true) {
logo=\
loginBean.setName(name);
loginBean.setPassword(password); loginBean.setCategory(category); loginBean.setLogo(logo);
response.sendRedirect(\ } else {
response.sendRedirect(\ }
sql.close(); con.close(); }
catch(SQLException exp) {
response.sendRedirect(\ } } else {
response.sendRedirect(\ }
}else if(category.equals(\
String uri=\
boolean boo=(name.length()>0)&&(password.length()>0);
35
毕业生信息查询系统的设计与实现
if(boo) {
try{ con=DriverManager.getConnection(uri,\ String condition=\=?\
sql=con.prepareStatement(condition); sql.setString(1,name);
sql.setString(2,password);
ResultSet rs=sql.executeQuery();
boolean m=rs.next(); if(m==true) {
logo=\
loginBean.setName(rs.getString(1)); loginBean.setPassword(rs.getString(2)); loginBean.setCategory(category);
loginBean.setLasttime(rs.getString(3)); loginBean.setLogo(logo);
response.sendRedirect(\ } else {
response.sendRedirect(\ }
sql.close(); con.close(); }
catch(SQLException exp) {
//response.sendRedirect(\ } } else {
response.sendRedirect(\ } } } }
1.2.1 注销退出控制器 HandleExit.java
package com.kong.control; import com.kong.data.*; import java.sql.*; import java.io.*;
import javax.servlet.*; import javax.servlet.http.*;
public class HandleExit extends HttpServlet
36