- 论坛徽章:
- 0
|
有朋友拜托写一个留言板。本想找一个现成的用,结果没有发现好的。基本上用起来太复杂,不够简单。
自己写了一个感觉还可以。贴上来大家一起分享。
<%@ page language="java" contentType="text/html;charset=gb2312"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<!-- take database connection -->
<sql:setDataSource var="datasource"
url="jdbc:mysql://localhost:3306/msgmanager?default-character-set=gb2312" driver="org.gjt.mm.mysql.Driver"
user="root" password="111111"/>
<!-- define max rows per page -->
<c:set var="maxRows" value="3"/>
<!-- insert new description into databases if user inputed -->
<c:if test="${param.content!=null}">
<sql:transaction dataSource="${datasource}">
<sql:update>
insert into bbs (content,enable) values (?,?)
<sql:param value="${param.content}"/>
<sql:param value="Y"/>
</sql:update>
</sql:transaction>
</c:if>
<!-- take some description from database -->
<sql:query var="queryresults" dataSource="${datasource}" startRow="${param.startRow}" maxRows="${maxRows}">
SELECT * FROM bbs ORDER BY id DESC
</sql:query>
<table>
<c:forEach var="row" items="${queryresults.rows}">
<tr>
<td><fmt:formatDate value="${row.post_tme}" pattern="MM-dd HH:mm"/></td>
</tr>
<tr>
<td>${row.content}</td>
</tr>
</c:forEach>
</table>
<!-- generate navigation bar -->
<c:if test="${param.startRow>0}">
<a href="?startRow=${param.startRow-maxRows>=0?param.startRow-maxRows:0}">上一页</a>
</c:if>
<c:if test="${queryresults.rowCount >0 }">
<a href="?startRow=${param.startRow+maxRows}">下一页</a>
</c:if>
<!-- post form -->
<hr/>
<form action="" method="get">
<textarea name="content" ></textarea><br/>
<input type="submit"/>
</form> |
|