dailylogic.java

Struts入门的一个好例子 Struts入门的一个好例子

package bily.notebook.struts.biz;

import java.sql.SQLException;
import java.util.List;

import bily.notebook.struts.iBatis.DBConnection;
import bily.notebook.struts.iBatis.DatabaseException;
import bily.notebook.struts.pojo.Daily;
import bily.notebook.struts.pojo.view.DailyView;

public class DailyLogic {

	public static final int _RTN_SUCCESS = 0;
	public static final int _RTN_FAILURE = -1;

	public static DailyView getDaily(int id) throws SQLException, DatabaseException {
		DBConnection sqlCon = new DBConnection();
		DailyView record;
		try {
			sqlCon.openTransaction();
			DailyView para = new DailyView();
			para.setId(id);
			record = (DailyView)sqlCon.executeQueryForObject("Daily_Search", para);
		} finally {
			sqlCon.closeTransaction();
		}
		return record;
	}
	
	public static List<?> getDailies(Daily info) throws SQLException, DatabaseException {
		DBConnection sqlCon = new DBConnection();
		List<?> list = null;
		try {
			sqlCon.openTransaction();
			list = sqlCon.executeQueryForList("Daily_Search", info);
		} finally {
			sqlCon.closeTransaction();
		}
		return list;
	}

	public static int insert(Daily daily) throws SQLException, DatabaseException {
		DBConnection sqlCon = new DBConnection();
		try {
			sqlCon.openTransaction();
//			int r = (Integer)sqlCon.insert("Daily_Add", daily);
//			System.out.println(r);
			sqlCon.insert("Daily_Add", daily);
			sqlCon.commitTransaction();
		} catch (Exception e) {
			e.printStackTrace();
			return _RTN_FAILURE;
		} finally {
			sqlCon.closeTransaction();
		}
		return _RTN_SUCCESS;
	}
	
	public static int update(Daily daily) throws SQLException, DatabaseException {
		DBConnection sqlCon = new DBConnection();
		try {
			sqlCon.openTransaction();
			sqlCon.update("Daily_Upd", daily);
			sqlCon.commitTransaction();
		} catch (Exception e) {
			e.printStackTrace();
			return _RTN_FAILURE;
		} finally {
			sqlCon.closeTransaction();
		}
		return _RTN_SUCCESS;
	}

	public static int delete(int id) throws SQLException, DatabaseException {
		DBConnection sqlCon = new DBConnection();
		try {
			sqlCon.openTransaction();
			Daily para = new Daily();
			para.setId(id);
			sqlCon.delete("Daily_Del", para);
			sqlCon.commitTransaction();
		} catch (Exception e) {
			e.printStackTrace();
			return _RTN_FAILURE;
		} finally {
			sqlCon.closeTransaction();
		}
		return _RTN_SUCCESS;
	}
	
}