那位大虾能够提供一个JSP的留言版(数据库的),将不胜感激。。。 我的电邮是[email protected] 能给我也发一个吗:[email protected] 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 能给我也发一个吗:[email protected]谢谢!http://bbs.jspserver.com 给我发一个好吗?谢谢?邮箱[email protected]。因为最近公司急需这个,我因为男朋友母亲脚骨折不能加班,仅此一次偷懒,请不要拒绝我,好吗?先在此谢过了 能发给我一分吗?多谢 [email protected] liangxuan1979(不贪) :你的程序的ShowMessage.jsp页,为什么显示不出东西来? 能给我一个吗,谢了[email protected] 为什么只显示一空白页,请帮忙,谢谢!<%@ page contentType="text/html;charset=gb2312"%><%@ page import="java.sql.*"%><%@ page import="java.lang.*"%><%@ page import="java.io.*"%><%@ page import="javax.servlet.http.*"%><%@ page import="javax.servlet.*"%><%@ page import="java.text.*"%><% //定义留言记录数 int count=0; int pagesize=10; //获取参数 String p=request.getParameter("page"); if(p==null){p="1";} int _page=Integer.parseInt(p); //定义格式化日期对象 SimpleDateFormat df=new SimpleDateFormat("yyyy/MM/dd hh:mm:ss"); java.util.Date _tempdate=null; //连数据库 String _driver="sun.jdbc.odbc.JdbcOdbcDriver"; Class.forName(_driver).newInstance(); String _connectionURL="jdbc:odbc:FoxconnBar"; Connection _con=null; _con=DriverManager.getConnection(_connectionURL); try{ Statement _stmt=null; _stmt=_con.createStatement(); //取出数据库里留言记录数 String _sqlstring="select count(*) from MessageBoard" ; ResultSet _rs=null; _rs=_stmt.executeQuery(_sqlstring); _rs.next(); count=_rs.getInt(1); if(_rs!=null){_rs.close();} if(_stmt!=null){_stmt.close();} }catch(SQLException e) { out.println("取出数据库里留言记录数时出错:"+e.getMessage()); } //以下是选择起始游标 int _start=count-_page*pagesize+1; int _end=count-(_page-1)*pagesize+1; //这里结束 %><html><head><link href="./../Global.css" rel="stylesheet" type="text/css"><title>留言板</title></head><body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" ><jsp:include page="./../library/top.jsp" flush="true"/><table width="98%" border="0" cellspacing="0" cellpadding="0" align="center"> <tr> <td> <table width="100%" border="0" cellspacing="0" cellpadding="2" align="center"> <tr> <td class="cssBlack9">您当前所在位置:首页-->留言</td> <td class="cssGreen9" align="right"> <%//进行分页处理 if(_page>1){ out.print("<a href=ShowMessage.jsp?page="+(_page-1)+">"); //out.print(_page-1); out.print("【前一页】</a>"); } if(count>pagesize*_page){ out.print("<a href=ShowMessage.jsp?page="+(_page+1)+">"); //out.print(_page+1); out.print("【后一页】</a>"); } %> </td> </tr> </table> </td> </tr> <tr> <td> <table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolor="#000000"> <tr> <td bordercolor="#FFFFFF"> <table width="100%" background='../web/images/bg04.gif'> <% //取出数据库里数据 try{ Statement _stmt1=null; _stmt1=_con.createStatement(); String _sqlstring1="select * from MessageBoard where MBID>='"+_start+"' and MBID<='"+_end+"' order by MBID Desc"; ResultSet _rs1=null; _rs1=_stmt1.executeQuery(_sqlstring1); String _mbwriter=null; String _mbsubject=null; String _mbcontent=null; //String _ip=null; while(_rs1.next()) { //out.print("<tr><td><hr style='height:1;width:100%'></td></tr>"); _mbsubject=_rs1.getString("MBSubject"); //_ip=_rs1.getString("IP"); _mbcontent=_rs1.getString("MBContent"); _mbwriter=_rs1.getString("MBWriter"); _tempdate=_rs1.getTimestamp("MBDate"); out.print("<tr ><td colspan='2' class='cssGreen9'>"); out.print("主题:"); out.print(_mbsubject); out.print("</td></tr>"); out.print("<tr><td colspan='2' class='cssBlack9'>"); out.print(_mbcontent); out.print("</td></tr>"); out.print("<tr><td width='65%'></td>"); out.print("<td class='cssBlack9' >"); out.print("留言人:<font color=green>"); out.print(_mbwriter+"</font>"); out.print("("+df.format(_tempdate)+")"); out.print("</td></tr>"); } if(_rs1!=null){_rs1.close();} if(_stmt1!=null){_stmt1.close();} }catch(Exception e){ System.out.print(e.toString()); } %> </table> </td> </tr> </table> </td> </tr></table><jsp:include page="./AddMessage.jsp" flush="true"/></body></html> 能随便也给我一个吗?[email protected] 初学给发一份吧,谢[email protected] linux上tomcat关闭不了的问题 来个高手看看我的错误! 怎样用JSP执行.SQL脚本? 一大堆的提示,,不知道为什么,安装myeclipse4.0+eclipse3.1,,为什么这个提示 ? jfreechart 生成的图片无法在网页中显示问题 急!在线等~~~ 紧急:如何在BEAN中直接弹出一个提示框到屏幕,不通过JSP页面??? jsp 火狐 超链接 两次重复提交 如何实现打印功能? 关于排序的问题,在线等待~~~~~~~~~~~~~ 关于jdbc驱动程序 Bean的构造函数问题
[email protected]
<%@ page import="java.sql.*"%>
<%@ page import="java.lang.*"%>
<%@ page import="java.io.*"%>
<%@ page import="javax.servlet.http.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="java.text.*"%>
<%
//定义留言记录数
int count=0;
int pagesize=10;
//获取参数
String p=request.getParameter("page");
if(p==null){p="1";}
int _page=Integer.parseInt(p);
//定义格式化日期对象
SimpleDateFormat df=new SimpleDateFormat("yyyy/MM/dd hh:mm:ss");
java.util.Date _tempdate=null;
//连数据库
String _driver="sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(_driver).newInstance();
String _connectionURL="jdbc:odbc:FoxconnBar";
Connection _con=null;
_con=DriverManager.getConnection(_connectionURL); try{
Statement _stmt=null;
_stmt=_con.createStatement();
//取出数据库里留言记录数
String _sqlstring="select count(*) from MessageBoard" ;
ResultSet _rs=null;
_rs=_stmt.executeQuery(_sqlstring);
_rs.next();
count=_rs.getInt(1);
if(_rs!=null){_rs.close();}
if(_stmt!=null){_stmt.close();}
}catch(SQLException e)
{
out.println("取出数据库里留言记录数时出错:"+e.getMessage());
}
//以下是选择起始游标
int _start=count-_page*pagesize+1;
int _end=count-(_page-1)*pagesize+1;
//这里结束
%>
<html>
<head>
<link href="./../Global.css" rel="stylesheet" type="text/css">
<title>留言板</title>
</head><body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" >
<jsp:include page="./../library/top.jsp" flush="true"/>
<table width="98%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="2" align="center">
<tr>
<td class="cssBlack9">您当前所在位置:首页-->留言</td>
<td class="cssGreen9" align="right">
<%//进行分页处理
if(_page>1){
out.print("<a href=ShowMessage.jsp?page="+(_page-1)+">");
//out.print(_page-1);
out.print("【前一页】</a>");
}
if(count>pagesize*_page){
out.print("<a href=ShowMessage.jsp?page="+(_page+1)+">");
//out.print(_page+1);
out.print("【后一页】</a>");
}
%>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolor="#000000">
<tr>
<td bordercolor="#FFFFFF">
<table width="100%" background='../web/images/bg04.gif'>
<% //取出数据库里数据
try{
Statement _stmt1=null;
_stmt1=_con.createStatement();
String _sqlstring1="select * from MessageBoard where MBID>='"+_start+"' and MBID<='"+_end+"' order by MBID Desc";
ResultSet _rs1=null;
_rs1=_stmt1.executeQuery(_sqlstring1);
String _mbwriter=null;
String _mbsubject=null;
String _mbcontent=null;
//String _ip=null;
while(_rs1.next())
{
//out.print("<tr><td><hr style='height:1;width:100%'></td></tr>");
_mbsubject=_rs1.getString("MBSubject");
//_ip=_rs1.getString("IP");
_mbcontent=_rs1.getString("MBContent");
_mbwriter=_rs1.getString("MBWriter");
_tempdate=_rs1.getTimestamp("MBDate");
out.print("<tr ><td colspan='2' class='cssGreen9'>");
out.print("主题:");
out.print(_mbsubject);
out.print("</td></tr>");
out.print("<tr><td colspan='2' class='cssBlack9'>");
out.print(_mbcontent);
out.print("</td></tr>");
out.print("<tr><td width='65%'></td>");
out.print("<td class='cssBlack9' >");
out.print("留言人:<font color=green>");
out.print(_mbwriter+"</font>");
out.print("("+df.format(_tempdate)+")");
out.print("</td></tr>");
}
if(_rs1!=null){_rs1.close();}
if(_stmt1!=null){_stmt1.close();}
}catch(Exception e){
System.out.print(e.toString());
}
%>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<jsp:include page="./AddMessage.jsp" flush="true"/>
</body>
</html>
[email protected]