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 DATEDIFF(day,FBSJ,getdate())<1";
		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 DATEDIFF(day,ZTSJ,getdate())<1";
		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()               //没有用了04-10-27
	{
		//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 DATEDIFF(day,LYSJ,getdate())<1";
		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 getpollcount()
	{
		//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 sqlpoll="select * from T_TPWTB where DATEDIFF(day,TPJZSJ,getdate())<1";
		ResultSet rspoll=myConn.executeQuery(sqlpoll);
		int pollcount=0;
		//String deadline="";
		//huayi.xxzx.contraststr.contraststr cst=new huayi.xxzx.contraststr.contraststr();
		try
		{
			while(rspoll.next())
			{
				//deadline=rsroll.getString("TPJZSJ");
				//if(cst.contraststr(today,deadline))
					pollcount++;
			}
			return pollcount;
		}catch(Exception e){System.out.print(e.toString());}
		return pollcount;
	}
}