JSP 08课

"java" import="java.util.*" import="java.sql.*" import="com.gd.entity.Msg" pageEncoding="utf-8"%>

String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

span>"-//W3C//DTD HTML 4.01 Transitional//EN">

  base href="">
    
    "pragma" content="no-cache">
    "cache-control" content="no-cache">
    "expires" content="0">    
    "keywords" content="keyword1,keyword2,keyword3">
    "description" content="This is my page">
    

  
  
  
   
        request.setCharacterEncoding("utf-8");
        String uuname = (String) session.getAttribute("uuname");
        String ctitle = request.getParameter("ctitle");
        String ccontent = request.getParameter("ccontent");
        String sendtoid = request.getParameter("sendtoid");
        //获取邮件列表页面输入的标题
        String contitle = (String) session.getAttribute("newcontitle");
        Connection conn = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            //加载驱动
            String url = "jdbc:mysql://localhost:3306/jdbcjsp";
            String user = "root";
            String password = "root";
            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 usernname=?");
            ps.setString(1, contitle);
            ps.setString(2, uuname);
            rs = ps.executeQuery();
            while (rs.next()) {
            ps = conn.prepareStatement("insert into msg(usernname,title,msgcontent,sendto,state,msg_create_date)" + "values(‘"
                    +sendtoid + "‘,‘" + ctitle + "‘,‘" + ccontent + "‘,‘"
                    + uuname + "‘,‘" + "1" + "‘,‘"+"2020-04-27"+"‘)");
                    ps.executeUpdate();
                    request.getRequestDispatcher("index.jsp").forward(request, response);
    %>
    
        }
        }else{
        Msg msg = new Msg();
            
        
            ps = conn.prepareStatement("insert into msg(usernname,title,msgcontent,sendto,state,msg_create_date)" + "values(‘"
                    + sendtoid + "‘,‘" + ctitle + "‘,‘" + ccontent + "‘,‘"
                    + uuname + "‘,‘" + "1" + "‘,‘"+"2020-04-27"+"‘)");
                    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();
                    }
                }
            }
        }
    %>