jsp,javaBean,DAO之间的简单混合运用实例

最新推荐文章于 2019-04-11 22:14:28 发布

沸羊羊一个

最新推荐文章于 2019-04-11 22:14:28 发布

阅读量921

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/zhixinhuacom/article/details/8717792

版权

java 专栏收录该内容

31 篇文章 0 订阅

订阅专栏

jsp代码
Login.jsp

<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>
<%
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 'Login.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="css/styles.css">


</head>
<script type="text/javascript">
function $(Element){
      //return document.getElementsByName(Element);
     return document.getElementById(Element);
}
function checkName(){
      var name=$("username");
      var nameid=$("nameid");
      nameid.innerHTML="";
      if(name.value==""){
      alert("用户名不能为空");
     // nameid.innerHTML="用户名不能为空";
      return false;
      }
}
function checkPwd(){
var pwd=$("pwd");
if(pwd.value==""){
alert("密码不能为空");
return false;
}
if(pwd.value.length<6){
alert("密码长度不能少于6位");
return false;
}
}
function checkRepwd(){
var pwd=$("pwd");
var repwd=$("repwd");
if(repwd.value==""){
alert("确认密码不能为空");
return false;
}
if(pwd.value!=repwd.value){
alert("密码不一致");
return false;
}
}
function checkEmail(){
var email=$("email");
if(email.value==""){
alert("邮箱不能为空");
return false;
}
if(email.value.indexOf("@")==-1 || email.value.indexOf(".")==-1 ||email.value.indexOf("@")>email.value.indexOf(".")){
alert("邮箱格式不正确！");
return false;
}

}
</script>

<body>
    <form name="form1" method="post" action="control.jsp">
    <div class="style">
    <table class="style">
       <tr>
       <td>用户名：</td>
       <td><input name="username" id="username" type="text" οnblur="checkName()"></td>
       <td><div id="nameid"></div></td>
       </tr>
       <tr>
       <td>密码：</td>
       <td><input name="pwd" id="pwd" type="password" οnblur="checkPwd()"></td></tr>
       <tr>
       <td>确认密码：</td>
       <td><input name="repwd" id="repwd" type="password"/ οnblur="checkRepwd()"></td></tr>
       <tr>
       <td>性别：</td>
       <td><input name="sex" type="radio" value="男" checked="checked"/>男<input name="sex" value="女" type="radio">女</td></tr>
       <tr>
       <td>电子邮件地址：</td>
       <td><input name="email" type="text" id="email" οnblur="checkEmail();"/>
       </td></tr>
       <tr>
       <td>兴趣爱好：</td>
       <td>
       <input name="interting" type="checkbox" value="体育">体育
       <input name="interting" type="checkbox" value="读书">读书
       <input name="interting" type="checkbox" value="音乐">音乐
       <input name="interting" type="checkbox" value="旅游">旅游
       </td></tr>
       <tr><td><input name="reset" type="reset" value="重置"/></td>
       <td><input name="submit" type="submit" value="同意以下并提交"></td>
       </tr>
       <tr>
       <td colspan="2"><textarea name="textarea" rows="5" readonly="readonly">初始文本内容</textarea></td>
       </tr>
    </table>
    </div>
    </form>
</body>
</html>

control.jsp
<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ page import="com.accp.Dao.*" %>
<%@ page import="com.accp.entity.*" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <base href="<%=basePath%>">

    <title>My JSP 'control.jsp' starting page</title>


    

</head>

<body>
<%
request.setCharacterEncoding("gbk");
String name=request.getParameter("username");
// String pwd =request.getParameter("pwd");
//String email=request.getParameter("email");
//String sex =request.getParameter("sex");
//String[] interting=request.getParameterValues("interting");

userDAO dao =new userDAO();
userBean userbean =dao.findbyuser(name);
if(userbean!=null){
if(userbean.getPwd().length()<7){

}else{%>
<p>用户名：<%=userbean.getName() %></p>
<p>密码：<%=userbean.getPwd() %></p>
<p>邮箱:<%=userbean.getEmail() %></p>

<%

}

}else{
response.sendRedirect("Login.jsp");
}
   %>

</body>
</html>

javaBean类：userBean.java

package com.accp.entity;

public class userBean {
    private String name;
    private String pwd;
    private String email;
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getPwd() {
        return pwd;
    }
    public void setPwd(String pwd) {
        this.pwd = pwd;
    }
    public String getEmail() {
        return email;
    }
    public void setEmail(String email) {
        this.email = email;
    }

    public userBean(String name,String pwd,String email){
        this.name=name;
        this.pwd=pwd;
        this.email=email;
    }
    public userBean(){

    }


}

连接数据库类：userDAO

package com.accp.Dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.accp.entity.userBean;

public class userDAO {
    public userBean findbyuser(String name) {
        userBean rt = null;
        Connection conn;
        PreparedStatement pstmt;
        ResultSet rs ;
        try{
            Class.forName("oracle.jdbc.driver.OracleDriver";
            conn=DriverManager.getConnection("jdbc:oracle:thin:@OWEYOJ5DU7AAHZZ:1521:ORCL","ndx","a");
            String sql="select * from user2 where name=?";
            pstmt=conn.prepareStatement(sql);
            pstmt.setString(1, name);
            rs=pstmt.executeQuery();

            if(rs.next()){
               rt=new userBean();
                rt.setName(rs.getString("name"));
                rt.setPwd(rs.getString("pwd"));
                rt.setEmail(rs.getString("email"));
            }
            conn.close();
            pstmt.close();
            rs.close();

        }catch(ClassNotFoundException e){
            System.out.println(e.toString());
        }catch(SQLException e){
            System.out.println(e);
        }
        finally{

        }
        return rt;
    }

}

沸羊羊一个

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
jsp,javaBean,DAO之间的简单混合运用实例

jsp代码Login.jspString path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%> ">
复制链接

扫一扫

专栏目录