fun.java

一个关于商业的网站

package com.everstar.usermanage;

import java.sql.*;
import java.io.*;
import java.util.ArrayList;
import com.everstar.database.*;

public class Fun {

	private int functionID;
	private String functionName;
	private SubSystem subSys;
	private Database dbConn;
	private String operate;

//	private static final String INSERT_FUNCTION = "INSERT INTO fun(systemID,functionID,funname) values(?,?,?)";
//	private static final String UPDATE_FUNCTION = "UPDATE fun SET FUNNAME=? where systemid=? and functionid=?";
//	private static final String LOAD_FUNCTION = "SELECT FUNCTIONID,FUNNAME FROM fun where systemid=? and functionid=?";
//	private static final String GETMAXID = "SELECT MAX(FUNCTIONID) FROM fun";

	//constructor
	public Fun(String functionName,String operate,SubSystem subSys,Database dbConn)
	{
		this.dbConn = dbConn;
		this.functionName = functionName;
		this.subSys = subSys;
		this.operate = operate;
		this.functionID = getMaxId()+1;
		inserttodb();
	}

	public Fun(int functionID,SubSystem subSys,Database dbConn)
	{
		this.dbConn = dbConn;
		this.subSys = subSys;
		loadfromdb(functionID);
	}


	public String getfunctionName()
	{
		return functionName;
	}

	public void setfunctionName(String functionName)
	{
		this.functionName = functionName;
		updatedb();
	}

	public String getoperate()
	{
		return operate;
	}

	public void setoperate(String operate)
	{
		this.operate = operate;
		updatedb();
	}

	private void inserttodb()
	{
        try
        {
        	String INSERT_FUNCTION = "INSERT INTO fun(systemID,functionID,funname,operate)"
        	+" values("+subSys.getsubSystemID()+","+functionID+",'"+functionName+"','"+operate+"')";
        	int i = dbConn.insert(INSERT_FUNCTION);
		}
        catch( Exception sqle )
        {
            sqle.printStackTrace();
        }

	}

	private void loadfromdb(int functionID)
	{
        try
        {
        	String LOAD_FUNCTION = "SELECT FUNCTIONID,FUNNAME,operate FROM fun "
        	+" where systemid="+subSys.getsubSystemID()+" and functionid="+functionID;
        	ResultSet rs = dbConn.select(LOAD_FUNCTION);
			if(rs.next())
			{
			this.functionID = rs.getInt(1);
			this.functionName = rs.getString(2);
			this.operate = rs.getString(3);
			}
			rs.close();
        	dbConn.close();

		}
        catch( Exception sqle )
        {
            sqle.printStackTrace();

        }

	}
	private void updatedb()
	{
        try
        {
			String UPDATE_FUNCTION = "UPDATE fun SET FUNNAME='"+functionName+"', operate='"+operate+"'"
			 +" where systemid="+subSys.getsubSystemID()+" and functionid="+functionID;
        	int i = dbConn.update(UPDATE_FUNCTION);
		}
        catch( Exception sqle )
        {
            sqle.printStackTrace();
        }

	}

	private int getMaxId()
	{
        int temp = 0;
        try
        {
        	String GETMAXID = "SELECT MAX(FUNCTIONID) FROM fun";
        	ResultSet rs =dbConn.select(GETMAXID);
        	if(rs.next())
        	temp = rs.getInt(1);
        	rs.close();
        	dbConn.close();

		}
        catch( Exception sqle )
        {
            sqle.printStackTrace();
        }

		return temp;

	}
}