81,094
社区成员
发帖
与我相关
我的任务
分享
<form action="servlet/WriteLog" method="post">
<table>
<tr><td>标题 <input type="text" name="titleName"/></td></tr>
<tr><td>日志内容<input type="text" name="contents" size="30" maxlength="100"/></td></tr>
<tr><td><input type="submit" name="titleName" value="提交"></td></tr>
</table>
</form>
public class WriteLog extends HttpServlet {
/**
*
*/
private static final long serialVersionUID = 1L;
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String titleName = request.getParameter("titleName");
String contents = request.getParameter("contents");
DBConn conn = new DBConn();
conn.getConn();
conn.insertLog(titleName,contents);
conn.closeConn();
HttpSession session = request.getSession();
session.setAttribute("titleName", titleName);
session.setAttribute("contents", contents);
javax.servlet.RequestDispatcher dis = request
.getRequestDispatcher("../XXX.jsp");
dis.forward(request, response);
}
}
public List ListUser() {
List<Users> list=new ArrayList<Users>();
try {
Users user=null;
stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from users where userName=" + "'aaa'");
while (rs.next()) {
user=new Users();
user.setName(rs.getString("userName"));
user.setPwd(rs.getString("userPwd"));
list.add(user);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
public void insertLog(String titleName,String contents){
try {
stmt = conn.createStatement();
stmt.execute("insert into blog(titleName,contents)values" + "('"
+ titleName + "','" + contents + "')");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public class WriteLog extends HttpServlet {
/**
*
*/
private static final long serialVersionUID = 1L;
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String titleName = request.getParameter("titleName");
String contents = request.getParameter("contents");
DBConn conn = new DBConn();
conn.getConn();
conn.insertLog(titleName,contents);
conn.closeConn();
}
}