struts web的登录项目

/* * Generated by MyEclipse Struts * Template path: templates/java/JavaClass.vtl */ package login; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import javax.servlet.http.HttpSessionBindingEvent; import org.apache.struts.action.Action; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionForward; import org.apache.struts.action.ActionMapping; /** * MyEclipse Struts Creation date: 06-27-2010 * * XDoclet definition: * * @struts.action path="/loginAction" name="loginActionForm" input="/login.jsp" */ public class LoginAction extends Action { /* * Generated Methods */ /** * Method execute * * @param mapping * @param form * @param request * @param response * @return ActionForward */ public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { LoginActionForm loginActionForm = (LoginActionForm) form;// TODO // Auto-generated // method // stub // String password = "11111111"; String password = ""; Statement stmt = null; Connection conn = null; String sql =""; ResultSet rs = null; try { //---------------没有在struts-config.xml中配置----------- Class.forName("org.gjt.mm.mysql.Driver"); conn = DriverManager.getConnection( "jdbc:mysql://localhost:3306/login", "root", "root"); stmt = conn.createStatement(); sql = "select password from user where username ='" + loginActionForm.getUsername() + "'"; rs = stmt.executeQuery(sql); // // //-------- struts-config.xml配置数据源后-------- //查找数据源 // javax.sql.DataSource ds = getDataSource(request,"dataSource"); // //连接数据库 // conn = ds.getConnection(); // stmt=conn.createStatement(); // sql= "select password from user where username ='" // +loginActionForm.getUsername()+"'"; // rs=stmt.executeQuery(sql); // // ////-------- struts-config.xml配置数据源后，结束-------- while (rs.next()) { password = rs.getString("password"); } rs.close(); stmt.close(); conn.close(); } catch (Throwable e) { e.printStackTrace(); } if (password.equals(loginActionForm.getPassword())) { HttpSession session = request.getSession(); //----------------监听器d------------ // 添加属性 触发了Listener的public void // attributeAdded(HttpSessionBindingEvent se) session.setAttribute("username", loginActionForm.getUsername()); // 删除session之前会删除session的所有属性，删除username的动作 触发了Listener的public void // attributeRemoved(HttpSessionBindingEvent se) //删除session session.invalidate(); //----------------监听器------------ return (mapping.findForward("loginsuccess"));// Action内部转发 // return mapping.findForward("global");//使用全局转发 } else { return (mapping.findForward("loginfail")); //返回ActionForward对象，可能是jsp或另一个Action，ActionServlet（中心，初步处理所有请求）将请求转发到这个jsp或action } } // <data-sources > // <data-source key="dataSource" type="org.apache.commons.dbcp.BasicDataSource"> // <set-property property="password" value="root" /> // <set-property property="minCount" value="" /> // <set-property property="maxCount" value="" /> // <set-property property="user" value="root" /> // <set-property property="driverClass" value="org.gjt.mm.mysql.Driver" /> // <set-property property="description" value="" /> // <set-property property="url" value="jdbc:mysql://localhost:3306/login" /> // <set-property property="readOnly" value="false" /> // <set-property property="autoCommit" value="false" /> // <set-property property="loginTimeout" value="" /> // </data-source> // // </data-sources> }