personalmessage.java

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

package huayi.xxzx.personalmessage;
import java.sql.*;
import java.util.*;
public class personalmessage{
	public personalmessage(){
	}
	public String getname(String id)
	{
		String name="";
		huayi.gg.dbConn.dbConn myConn=new huayi.gg.dbConn.dbConn();
		String sqlname="select * from T_YGDLXXB where YGBH='"+id+"'";
		ResultSet rsname=myConn.executeQuery(sqlname);
		try{
			while(rsname.next())
			{
				name=rsname.getString("YGXM");
			}
			return name;
		}catch(Exception e){System.out.print(e.toString());}
		return name;
	}
	public String getdepartment(String id)
	{
		String department="";
		huayi.gg.dbConn.dbConn myConn=new huayi.gg.dbConn.dbConn();
		String sqldep="select * from V_PERSONAL where YGBH='"+id+"'";
		ResultSet rsdep=myConn.executeQuery(sqldep);
		try
		{
			while(rsdep.next())
			{
				department=rsdep.getString("BMMC");
			}
			return department;
		}catch(Exception e){System.out.print(e.toString());}
		return department;
	}
	public String getduty(String id)
	{
		String duty="";
		huayi.gg.dbConn.dbConn myConn=new huayi.gg.dbConn.dbConn();
		String sqlduty="select * from V_PERSONAL where YGBH='"+id+"'";
		ResultSet rsduty=myConn.executeQuery(sqlduty);
		try
		{
			while(rsduty.next())
			{
				duty=rsduty.getString("ZWJC");
			}
			return duty;
		}catch(Exception e){System.out.print(e.toString());}
		return duty;
	}
	public int getpollcount(String id)
	{
		int pollcount=0;//投票的数目；
		//huayi.xxzx.nowtime.nowtime day=new huayi.xxzx.nowtime.nowtime();
		//String today=day.getdate();
		huayi.gg.dbConn.dbConn myConn=new huayi.gg.dbConn.dbConn();
		//huayi.xxzx.contraststr.contraststr cst=new huayi.xxzx.contraststr.contraststr();
		String sqlpoll="select * from V_TP where TPZBH='"+id+"' and DATEDIFF(day,TPJZSJ,getdate())<1";
		ResultSet rspoll=myConn.executeQuery(sqlpoll);
		//String deadline="";
		try
		{
			while(rspoll.next())
			{
				//deadline=rspoll.getString("TPJZSJ");
				//if(cst.contraststr(today,deadline))
				pollcount++;
			}
			return pollcount;
		}catch(Exception e){System.out.print(e.toString());}
		return pollcount;
	}
	public int gettaskcount(String id)
	{
		huayi.xxzx.nowtime.nowtime day=new huayi.xxzx.nowtime.nowtime();
		String today=day.getdate();
		int taskcount=0;
		huayi.gg.dbConn.dbConn myConn=new huayi.gg.dbConn.dbConn();
		huayi.xxzx.contraststr.contraststr cst=new huayi.xxzx.contraststr.contraststr();
		String sqltask="select * from T_DBSY where YGBH='"+id+"'";
		ResultSet rstask=myConn.executeQuery(sqltask);
		String deadline="";
		try{
			while(rstask.next())
			{
				deadline=rstask.getString("JSSJ");
				if(cst.contraststr(today,deadline))
					taskcount++;
			}
			return taskcount;
		}catch(Exception e){System.out.print(e.toString());}
		return taskcount;
	}
}