public boolean insert(Msg m) { try { String uname = m.getUsernname(); PreparedStatement ps = null; Connection conn = getConnection();//获取连接 String sql="insert into msg(username,title,msgcontent,sendto,state,msg_create_date)"+"values('" + uname + "','" + m.getTitle() + "','" + m.getMsgcontent() + "','" + m.getSendto() + "','" + "1" + "','"+"2020-05-08"+"')"; ps = conn.prepareStatement(sql); ps.executeUpdate(); //Statement stmt = conn.createStatement(); //stmt.executeUpdate(sql); closeAll(conn, ps, null); return true; } catch (Exception e) { // TODO: handle exception } return false; }
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <%@page import="com.gd.entity.Users"%> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>Insert title here</title> </head> <body> <% Users u = (Users) session.getAttribute("user");%> <form action="dosend.jsp" method="post"> <table> <tr> <td colspan="2">发送邮件</td> </tr> <tr> <td>发件人：</td> <td><input type="text" name="cuname" value="<%=u.getUsername()%>"></td> </tr> <tr> <td>收件人：</td> <td><input type="text" name="csendto" value="zs"></td> </tr> <tr> <td>标题：</td> <td><input type="text" name="ctitle" value=""></td> </tr> <tr> <td>内容：</td> <td><textarea name="cmsgcontent" cols="30" rows="6" ></textarea></td> </tr> <tr> <td colspan="2"> <input type="submit" value="发送"> <a href="main.jsp"><input type="button" value="返回"></a> </td> </tr> </table> </form> </body> </html>
<%@page import="com.gd.dao.MsgDao"%> <%@page import="com.gd.entity.Msg"%> <%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <% request.setCharacterEncoding("utf-8"); String csendto = request.getParameter("csendto"); String ctitle = request.getParameter("ctitle"); String cmsgcontent = request.getParameter("cmsgcontent"); String cuname = request.getParameter("cuname"); Msg m =new Msg(); MsgDao md=new MsgDao(); m.setSendto(csendto); m.setTitle(ctitle); m.setMsgcontent(cmsgcontent); m.setUsernname(cuname); md.insert(m); session.setAttribute("Msg", m); request.getRequestDispatcher("index.jsp").forward(request, response); %>
