publicmessage.java

这个是我们做土地局的一个项目。感觉不错。欢迎下载

package huayi.xxzx.publicmessage;
import java.sql.*;
import java.util.*;
public class publicmessage{
	public publicmessage(){
	}
	public int getnoticecount()
	{
		
		huayi.xxzx.nowtime.nowtime date=new huayi.xxzx.nowtime.nowtime();
		String today=date.getdate();
		huayi.gg.dbConn.dbConn myConn=new huayi.gg.dbConn.dbConn();
		//公共信息：公告栏、论坛、留言板、投票系统
		String sqlnotice="select * from T_GGL where FBSJ like '"+today+"%'";
		ResultSet rsnotice=myConn.executeQuery(sqlnotice);
		int noticecount=0;
		try{
			while(rsnotice.next())
			{
				noticecount++;
			}
			return noticecount;
		}catch(Exception e){System.out.print(e.toString());}
		return noticecount;
	}
	public int getforumcount()
	{
		huayi.xxzx.nowtime.nowtime date=new huayi.xxzx.nowtime.nowtime();
		String today=date.getdate();
		huayi.gg.dbConn.dbConn myConn=new huayi.gg.dbConn.dbConn();
		String sqlforum="select * from T_LTSJB where ZTSJ like '"+today+"%'";
		ResultSet rsforum=myConn.executeQuery(sqlforum);
		int forumcount=0;
		try{
			while(rsforum.next())
			{
				forumcount++;
			}
			return forumcount;
		}catch(Exception e){System.out.print(e.toString());}
		return forumcount;
	}
	public int getmsgcount()
	{
		huayi.xxzx.nowtime.nowtime date=new huayi.xxzx.nowtime.nowtime();
		String today=date.getdate();
		huayi.gg.dbConn.dbConn myConn=new huayi.gg.dbConn.dbConn();
		String sqlmessage="select * from T_LYXXB where LYSJ like '"+today+"%'";
		ResultSet rsmessage=myConn.executeQuery(sqlmessage);
		int messagecount=0;
		try
		{
			while(rsmessage.next())
			{
				messagecount++;
			}
			return messagecount;		
		}catch(Exception e){System.out.print(e.toString());}
		return messagecount;
	}
	public int getrollcount()
	{
		huayi.xxzx.nowtime.nowtime date=new huayi.xxzx.nowtime.nowtime();
		String today=date.getdate();
		huayi.gg.dbConn.dbConn myConn=new huayi.gg.dbConn.dbConn();
		String sqlroll="select * from T_TPWTB ";
		ResultSet rsroll=myConn.executeQuery(sqlroll);
		int rollcount=0;
		String deadline="";
		huayi.xxzx.contraststr.contraststr cst=new huayi.xxzx.contraststr.contraststr();
		try
		{
			while(rsroll.next())
			{
				deadline=rsroll.getString("TPJZSJ");
				if(cst.contraststr(today,deadline))
					rollcount++;
			}
			return rollcount;
		}catch(Exception e){System.out.print(e.toString());}
		return rollcount;
	}
}