jsp第八次作业

邮箱登录、注册、查看邮箱，写邮箱，删除，回复

registe.jsp

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
    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>



</head>

<body>
    <form action="doregiste.jsp">
        用户名：<input type="text" name="username" /> </br> 密 码 <input type="password"
            name="password" /> </br> 邮箱 <input type="text" name="email" /> </br> <input
            type="submit" value="注册" /> <input type="button" value="登录"
            onclick="fun1()" />
    </form>
</body>
<script type="text/javascript">
    function fun1() {
        location.href = "index.jsp"
    }
</script>
</html>

doregiste.jsp

<%@page import="com.email.dao.UsersDao"%>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
    String username = request.getParameter("username");
    String password = request.getParameter("password");
    String email = request.getParameter("email");
    UsersDao ud = new UsersDao();
    int i = ud.insert(username, password, email);
    if (i > 0) {
        response.sendRedirect("index.jsp");
    } else {
        response.sendRedirect("register.jsp");
    }
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>


</head>

<body>

</body>
</html>

index.jsp

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

</head>

<body>
    <form action="dologin.jsp">
        用户名：<input type="text" name="username" /> </br> 密码：<input type="password"
            name="password" /> </br> <input type="submit" value="登录" /> <input
            type="button" value="注册" onclick="fun1()" />
    </form>
</body>
<script type="text/javascript">
    function fun1() {
        location.href = "register.jsp"
    }
</script>
</html>

dologin.jsp

<%@page import="com.email.dao.UsersDao"%>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>




<%
    String username = request.getParameter("username");

    String password = request.getParameter("password");
    System.out.println(username + " " + password);
    UsersDao ud = new UsersDao();
    boolean flag = ud.login(username, password);
    if (flag) {
        session.setAttribute("username", username);
        session.setAttribute("password", password);
        response.sendRedirect("success.jsp");
    } else {
        response.sendRedirect("index.jsp");
    }
%>

</head>

<body>

</body>
</html>

success.jsp

<%@page import="com.email.bean.msg"%>
<%@page import="com.email.dao.MsgDao"%>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
    
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>


</head>
<body>

    
        
            <%
        MsgDao md = new MsgDao();
        String uname = (String) session.getAttribute("username");
        List<msg> list = md.selectMyAll(uname);
    %>
    欢迎你<%=uname%> <a href="write.jsp">写邮件</a>
    <table border="1">
    <tr>
    
    <td>标题    </td>
    
    <td>是否已读</td>
    <td>发件人</td>
    <td>时间</td>    
    <td>操作</td>
    <td>操作</td>
    </tr>
<%for(int i=0;i<list.size();i++){ %>    
    <tr>
    
    <td><a href="show.jsp?msgid=<%=list.get(i).getMsgid()%>"><%=list.get(i).getTitle() %></a></td>
    
    <td><%int x=list.get(i).getState();
            if(x==0){%>
            未读
            <%}else{ %>
            已读
            <%} %>
    </td>
    <td><%=list.get(i).getUsername() %></td>
    <td><%=list.get(i).getMsg_create_date() %></td>
    <td><a href="delete.jsp?msgid=<%=list.get(i).getMsgid()%>">删除</a>    </td>
    <td><a href="replay.jsp?username=<%=list.get(i).getUsername()%>">回复</a></td>

    </tr>
    
<%} %>
    </table>
</body>
</html>

write.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<form action="insertwrite.jsp">
    名字：<input type="text" name="sendto">
    </br>
    主题<input type="text" name="title">
    </br>
    内容：</br><textarea rows="10" cols="30" name="content"></textarea>
    <input type="submit" value="发送">
    </form>
</body>
</html>

insertwrite.jsp

<%@page import="com.email.dao.MsgDao"%>
<%@page import="com.email.bean.msg"%>
<%@page import="java.util.Date"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
    <%
        msg m = new msg();
        String sendto = request.getParameter("sendto");
        String title = request.getParameter("title");
        String content = request.getParameter("content");
        String username = (String) session.getAttribute("username");
        Date d = new Date();
        long time = d.getTime();
        m.setMsg_create_date(new java.sql.Date(time));
        m.setUsername(username);
        m.setSendto(sendto);
        m.setTitle(title);
        m.setMsgcontent(content);
        m.setState(0);
        MsgDao md = new MsgDao();
        int i = md.insertWrite(m);
        if(i>0){
            response.sendRedirect("success.jsp");
        } else {
            response.sendRedirect("write.jsp");
        }
        
    %>
</body>
</html>

replay.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<%
    String sendto = request.getParameter("username");//收件人
    String username = session.getAttribute("username").toString();//发件人
    

%>
<body>
    <form action="doreplay.jsp">
    收件人：<input type="text" value="<%=request.getParameter("username")%>" name="username"></br>
    标题：    <input type="text" name = "title"></br>
    内容：</br><textarea rows="10" cols="30" name="content"></textarea>
    <input type="submit" value="发送">
    </form>
</body>
</html>

doreplay.jsp

<%@page import="com.email.dao.MsgDao"%>
<%@page import="com.email.bean.msg"%>
<%@page import="java.util.Date"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<%
    String sendto = request.getParameter("username");//收件人
    String username = session.getAttribute("username").toString();//发件人
    String title = request.getParameter("title");//收件人
    String content = request.getParameter("content");//收件人
    long time = new Date().getTime();
    msg m = new msg(username,title,content,0,sendto,new java.sql.Date(time));
    MsgDao md = new MsgDao();
    int i = md.insertWrite(m);
    if (i > 0) {
        response.sendRedirect("success.jsp");
    } else {
        response.sendRedirect("replay.jsp");
    }
%>
</body>
</html>

show.jsp

<%@page import="com.email.dao.MsgDao"%>
<%@page import="com.email.bean.msg"%>
<%@page import="java.util.Date"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<%
    String sendto = request.getParameter("username");//收件人
    String username = session.getAttribute("username").toString();//发件人
    String title = request.getParameter("title");//收件人
    String content = request.getParameter("content");//收件人
    long time = new Date().getTime();
    msg m = new msg(username,title,content,0,sendto,new java.sql.Date(time));
    MsgDao md = new MsgDao();
    int i = md.insertWrite(m);
    if (i > 0) {
        response.sendRedirect("success.jsp");
    } else {
        response.sendRedirect("replay.jsp");
    }
%>
</body>
</html>

delete.jsp

<%@page import="com.email.dao.MsgDao"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
<%
    int msgid  = Integer.parseInt(request.getParameter("msgid"));
    System.out.println(msgid);
    MsgDao md = new MsgDao();
    int i =md.delete(msgid);
    if (i > 0) {
        response.sendRedirect("success.jsp");
    } else {
        response.sendRedirect("register.jsp");
    }
%>
</body>
</html>

msg.java

package com.email.bean;

import java.sql.Date;

public class msg {
    private int msgid;
    private String username;
    private String title;
    private String msgcontent;
    private int state;
    private String sendto;
    private Date msg_create_date;
    
    public msg() {
        super();
    }
    
    public msg(String username, String title, String msgcontent, int state, String sendto, Date msg_create_date) {
        super();
        this.username = username;
        this.title = title;
        this.msgcontent = msgcontent;
        this.state = state;
        this.sendto = sendto;
        this.msg_create_date = msg_create_date;
    }

    public msg(int msgid,String username, String title, String msgcontent, int state,
            String sendto, Date msg_create_date) {
        super();
        this.msgid = msgid;
        this.username = username;
        this.title = title;
        this.msgcontent = msgcontent;
        this.state = state;
        this.sendto = sendto;
        this.msg_create_date = msg_create_date;
    }
    public int getMsgid() {
        return msgid;
    }
    public void setMsgid(int msgid) {
        this.msgid = msgid;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getTitle() {
        return title;
    }
    public void setTitle(String title) {
        this.title = title;
    }
    public String getMsgcontent() {
        return msgcontent;
    }
    public void setMsgcontent(String msgcontent) {
        this.msgcontent = msgcontent;
    }
    public int getState() {
        return state;
    }
    public void setState(int state) {
        this.state = state;
    }
    public String getSendto() {
        return sendto;
    }
    public void setSendto(String sendto) {
        this.sendto = sendto;
    }
    public Date getMsg_create_date() {
        return msg_create_date;
    }
    public void setMsg_create_date(Date msg_create_date) {
        this.msg_create_date = msg_create_date;
    }
    
    
}

users.java

    package com.email.bean;
    
    public class users {
        private String username;
        private String password;
        private String email;
        public users() {
            super();
        }
        public users(String username, String password, String email) {
            super();
            this.username = username;
            this.password = password;
            this.email = email;
        }
        public String getUsername() {
            return username;
        }
        public void setUsername(String username) {
            this.username = username;
        }
        public String getPassword() {
            return password;
        }
        public void setPassword(String password) {
            this.password = password;
        }
        public String getEmail() {
            return email;
        }
        public void setEmail(String email) {
            this.email = email;
        }
        
        
    }

BaseDao.java

package com.email.dao;

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

public class BaseDao {    
    //获取连接
    protected Connection getConnection(){
        Connection conn=null;
            try {
                Class.forName("com.mysql.jdbc.Driver");
                // 2.建立连接
                conn = DriverManager.getConnection(
                        "jdbc:mysql://localhost:3306/test", "root", "root");
                conn.setAutoCommit(false);
            } catch (Exception e) {
                e.printStackTrace();
            } 
            return conn;
    }    
    
    
    //关闭连接
    protected void closeAll(Connection con,PreparedStatement ps,ResultSet rs){        
    try {
        if(rs != null)
            rs.close();
        if(ps != null)
            ps.close();
        if(con != null)
            con.close();
        
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

}

MsgDao.java

package com.email.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import com.email.bean.msg;

public class MsgDao extends BaseDao{
    public List<msg> selectMyAll(String username){
         Connection conn = null;
         PreparedStatement ps =null;
         ResultSet rs = null;
         List<msg> list = new ArrayList<msg>();
         try {
             conn = getConnection();
             ps = conn.prepareStatement("select * from msg where sendto=? ");
             ps.setString(1, username);
    
             rs = ps.executeQuery();
                
             while(rs.next()){
                 list.add(new msg(rs.getInt("msgid"),rs.getString("username"),rs.getString("title"),rs.getString("msgcontent"),rs.getInt("state"), rs.getString("sendto"),rs.getDate("msg_create_date")));
                 System.out.println(rs.getInt("msgid"));
             }
             return list;
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally{
            closeAll(conn, ps, rs);
        }
         return list;
        }
    
        public int insertWrite(msg m) {
             Connection conn = null;
             PreparedStatement ps =null;
             int i = 0;
             try {
                 conn = getConnection();
                 ps = conn.prepareStatement("insert into msg (username,title,msgcontent,state,sendto,msg_create_date)values(?,?,?,?,?,?)");
                 ps.setString(1, m.getUsername());
                 ps.setString(2, m.getTitle());
                 ps.setString(3, m.getMsgcontent());
                 ps.setInt(4, m.getState());
                 ps.setString(5, m.getSendto());
                 ps.setDate(6, m.getMsg_create_date());
                 i = ps.executeUpdate();
                 conn.commit();
                 return i;
            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }finally{
                closeAll(conn, ps, null);
            }
             return i;
        }
        
        public int delete(int msgid) {
             Connection conn = null;
             PreparedStatement ps =null;
             int i = 0;
             try {
                 conn = getConnection();
                 ps = conn.prepareStatement("delete from msg where msgid = ?");
                 ps.setInt(1, msgid);
                 i = ps.executeUpdate();
                 conn.commit();
                 return i;
            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }finally{
                closeAll(conn, ps, null);
            }
             return i;
        }
        
        
        public msg getMsgById(int id){
            msg m=new msg();
            Connection conn = getConnection();
            String sql = "SELECT * from msg where msgid=?";
            PreparedStatement ps=null;
            ResultSet rs=null;
            try {
                ps = conn.prepareStatement(sql);
                ps.setInt(1, id);
                 rs=ps.executeQuery();
                while(rs.next()){
                    
                    m.setMsgid(rs.getInt(1));
                    m.setUsername(rs.getString(2));
                    m.setTitle(rs.getString(3));
                    m.setMsgcontent(rs.getString(4));
                    m.setState(rs.getInt(5));
                    m.setSendto(rs.getString(6));
                    m.setMsg_create_date(rs.getDate(7));                
                }
            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }finally{
                closeAll(conn, ps, rs);
            }
            
            
            return m;
            
            
            
        }
        
        
        
        
        
        //修改邮件的已读状态  把1改0
        public void updateMsg(int id){
            Connection con = null;
            PreparedStatement ps = null;
            try {
                 con = getConnection();
                String sql="update msg set state=1 where msgid=?";
                 ps = con.prepareStatement(sql);
                ps.setInt(1, id);//给sql语句的问号赋值
                ps.executeUpdate();
                con.commit();
                
            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }finally {
                closeAll(con, ps, null);
            }
            
            
            
        }    
        

    }

UsersDao.java

package com.email.dao;

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


public class UsersDao  extends BaseDao{
    public int insert(String username,String password,String email){
     Connection conn = null;
     PreparedStatement ps =null;
     int i = 0;
     try {
         conn = getConnection();
         ps = conn.prepareStatement("insert into users (username,password,email)values(?,?,?)");
         ps.setString(1, username);
         ps.setString(2, password);
         ps.setString(3, email);
         i = ps.executeUpdate();
         conn.commit();
         return i;
    } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }finally{
        closeAll(conn, ps, null);
    }
     return i;
    }
    
    
    public boolean login(String username,String password){
         Connection conn = null;
         PreparedStatement ps =null;
         ResultSet rs = null;
    
         try {
             conn = getConnection();
             ps = conn.prepareStatement("select username,password from users where username = ? and password = ?");
             ps.setString(1, username);
             ps.setString(2, password);
             rs = ps.executeQuery();
             if(rs.next()){
                 return true;
             }
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally{
            closeAll(conn, ps, rs);
        }
         return false;
        }
}

相关阅读:
宿舍助手app——个人工作第四天
 宿舍助手app——个人工作第三天
 对QQ输入法的评价
 冲刺9
冲刺8
冲刺7
冲刺6
冲刺5
冲刺4
冲刺3
原文地址：https://www.cnblogs.com/M1223631418/p/14713658.html