usercount.java

linux+apache+tomcat+mysq1+jsp开发的管理系统

package com.javaBean;

import com.javaBean.getData;
import java.sql.*;

public class UserCount
{
		private String Count = null;
        private String sq = null;
		private String addr = null;
		private String updateCount = null;
        private String insertCount = null;
        private ResultSet rs = null;
		getData getdata = new getData();
        		
		public void setTotalUserCount(int num, String sql, String add)
	    {
            try{
			rs = getdata.executeQuery(sql,add);
            if(rs.next())
            {
                 Count = rs.getString(1);
            }
            sq = "select TotalUserCount from tbl_propertymanage where ServiceID='"+num+"'";
            addr = "jdbc:mysql://localhost:3306/managedb?user=root&password=123123&useUnicode=true&characterEncoding";
            rs = getdata.executeQuery(sq,addr);
            if(rs.next())
            {
                updateCount = "UPDATE tbl_propertymanage SET TotalUserCount="+Count+" where ServiceID='"+num+"'";
                getdata.executeUpdate(updateCount,addr);
            }else{
                insertCount = "INSERT INTO tbl_propertymanage (TotalUserCount) VALUES ("+Count+") where ServiceID='"+num+"'";
                getdata.executeUpdate(insertCount,addr);
            }
		    /*rs = getdata.executeQuery(sq,addr);
            while(rs.next())
		    {
			    Count = rs.getString("TotalUserCount");
		    }*/
			getdata.close();
			}catch(SQLException ex)
			{
				System.out.println(ex);
			}
			//return Count;
		}
		
		public void setTodayUserCount(int num, String sql, String add)
	   { 
			try{
			rs = getdata.executeQuery(sql,add);
            if(rs.next())
            {
               Count = rs.getString(1);
		    }
            sq = "select TodayUserCount from tbl_propertymanage where ServiceID='"+num+"'";
            addr = "jdbc:mysql://localhost:3306/managedb?user=root&password=123123&useUnicode=true&characterEncoding";
            rs = getdata.executeQuery(sq,addr);
            if(rs.next())
            {
               updateCount = "UPDATE tbl_propertymanage SET TodayUserCount="+Count+" where ServiceID='"+num+"'";
               getdata.executeUpdate(updateCount,addr);
            }else{
               insertCount = "INSERT INTO tbl_propertymanage (TodayUserCount) VALUES ("+Count+") where ServiceID='"+num+"'";
               getdata.executeUpdate(insertCount,addr);
        }
		/*rs = getdata.executeQuery(sq,addr);
        while(rs.next())
		{
			Count = rs.getString("TodayUserCount");
		}*/
        getdata.close();
		}catch(SQLException ex)
		   {
			   System.out.println(ex);
		   }
		//return Count;
	   }
}