国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 學(xué)院 > 開發(fā)設(shè)計 > 正文

Oracle+struts2實現(xiàn)用戶登入并顯示訪問次數(shù)

2019-11-14 15:03:05
字體:
供稿:網(wǎng)友

實體類:

package entity;public class userfo {PRivate int id;//idprivate String name;//用戶名private String passWord;//密碼private String sex;//性別private String phone;//電話號private String fdate;//日期private String adress;//地址public int getId() {    return id;}public void setId(int id) {    this.id = id;}public String getName() {    return name;}public void setName(String name) {    this.name = name;}public String getPassword() {    return password;}public void setPassword(String password) {    this.password = password;}public String getSex() {    return sex;}public void setSex(String sex) {    this.sex = sex;}public String getPhone() {    return phone;}public void setPhone(String phone) {    this.phone = phone;}public String getFdate() {    return fdate;}public void setFdate(String fdate) {    this.fdate = fdate;}public String getAdress() {    return adress;}public void setAdress(String adress) {    this.adress = adress;}}

三層架構(gòu):

public class UserDaoImpl extends sqlser implements UserDao {    Connection con = null;    PreparedStatement st = null;    ResultSet rs = null;       /*        * 登入方法        * (non-javadoc)        * @see dao.UserDao#Login(entity.userfo)        */    public int Login(userfo user) {        // TODO Auto-generated method stub        int flag=0;         con = this.getConnection();    String sql = "select * from userfo where name = ? and password  = ?";        try {        st = con.prepareStatement(sql);        st.setString(1, user.getName());        st.setString(2, user.getPassword());        rs = st.executeQuery();        if(rs!=null && rs.next()){            flag=1;        }    } catch (SQLException e) {        e.printStackTrace();    }finally {        this.ShiFang(rs, st, con);    }    return flag;}

 

/** * 登入 * @author Administrator * */public interface UserBiz {        public int Login(userfo user);}

 

package BaseDao;    import java.sql.Connection;    import java.sql.DriverManager;    import java.sql.ResultSet;    import java.sql.SQLException;     import java.sql.Statement;   public class sqlser {            //數(shù)據(jù)庫初始化        String driver="Oracle.jdbc.driver.OracleDriver";        String url="jdbc:oracle:thin:@localhost:1521:ORCL";        String user = "epet";        String pwd = "123456";                //獲取連接        public Connection getConnection(){                        try {                                Class.forName(driver);            } catch (ClassNotFoundException e) {                // TODO Auto-generated catch block                e.printStackTrace();            }                        Connection con =null;                                      try {                con =DriverManager.getConnection(url,user,pwd);                                        } catch (SQLException e) {                // TODO Auto-generated catch block                e.printStackTrace();                            }                 return con;        }                        //======釋放連接=======    public  void ShiFang(ResultSet rs, Statement st,Connection con){                   try {                       if(rs!=null){                              rs.close();                       }if(st!=null){                             st.close();                       }if(con!=null){                         con.close();                                                    }                           } catch (SQLException e) {                    // TODO Auto-generated catch block                    e.printStackTrace();                           }                   }                   }

 

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE struts PUBLIC    "-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"    "http://struts.apache.org/dtds/struts-2.3.dtd">    <struts>        <!-- 配置包信息 -->        <package name="default" namespace="/" extends="struts-default">            <!-- 配置Action:關(guān)聯(lián)Action JavaBean -->            <action name="longinAct" class="Action.LoginAction">                <!-- 指定返回的視圖 ;默認使用轉(zhuǎn)發(fā)-->                <result name="input">/error.jsp</result>              <result name="success">/success.jsp</result>                             </action>        </package>    </struts>
package Action;import java.util.Map;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.Httpsession;import org.apache.struts2.ServletActionContext;import org.apache.struts2.interceptor.applicationAware;import org.apache.struts2.interceptor.SessionAware;import biz.UserBiz;import biz.impl.UserBizImpl;import com.opensymphony.xwork2.ActionContext;import com.opensymphony.xwork2.ActionSupport;import com.opensymphony.xwork2.ModelDriven;import dao.UserDao;import dao.UserDaoImpl;import entity.userfo;/** *  * @author Administrator * */  public class LoginAction extends ActionSupport implements ModelDriven,SessionAware,ApplicationAware{    private userfo user=new userfo();    private Map<String,Object> sessionM;    private Map<String,Object> applicationM;    public Object getModel() {        // TODO Auto-generated method stub        return user;    }    public void setSession(Map<String, Object> arg0) {        // TODO Auto-generated method stub        sessionM=arg0;    }    public void setApplication(Map<String, Object> arg0) {        // TODO Auto-generated method stub        applicationM=arg0;    }        @Override    public String execute() throws Exception{        UserDao dao=new UserDaoImpl();    // 通過ActionContext獲取MAP類型的Session      ActionContext ac=ActionContext.getContext();         sessionM=ac.getSession();         sessionM.put("name",user.getName());        sessionM.put("user",user);        // 通過控制反轉(zhuǎn)方法 獲取MAP類型的Session        sessionM.put("name", user.getName());        sessionM.put("password", user.getPassword());        sessionM.put("user", user);        String name=(String)sessionM.get("name");        String pwd=(String)sessionM.get("password");        userfo a=new userfo();        a.setName(name);        a.setPassword(pwd);        int flag=dao.Login(a);        if(flag>0){        if(applicationM.get("count")==null){        applicationM.put("count", 1);        }else{        int count=Integer.parseInt(applicationM.get("count").toString());        applicationM.put("count", count+1);        }return SUCCESS;        }else{        return INPUT;        }        }}    


登入頁面、成功頁面、失敗頁面

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><%@ taglib prefix="s" uri="/struts-tags"%><%String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html>  <head>    <base href="<%=basePath%>">        <title>Struts2Demo</title>      </head>    <body>    <s:form action="longinAct" method="post">     <s:textfield name="name" label="用戶名"></s:textfield>      <s:password name="password" label="密碼"></s:password>      <s:submit value="登陸"> </s:submit>     </s:form>    </body></html>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><%@ taglib prefix="s" uri="/struts-tags"%><%String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html>  <head>    <base href="<%=basePath%>">        <title>My JSP 'success.jsp' starting page</title>        <meta http-equiv="pragma" content="no-cache">    <meta http-equiv="cache-control" content="no-cache">    <meta http-equiv="expires" content="0">        <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">    <meta http-equiv="descr content="This is my page">    <!--    <link rel="stylesheet" type="text/CSS" href="styles.css">    -->  </head>    <body> <H1> 用戶名: <s:property value="name" /> <br /> 密碼: <s:property value="password" />   <br /> 登陸成功! <br>從SESSION中獲取值(jsp方式):用戶名:<%=session.getAttribute("name")%><br></H1>  從SESSION中獲取值(struts方式):用戶名: <s:property value="#session.name" />  <br> 訪問次數(shù): <s:property value="#application.count" /></body></html>

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><%@ taglib prefix="s" uri="/struts-tags"%><%String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html>  <head>    <base href="<%=basePath%>">        <title>My JSP 'error.jsp' starting page</title>        <meta http-equiv="pragma" content="no-cache">    <meta http-equiv="cache-control" content="no-cache">    <meta http-equiv="expires" content="0">        <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">    <meta http-equiv="description" content="This is my page">    <!--    <link rel="stylesheet" type="text/css" href="styles.css">    -->  </head>    <body>           用戶名: <s:property value="name" /> <br />&nbsp;&nbsp;&nbsp;&nbsp;碼: <s:property value="password" /> <br />  <H1>登陸失敗! </H1>  </body></html>


發(fā)表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發(fā)表
主站蜘蛛池模板: 社会| 隆尧县| 政和县| 华蓥市| 辽宁省| 襄垣县| 应城市| 黑山县| 峨眉山市| 满城县| 临猗县| 宝清县| 遂平县| 电白县| 分宜县| 深水埗区| 安庆市| 壶关县| 长寿区| 苗栗县| 黄平县| 阿坝| 德格县| 仙游县| 柳河县| 余庆县| 隆化县| 会同县| 项城市| 安西县| 四平市| 利川市| 化州市| 山东省| 曲阳县| 芒康县| 广昌县| 射洪县| 称多县| 寻甸| 任丘市|