第十一周作业
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'denglu.jsp' starting page</title>
</head>
<body>
<script type="text/javascript">
function validate() {
if (loginForm.uname.value == "") {
alert("账号不能为空!");
return;
}
if (loginForm.upwd.value == "") {
alert("密码不能为空!");
return;
}
loginForm.submit();
}
</script>
<form name="loginForm" action="dologin.jsp" method="post">
用户名:<input type="text" name="uname" ><br>
密 码:<input type="password" name="upwd" ><br>
<input type="button" value="登录" onClick="validate()">
</form>
<hr>
<a href="reg.jsp">返回注册</a>
</body>
</html>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <%@ page import="com.gd.dao.UserDao"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>My JSP 'dologin.jsp' starting page</title> </head> <body> <% request.setCharacterEncoding("utf-8"); String uname = request.getParameter("uname"); String upwd = request.getParameter("upwd"); UserDao ud = new UserDao(); if (ud.login(uname, upwd)) { session.setAttribute("uname",uname); request.getRequestDispatcher("main.jsp").forward( request,response); } else { out.print("登录失败,即将跳回登录页......"); response.setHeader("refresh", "3;url=denglu.jsp"); } %> </body> </html>
package com.gd.dao; 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", "123456"); } 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 java.util.ArrayList; import java.util.List; import javax.annotation.PreDestroy; import com.gd.entity.msg; import com.sun.org.apache.regexp.internal.recompile; public class msgDao extends BaseDao{ public List<msg> listAll(String username) throws SQLException{ List<msg> list =new ArrayList<msg>(); Connection conn =getConnection(); String sql="select * from msg where username=?"; PreparedStatement pred =null; ResultSet rest=null; try { pred=conn.prepareStatement(sql); pred.setString(1, username); rest=pred.executeQuery(); while (rest.next()) { msg msg=new msg(); msg.setMsgid(rest.getInt("msgid")); msg.setUsername(rest.getString("username")); msg.setTitle(rest.getString("title")); msg.setMsgcontent(rest.getString("msgcontent")); msg.setState(rest.getInt("state")); msg.setSendto(rest.getString("sendto")); msg.setMsg_create_date(rest.getDate("msg_create_date")); list.add(msg); } } catch (Exception e) { // TODO: handle exception } finally{ closeAll(conn, pred, rest); } 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.zzz.entity; import java.util.Date; public class Msg { private Integer id; private String fjr; private String sjr; private String title; private Date time; private Integer zt; private String content; public String getContent() { return content; } public void setContent(String content) { this.content = content; } public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getFjr() { return fjr; } public void setFjr(String fjr) { this.fjr = fjr; } public String getSjr() { return sjr; } public void setSjr(String sjr) { this.sjr = sjr; } public String getTitle() { return title; } public void setTitle(String title) { this.title = title; } public Date getTime() { return time; } public void setTime(Date time) { this.time = time; } public Integer getZt() { return zt; } public void setZt(Integer zt) { this.zt = zt; } public Msg() { super(); } public Msg(Integer id, String fjr, String sjr, String title, Date time, Integer zt, String content) { super(); this.id = id; this.fjr = fjr; this.sjr = sjr; this.title = title; this.time = time; this.zt = zt; this.content = content; } }
package com.gd.entity;
import java.sql.Date;
public class msg {
private Integer msgid;
private String username;
private String title;
private String msgcontent;
private Integer state;
private String sendto;
private Date msg_create_date;
public Integer getMsgid() {
return msgid;
}
public void setMsgid(Integer 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 Integer getState() {
return state;
}
public void setState(Integer 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;
}
}