addmessagehandler.jsp

mysql和jdbc的应用留言jsp编写.随便改下就很有用的。很不错的

<%@ page language="java"  pageEncoding="UTF-8"%>
<%@ include file="header.jsp" %>
<%@ page import="java.sql.*,java.io.*,java.text.*,javax.servlet.*,
javax.servlet.http.*,webbook.util.StringUtil" %>
<%
String url = "jdbc:mysql://localhost/ajax?useUnicode=true&characterEncoding=utf8";
String username = "root";
String password = "ajax";

String sql = "insert into guestbook (id,name,email,phone,title,content,time) values(null,?,?,?,?,?,?)";
int result = 0;
Connection conn = null;

request.setCharacterEncoding("utf-8");
String name = request.getParameter("name");
String title = request.getParameter("title");

response.setContentType("text/html;charset=utf-8");


if (StringUtil.validateNull(name)) {%>
	对不起，姓名不能为空，请您重新输入！<br>
	<a href="<%=context %>/addMessage.jsp">添加新的留言</a><br>
	
<%} else if (StringUtil.validateNull(title)) {%>
	对不起，主题不能为空，请您重新输入！<br>
	<a href="<%=context%>/addMessage.jsp">添加新的留言</a><br>
<%} else {
	try {
		Class.forName("com.mysql.jdbc.Driver");
		conn = DriverManager.getConnection(url, username, password);

		PreparedStatement pstmt = conn.prepareStatement(sql);
		pstmt.setString(1, StringUtil.filterHtml(name));
		pstmt.setString(2, StringUtil.filterHtml(request.getParameter("email")));
		pstmt.setString(3, StringUtil.filterHtml(request.getParameter("phone")));
		pstmt.setString(4, StringUtil.filterHtml(title));
		pstmt.setString(5, request.getParameter("content"));

		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
		pstmt.setString(6, sdf.format(new java.util.Date()));
		result = pstmt.executeUpdate();
		pstmt.close();
	} catch (ClassNotFoundException e) {
		e.printStackTrace();
	} catch (SQLException e) {
		e.printStackTrace();
	} finally {
		try {
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	if (result == 0) {%>
		对不起，添加留言不成功，请您重新输入！<br>
		<a href="<%=context %>/addMessage.jsp">添加新的留言</a><br>
	<%} else {%>
		祝贺您，成功添加留言。<br>
		<a href="<%=context %>/getMessages.jsp">查看所有留言内容</a><br>
	<%}
	
	
}


%>
<%@ include file="footer.jsp" %>