sysinfobiz.java

网上购物系统

package eshopsys.sysinfo.biz;

import eshopsys.tools.base.*;
import eshopsys.tools.database.*;
import eshopsys.sysinfo.model.*;

import java.sql.*;

public class SysInfoBiz extends BaseBiz {
String tableName="tbl_sysinfo";
SysInfoDao sysinfoDao=new SysInfoDao();

public SysInfoBiz() {
	this.baseDao = new SysInfoDao();
}

public void registerSysInfo(SysInfoEntity sysinfo) throws Exception
{

	try{
	////////////////////////////////////////		
		sysinfoDao.insert(sysinfo);
    ////////////////////////////////////////
	}
	catch(Exception e)
	{
		throw e;
	}
	finally{
		//sysinfoDao.CloseConnection();
	}
	
}
//////////////////////////////////////////////////////////////////////////
public void updateSysInfo(SysInfoEntity sysinfo)throws Exception
{Connection con=DataBaseTool.getConnection();
  try{
	////////////////////////////////////////		
	  sysinfoDao.update(sysinfo);
    ////////////////////////////////////////
	}
	catch(Exception e)
	{
		throw e;
	}
	finally{
		//sysinfoDao.CloseConnection();
	}
    	
}
public SysInfoEntity getSysInfo() throws Exception
{
	SysInfoEntity sysInfo=null ;
	sysInfo=((SysInfoEntity[])(sysinfoDao.selectArrayByQueryString("select * from tbl_sysinfo")))[0];
	return sysInfo;
}
public void deleteOldSysInfo()throws Exception
{
	sysinfoDao.deleteAllRecords(tableName);
}
//////////////////////////////////////////////////////////////////////////
}