getmessages.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 = "select * from guestbook order by id";
		Connection conn = null;%>
		
		<p align="center"><a href="<%=context %>/addMessage.jsp">添加新的留言</a><br>
		留言内容<br><br></p>
		<%
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection(url, username, password);
			PreparedStatement pstmt = conn.prepareStatement(sql);
			ResultSet rs = pstmt.executeQuery();
			while (rs.next()) {%>
			<div align="center">
				<table width="600"  border="1" bordercolor="#000000">
				    <tr>
				      <td bordercolor="#ffffff" >编号</td>
				       <td bordercolor="#ffffff" ><%=rs.getInt("id") %></td>
				    </tr>
				    <tr>
				      <td bordercolor="#ffffff" >姓名</td>
				      <td bordercolor="#ffffff" > <%=rs.getString("name")%></td>
				    </tr>
				    <tr>
				      <td bordercolor="#ffffff" >电话</td>
				      <td bordercolor="#ffffff" ><%=StringUtil.chanageNull(rs.getString("phone"), "没填") %></td>
				    </tr>
				    <tr>
				      <td bordercolor="#ffffff" >email</td>
				      <td bordercolor="#ffffff" ><%= StringUtil.chanageNull(rs.getString("email"), "没填") %></td>
				    </tr>
				    <tr>
				      <td bordercolor="#ffffff" >主题</td>
				      <td bordercolor="#ffffff" ><%= rs.getString("title")%></td>
				    </tr>
				    <tr height="50">
				      <td bordercolor="#ffffff" >内容</td>
				      <td bordercolor="#ffffff" ><%=StringUtil.chanageNull(rs.getString("content"), "没填") %> </td>
				    </tr>
				    
  			</table>
  			<br><br>
  			</div>
			<%}%>

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