Day05_08--JSP第八次作业

 

 

 

 

 

 

 <form action="<c:url value='/MailServlet?method=addMail' />" method="post">
        收件人:<input type="text" name="sjr" value="${sessionScope.fjr }"  readonly="readonly"/><br/>
        标    题:<input type="text" name="bt" />     <br/>
        正    文:<br/>
        <textarea rows="10" cols="30" name="zw"></textarea> <br/>
        <input type="submit" value="发送" />
    </form>
public void addMail(Mail mail) {
        try {
            String sql = "INSERT INTO msg(username,title,msgcontent,state,sendto,msg_create_date) VALUES(?,?,?,?,?,?)";
            Object[] params = { mail.getUsername(), mail.getTitle(),
                    mail.getMsgcontent(), mail.getState(), mail.getSendto(),
                    mail.getMsg_create_date() };

            qr.update(sql, params);

        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }

 

posted @ 2020-05-08 10:58  蓝98  阅读(102)  评论(0编辑  收藏  举报