第七次作业
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <%@page import="java.sql.SQLException"%> <%@page import="com.gd.dao.BaseDao"%> <%@page import="com.gd.entity.Msg"%> <%@page import="java.sql.DriverManager"%> <%@page import="java.sql.PreparedStatement"%> <%@page import="java.sql.ResultSet"%> <%@page import="java.sql.Connection"%> <body> <% String uname = request.getParameter("uname"); session.setAttribute("uname", uname); Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; try { Class.forName("com.mysql.jdbc.Driver"); //加载驱动 String url = "jdbc:mysql://localhost:3306/jdbc"; String user = "root"; String password = "1111"; conn = DriverManager.getConnection(url, user, password); ps = conn .prepareStatement("select * from msg where username=?"); ps.setString(1, uname); rs = ps.executeQuery(); %> <table align="center" border="1"> <br> <br> <br> <br> <tr> <td>username</td> <td>title</td> <td>msgcontent</td> <td>state</td> <td>sendto</td> <td>msg_create_date</td> </tr> <% while (rs.next()) { %> <tr> <td><%=rs.getString("username")%></td> <td><%=rs.getString("title")%></td> <td><%=rs.getString("msgcontent")%></td> <td> <% if (rs.getString("state").equals("1")) { %> <input type="button" value="打开消息" onclick="window.location.href='show.jsp';" /> <% } else { %> <div align="center"> <% out.print("已阅读"); %> </div> <% } %> <% String title=rs.getString("title"); session.setAttribute("title", title); %> </td> <td><%=rs.getString("sendto")%></td> <td><%=rs.getString("msg_create_date")%></td> </tr> <% } %> </table> <br> <% } catch (Exception e) { e.printStackTrace(); } finally { if (rs != null) { try { rs.close(); } catch (SQLException e) { // ignore } rs = null; } } if (ps != null) { try { ps.close(); } catch (SQLException e) { // ignore } ps = null; } } if (conn != null) { try { conn.close(); } catch (SQLException e) { // ignore } rs = null; } } } %> </body>
<%@page import="com.gd.dao.UsersDao"%> <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <% request.setCharacterEncoding("utf-8"); String uname = request.getParameter("uname"); String upwd = request.getParameter("upwd"); UsersDao ud = new UsersDao(); if (ud.login(uname, upwd)) request.getRequestDispatcher("main.jsp").forward(request, response); else response.sendRedirect("index.jsp"); %>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<html>
<head>
</head>
<body>
<form action="dologin.jsp" method="post">
用户名:<input type="text" name="uname" value="kitty" /><Br>
密码 :<input type="password" name="upwd" value="777"/><br>
<input type="submit" value="登录">
</form>
</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.sql.Statement; import java.util.List; import javax.naming.Context; import javax.naming.InitialContext; import javax.naming.NamingException; import javax.sql.DataSource; public class BaseDao { // 获取连接 public Connection getConnection() { Connection conn = null; try { Class.forName("com.mysql.jdbc.Driver"); // 2.建立连接 conn = DriverManager.getConnection( "jdbc:mysql://localhost:3306/jdbc", "root", "1111"); } catch (Exception e) { e.printStackTrace(); } return conn; } // 关闭连接 public static void realse(ResultSet rs, PreparedStatement ps, Connection conn) { { //6.关闭资源,释放资源 if (rs != null) { try { rs.close(); } catch (SQLException e) { // ignore } rs = null; } } if (ps != null) { try { ps.close(); } catch (SQLException e) { // ignore } ps = null; } } if (conn != null) { try { conn.close(); } catch (SQLException e) { // ignore } rs = null; } } } } }