javaweb+MVC+64位win7 jdbc连接access

package controllers; import java.io.IOException; import java.sql.*; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import models.se; /** * 这个类的作用主要是起到一个控制转发的功能 根据用户提交请求的action来分别调用不同的方法来处理不同的action */ public class Controller extends HttpServlet { //用户无论是通过get或者是post提交的请求都会转到doPost来处理 public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); } /** * doPost方法 用户提交的请求都由这个方法来处理 */ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //对用户提交的请求用utf-8来解码，否则会出现乱码 se workM=new se(); request.setCharacterEncoding("utf-8"); //获取用户请求的资源路径 String actionurl = request.getServletPath(); //根据用户提交请求资源路径不同调用不同的方法处理 if (actionurl.equals("/Login.action")) { String logname = request.getParameter("username"); String logpass = request.getParameter("password"); String sql="select * from user where username='"+logname+"' and password='"+logpass+"'"; try { ResultSet rs=workM.executeQuery(sql); if(rs.next()) { response.sendRedirect(request.getContextPath() + "/views/success.jsp"); } else { response.sendRedirect(request.getContextPath() + "/views/lost.jsp"); } } catch(SQLException e) { e.printStackTrace(); } } else if (actionurl.equals("/registerInfo.action")) { response.sendRedirect(request.getContextPath() + "/views/info.jsp"); } } }