<%@page import="com.gd.entity.Msg"%> <%@page import="com.gd.dao.MsgDao"%> <%@ 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> <base href="<%=basePath%>"> <title>My JSP 'index.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> <form action="dowrite.jsp" method="post"> <p> 收件人:<input type="text" name="sjr" value=<%=request.getParameter("mailto") %> /> </p> <p> 标题:<input type="text" name="title" /> </p> <p> 内容:<input type="text" name="content" /> </p> <input type="submit" value="发送"> </form> <a href="main.jsp">返回</a> </body> </html>
package com.gd.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.Date; import java.util.List; import com.gd.entity.Msg; public class MsgDao extends BaseDao { // 发送,回复---insert操作 public void addMsg(Msg msg) { try { Connection con = getConnection(); String sql = "insert into msg(username,title,msgcontent,state,sendto,msg_create_date) values(?,?,?,?,?,?);"; PreparedStatement ps = con.prepareStatement(sql); ps.setString(1, msg.getUsername());// 给sql语句的问号赋值 ps.setString(2, msg.getTitle()); ps.setString(3, msg.getMsgcontent()); ps.setInt(4, 0);// 刚插入的邮件为未读邮件,直接赋值0 ps.setString(5, msg.getSendto()); ps.setDate(6, new java.sql.Date(new Date().getTime())); ps.executeUpdate(); closeAll(con, ps, null); } catch (SQLException ex) { ex.printStackTrace(); } } // 邮件列表 --select * from msg where username=.... public List<Msg> getMailByReceiver(String receiverName) { List<Msg> list = new ArrayList<Msg>(); try { Connection con = getConnection();// 获取连接 String sql = "select * from msg where sendto=?";// 编写sql语句 PreparedStatement ps = con.prepareStatement(sql); ps.setString(1, receiverName);// //给sql问号赋值 ResultSet rs = ps.executeQuery();// 执行查询 // 处理查询结果 while (rs.next()) { // 循环读取rs结果集,每一行作为一个msg对象,放入list集合中 Msg msg = new Msg(); msg.setMsgid(rs.getInt("msgid")); msg.setMsgcontent(rs.getString("msgcontent")); msg.setMsg_create_date(rs.getDate("msg_create_date")); msg.setSendto(rs.getString("sendto")); msg.setState(rs.getInt("state")); msg.setTitle(rs.getString("title")); msg.setUsernname(rs.getString("username")); list.add(msg); } closeAll(con, ps, rs); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } // 根据id查内容 select public Msg getMailById(int id) { Msg msg = new Msg(); try { Connection con = getConnection();// 获取连接 String sql = "select * from msg where msgid=?";// 编写sql语句 PreparedStatement ps = con.prepareStatement(sql); ps.setInt(1, id);// //给sql问号赋值 ResultSet rs = ps.executeQuery();// 执行查询 // 处理查询结果 while (rs.next()) { // 循环读取rs结果集,每一行作为一个msg对象,放入list集合中 msg.setMsgid(rs.getInt("msgid")); msg.setMsgcontent(rs.getString("msgcontent")); msg.setMsg_create_date(rs.getDate("msg_create_date")); msg.setSendto(rs.getString("sendto")); msg.setState(rs.getInt("state")); msg.setTitle(rs.getString("title")); msg.setUsernname(rs.getString("username")); } closeAll(con, ps, rs); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return msg; } public static void main(String[] args) { MsgDao md = new MsgDao(); md.delMsg(14); } // 阅读状态改变,,,未读 已读 update public void alterMsg(int id){ try { Connection con=getConnection(); String sql="update msg set state=1 where msgid=?"; PreparedStatement ps = con.prepareStatement(sql); ps.setInt(1, id); ps.executeUpdate(); closeAll(con, ps, null); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } // 删除邮件 delete public void delMsg(int id){ try { Connection con=getConnection(); String sql="delete from msg where msgid=?"; PreparedStatement ps = con.prepareStatement(sql); ps.setInt(1, id); ps.executeUpdate(); closeAll(con, ps, null); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }
package com.gd.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/user", "root", "root"); } 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(); } } }
package com.gd.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import com.gd.entity.Users; public class UsersDao extends BaseDao { // 登录功能 public boolean login(String uname, String upwd) throws SQLException { // 获取连接 Connection conn = getConnection(); // 编写sql语句 String sql = "select * from users where username=? and password=?"; // 执行sql语句 PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, uname); ps.setString(2, upwd); ResultSet rs = ps.executeQuery(); if (rs.next()) { closeAll(conn, ps, rs); return true; } else { closeAll(conn, ps, rs); return false; } } public void addUsers(Users users) { try { Connection con = getConnection(); String sql = "insert into users(username,password,email) values(?,?,?);"; PreparedStatement ps = con.prepareStatement(sql); ps.setString(1, users.getUsername()); ps.setString(2, users.getPassword()); ps.setString(3, users.getEmail()); ps.executeUpdate(); closeAll(con, ps, null); } catch (SQLException ex) { ex.printStackTrace(); } } }
<%@ 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> <base href="<%=basePath%>"> <title>注册</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> <form action="do.jsp" method="post"> 用户名:<input type="text" name="uname"/><br> 密 码:<input type="password" name="upwd"/><br> <input type="submit" value="注册"> </form> </body> </html>
<%@ 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> <base href="<%=basePath%>"> <title>登录</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> <script type="text/javascript"> function mycheck() { //判断验证码是否为空 if (form1.validationCode.value==""){ alert("验证码不能为空，请输入验证码!"); form1.validationCode.focus(); return; } //判断验证码是否正确 if (form1.validationCode.value != form1.validationCode1.value) { alert("请输入正确的验证码!!"); form1.validationCode.focus(); return; } form1.submit1(); } </script> <body> <form action="logincheck.jsp" name="form1" method="post"> 用户名:<input type="text" name="userName" size="18"><br> 密 码:<input type="password" name="password" size="19"><br> 验证码:<input type="text" name="validationCode" onKeyDown="if(event.keyCode==13){form1.submit.focus();}"size="4"> <% int intmethod1=(int)((((Math.random())*5))+1); int intmethod2=(int)((((Math.random())*5))+1); int intmethod3=(int)((((Math.random())*5))+1); int intmethod4=(int)((((Math.random())*5))+1); String intsum=intmethod1+""+intmethod2+intmethod3+intmethod4; %> <input type="hidden" name="validationCode1" value="<%=intsum%>"> <img style="height:20px;weight:20px" src="images/<%=intmethod1 %>.png"> <img style="height:20px;weight:20px" src="images/<%=intmethod2 %>.png"> <img style="height:20px;weight:20px" src="images/<%=intmethod3 %>.png"> <img style="height:20px;weight:20px" src="images/<%=intmethod4 %>.png"> <br> <input type="submit" value="登录"> <a href="register.jsp">注册</a> </form> </body> </html>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <%@page import="com.gd.entity.Users"%> <%@page import="com.gd.entity.Msg"%> <%@page import="com.gd.dao.MsgDao"%> <%@page import="com.gd.dao.UsersDao"%> <% 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>登录</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> <% request.setCharacterEncoding("UTF-8"); Users a=new Users(); String uname = request.getParameter("uname"); String upwd = request.getParameter("upwd"); String email = request.getParameter("uemail"); a.setUsername(uname); a.setPassword(upwd); a.setEmail(email); UsersDao as=new UsersDao(); as.addUsers(a); request.getRequestDispatcher("index.jsp").forward(request, response); %> </body> </html>
