JSP第十一周作业
package aaa; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.List; import javax.naming.Context; import javax.naming.InitialContext; import javax.naming.NamingException; import javax.sql.DataSource; 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"); } 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 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 entity.Msg; public class MsgDao extends BaseDao { public List<Msg> getMailByReceiver(String name) { List<Msg> list = new ArrayList<Msg>(); Connection conn = getConnection(); String sql = "select * from mail where addressee=?"; PreparedStatement ps = null; ResultSet rs = null; try { ps = conn.prepareStatement(sql); ps.setString(1, name); rs = ps.executeQuery(); while (rs.next()) { Msg m = new Msg(); int eid = rs.getInt("eid"); String sender = rs.getString("sender"); String addressee = rs.getString("addressee"); String title = rs.getString("title"); String content = rs.getString("content"); Date sending_time = rs.getDate("sending_time"); int state = rs.getInt("state"); m.setEid(eid); m.setSender(sender); m.setAddressee(addressee); m.setTitle(title); m.setContent(content); m.setSending_time(sending_time); m.setState(state); list.add(m); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { closeAll(conn, ps, rs); } return list; } }
package com.gd.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class usersDao extends BaseDao{ public boolean login(String uname,String upwd) throws SQLException{ boolean f= false; Connection conn =getConnection(); PreparedStatement pred=null; ResultSet rest=null; String sql="select * from users where uname=? and upwd=?"; try { pred =conn.prepareStatement(sql); pred.setString(1, uname); pred.setString(2, upwd); rest =pred.executeQuery(); while(rest.next()){ f=true; } } catch (Exception e) { // TODO: handle exception }finally{ closeAll(conn, pred, rest); } return f; } public boolean id(Integer id) throws SQLException{ boolean f= false; Connection conn =getConnection(); PreparedStatement pred=null; ResultSet rest=null; String sql="select * from users where id=?"; try { pred =conn.prepareStatement(sql); pred.setInt(1, id); rest =pred.executeQuery(); while(rest.next()){ f=true; } } catch (Exception e) { // TODO: handle exception }finally{ closeAll(conn, pred, rest); } return f; } public void zhuce(Integer id,String uname,String upwd){ Connection conn =getConnection(); PreparedStatement pred=null; try { String sql="insert into users(id,uname,upwd) values(?,?,?)"; pred =conn.prepareStatement(sql); pred.setInt(1, id); pred.setString(2, uname); pred.setString(3, upwd); pred.executeUpdate(); } catch (Exception e) { // TODO: handle exception } finally{ closeAll(conn, pred, null); } } }
package com.cui.entity; import java.sql.Date; public class message { private int mid; //编号 private String username; //发件人姓名 private String receiver; //收件人姓名 private String title; //标题 private String text; //内容 private Date sendtime; //发送时间 private int state; //状态 public int getMid() { return mid; } public void setMid(int mid) { this.mid = mid; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getReceiver() { return receiver; } public void setReceiver(String receiver) { this.receiver = receiver; } public String getTitle() { return title; } public void setTitle(String title) { this.title = title; } public String getText() { return text; } public void setText(String text) { this.text = text; } public Date getSendtime() { return sendtime; } public void setSendtime(Date sendtime) { this.sendtime = sendtime; } public int getState() { return state; } public void setState(int state) { this.state = state; } }
<html> <head> <title>login</title> </head> <body> <p>欢迎来到登录页面!!</p><br> <form name="form" action="dologin.jsp" method="post"> 用户名:<input type="text" name="uname"><br> 密码:<input type="password" name="upwd"><br> <input type="submit" value="登录" > <br> <a href="zhuce.jsp">注册新用户</a> </form> </body> </html>
<html> <head> <title>register</title> </head> <body> <p>欢迎来到注册界面</p> <form name="form" action="dozhuce.jsp" method="post"> 姓名:<input type="text" name="uname"><br> 密码:<input type="password" name="upwd"><br> <input type="submit" value="注册完成" > <br> <a href="dozhuce.jsp">返回登录界面</a> </form> </body> </html>