chuqiyuan

公告

JSP第8次作業(yè)

<body>
   <%
        request.setCharacterEncoding("utf-8");
        String uname = (String) session.getAttribute("uname");
        session.setAttribute("uname", uname);
        Connection conn = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            //加載驅(qū)動(dòng)
            String url = "jdbc:mysql://localhost:3306/users";
            String user = "root";
            String password = "admin";
            conn = DriverManager.getConnection(url, user, password);
            // 連接對象
            //conn = BaseDao.getConnection();
    %>
    
    <form action="insert.jsp" name="huifu" method="post">
        sendto :<input type="text" name="sendtoid"><br> <br> 
        
        標(biāo)題:<input type="text" name="ctitle"><br> <br> 
        
        正文:<input type="text" name="ccontent"><br>
        <br>
        <input type="submit" value="發(fā)送">
        <a href="main.jsp">返回</a>
    </form>
    <%
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            //BaseDao.closeAll(conn, ps, rs);
            try {
                if (rs != null) {
                    rs.close();
                }
            } finally {
                try {
                    if (ps != null) {
                        ps.close();
                    }
                } finally {
                    if (conn != null) {
                        conn.close();
                    }
                }
            }
        }
    %>
   
 </body>

<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>

<body>
    <%
        request.setCharacterEncoding("utf-8");
        String uname = (String) session.getAttribute("uname");
        String ctitle = request.getParameter("ctitle");
        String ccontent = request.getParameter("ccontent");
        String sendtoid = request.getParameter("sendtoid");

        String contitle = (String) session.getAttribute("newcontitle");
        session.setAttribute("uname", uname);
        Connection conn = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            //加載驅(qū)動(dòng)
            String url = "jdbc:mysql://localhost:3306/users";
            String user = "root";
            String password = "admin";
            conn = DriverManager.getConnection(url, user, password);
            // 連接對象
            //conn = BaseDao.getConnection();
    %>
    <%
    if(contitle!=null){
        Msg msg = new Msg();
            ps = conn.prepareStatement("select * from msg where title=?and username=?");
            ps.setString(1, contitle);
            ps.setString(2, uname);
            rs = ps.executeQuery();
            while (rs.next()) {
            ps = conn.prepareStatement("insert into msg(username,title,msgcontent,sendto,state,msg_create_date)" + "values('"
                    + rs.getString("sendto") + "','" + ctitle + "','" + ccontent + "','"
                    + uname + "','" + "1" + "','"+"2020-05-11"+"')");
                    ps.executeUpdate();
                    request.getRequestDispatcher("index.jsp").forward(request, response);
    %>
    <%
        }
        }else{
        Msg msg = new Msg();
            
        
            ps = conn.prepareStatement("insert into msg(username,title,msgcontent,sendto,state,msg_create_date)" + "values('"
                    + sendtoid + "','" + ctitle + "','" + ccontent + "','"
                    + uname + "','" + "1" + "','"+"2020-05-11"+"')");
                    ps.executeUpdate();
                    request.getRequestDispatcher("index.jsp").forward(request, response);
                    
                    }
    %>
    <%
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            //BaseDao.closeAll(conn, ps, rs);
            try {
                if (rs != null) {
                    rs.close();
                }
            } finally {
                try {
                    if (ps != null) {
                        ps.close();
                    }
                } finally {
                    if (conn != null) {
                        conn.close();
                    }
                }
            }
        }
    %>




    <br>
</body>

<body>
    <%
        request.setCharacterEncoding("utf-8");
        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");
            //加載驅(qū)動(dòng)
            String url = "jdbc:mysql://localhost:3306/users";
            String user = "root";
            String password = "admin";
            conn = DriverManager.getConnection(url, user, password);
            // 連接對象
            //conn = BaseDao.getConnection();
    %>
    <a href="editemail.jsp">寫郵件</a>
    <table align="center">
        <tr>
            <td>username</td>
            <td>title</td>
            <td>msgcontent</td>
            <td>state</td>
            <td>sendto</td>
            <td>msg_create_date</td>
        </tr>
        <%
            Msg msg = new Msg();
                ps = conn.prepareStatement("select * from msg where username=?");
                ps.setString(1, uname);
                rs = ps.executeQuery();
                while (rs.next()) {
        %>
        <tr>
            <td><%=rs.getString("username")%></td>
            <td><a href="content.jsp?id=<%=rs.getInt("msgid")%>"><%=rs.getString("title")%></a></td>
            <td><%=rs.getString("msgcontent")%></td>

            <td>
                <%
                    if (rs.getString("state").equals("1")) {
                %> <%
     out.print("未讀");
 %> <%
     } else {
 %> <%
     out.print("已讀");
 %> <%
     }
 %>
            </td>
            <td><%=rs.getString("sendto")%></td>
            <td><%=rs.getString("msg_create_date")%></td>
        </tr>
        <%
            }
        %>
    </table>
   
    <br>

    <%
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            //BaseDao.closeAll(conn, ps, rs);
            try {
                if (rs != null) {
                    rs.close();
                }
            } finally {
                try {
                    if (ps != null) {
                        ps.close();
                    }
                } finally {
                    if (conn != null) {
                        conn.close();
                    }
                }
            }
        }
    %>

</body>

posted on 2020-05-11 14:09 chuqiyuan 閱讀(127) 評論(0) 收藏舉報(bào)

刷新頁面返回頂部