📄 index.jsp

📁 一个新闻系统
💻 JSP
字号:
 <html><body bgcolor="lightyellow">
<font color="red" size="5">留言内容:</font>
<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*"%>
<%@ page import="java.lang.Math.*" %>
<%! 
String id = "";
Connection conn=null;
ResultSet rsTmp = null;
Statement stmt=null;
ResultSet rs=null;
String sql = "";
int PageSize = 5;  
int Page = 3; 
int totalPage=1;  
String str = "";
public String ShowOnePage(ResultSet rs, int Page, int PageSize)
{
	  str = "";
	  
	  try {
	  		rs.absolute( (Page-1) * PageSize + 1);
	  }catch(SQLException e) {
	  }
	
		for(int i=0;i<=(Page-1) * PageSize;i++)
	  	{
	  	  try
	  	  {
	  	    rs.next();
	  	  }
	  	  catch(Exception e)
	  	  {
	  	  } 
	  	}
	
	  	for(int iPage=1; iPage<=PageSize; iPage++) {
	     str += RsToGbook(rs);
		 try {
		     if(!rs.next()) break;
		 }catch(Exception e) {}
	  }
	  return str;
}
	public String RsToGbook(ResultSet rs)
	{
		String tt="";
		String name="";
		String memo="";
		String gtime="";
		String del="";
		String ping="";
		String id="";
		String ip="";
		String update="";
		String news_id="";
		try{
		name=rs.getString("name");
		memo=rs.getString("content");
		gtime=rs.getString("gtime");
		ip=rs.getString("ip");
		id=rs.getString("id");
		ping=rs.getString("ping");
		news_id=rs.getString("news_id");
		}
		catch(Exception e)
		{
		System.out.println("出现错误!")	;
		System.out.println();}

		if(ping.equals("0"))
			ping="<a href=index.jsp?update="+id+"&&id="+news_id+">是</a>";
		if(ping.equals("1"))
			ping="已被屏蔽!!";
		if(del.equals(""))
			del="<a href=index.jsp?del="+id+"&&id="+news_id+">删除</a>";
		tt+="<table border='0' width='50%'>";
		tt+="第"+news_id+"条新闻";
		tt+="<tr><td><table border='0'><tr><td>";
		tt+="<b>网名: </b>"+name+"</td><td>";
		tt+="</td></tr>";
		tt+="<tr><td></td></tr>";
		tt+="<tr><td colspan='4'>"+"<b>留言: </b>"+memo+"</td></tr>";
		tt+="<tr><td colspan='4'></td></tr>";
		tt+="<hr border='1' width='100%'></table>";
		tt+="<tr><td>是否屏蔽</td><td>";
		tt+=ping+"</td></tr>";
		tt+="<tr><td><b>ip地址:</b></td><td>"+ip+"</td></tr>";
		tt+="<tr><td><b>是否删除:</b></td><td>"+del+"</td></tr></table><hr></hr>";
		return tt;
			
	}
 %>
 <% String news_id="";
 	news_id=request.getParameter("id");
	 try{
		String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:/Program Files/Apache Group/Tomcat 4.1/webapps/examples/jsp/db1.mdb";
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	 	conn=DriverManager.getConnection(strurl);
		stmt=conn.createStatement();
		rs=stmt.executeQuery("select * from gbook where news_id="+news_id+" order by gtime desc");
		if( !rs.next() ){
			out.println("<center><font color='blue'>目前还没有评论!</font><br><br><br>");
			out.println("<center><a href=newsedit.jsp>返回</a><br><br><br>");
			return;
		}
	}
	catch(Exception e)
	{
		out.println("语句输入错误!");
	}


	if(request.getParameter("del")!=null) 
	stmt.executeUpdate("delete * from gbook where id=" + request.getParameter("del"));
	if(request.getParameter("update")!=null  )
		stmt.executeUpdate("update gbook set ping=1 where id="+request.getParameter("update"));
	
	rsTmp=stmt.executeQuery("select count(*) as mycount from gbook where news_id="+news_id);
	rsTmp.next();
	int totalrecord = rsTmp.getInt("mycount");
	if(totalrecord % PageSize ==0) 
	{
	  totalPage = totalrecord / PageSize;  
	}
	else 
	{ 
	  totalPage = (int) Math.floor( totalrecord / PageSize ) + 1;  
	}
	
	
	if(totalPage == 0) 
	{
	  totalPage = 1;
	}
	
	rsTmp.close();
	

	try 
	{
		if(request.getParameter("Page")==null || request.getParameter("Page").equals("")) 
		{
		   Page = 1;
		}
		else
		{
		   Page = Integer.parseInt(request.getParameter("Page"));
		}
	} 
	catch(java.lang.NumberFormatException e)
    { 
        
		Page = 1;
	}

	if(Page < 1)  Page = 1;
	if(Page > totalPage) Page = totalPage;
	

	rs=stmt.executeQuery("select * from gbook where news_id="+news_id+" order by gtime desc");

	out.println(ShowOnePage(rs, Page, PageSize));
	out.println("<br>");
	out.println("<center>");
	out.println("共"+totalrecord+"条评论");
	out.println("</center>");
%>



 <form Action="index.jsp" Method="GET">
 <% if(Page!=1)
 {
 	
 	out.println("<a href=index.jsp?Page=1>第一页</a>");
 	out.println("<a href=index.jsp?Page="+(Page-1)+">上一页</a>");
 }
	if(Page!=totalPage){
	out.println("<a href=index.jsp?Page="+(Page+1)+">下一页</a>");
	out.println("<a href=index.jsp?Page="+totalPage+">最后一页</a>");
	}
  %>
  <p>输入页面:<input type="text" name="Page" size="3">页数:<font color="red"><%=Page%>/<%=totalPage%></font></p>
  </form>
  
  </div>
  </body>
  <center><a href=newsedit.jsp><b>编辑新闻</b></a></center>
  </html>
💿 文件大小 84 K
👤 上传用户 linux_open_lab
📂 所属分类其他数据库
🏷️ 相关标签

#新闻
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -