tztgmanager.java

基于java的图文报表系统的设计与实现,报表的生成一直是企业级应用系统开发时专案人员所面临的严峻课题.同时也是信息化系统中重要的一环。优秀的报表工具以实现将数据转化为信息.为决策提供良好的依据.为信息

package manager;

import java.sql.Connection;
import java.util.ArrayList;
import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.ResultSetHandler;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import pojo.TztgBean;
import dbmaster.DbMaster;

public class TztgManager {
	QueryRunner run = new QueryRunner();

	ResultSetHandler rsh = null;

	/**
	 * 得到系统所有的通知通告表
	 * 
	 * @param newsId
	 * @return
	 */
	public List getAll() {
		Connection con = null;
		List list = null;
		try {
			con = DbMaster.createConn();

			String sql = "select * from tztgb order by lrsj DESC";

			rsh = new BeanListHandler(TztgBean.class);
			list = (List) run.query(con, sql, rsh);
		} catch (Exception e) {
			System.out.println("getAll-->" + e);
		} finally {
			try {
				if (con != null) {
					con.close();
				}
			} catch (Exception e1) {
				System.out.println("getAll-->" + e1);
			}
		}
		return list;
	}

	/**
	 * 通过id得到通知通告表Bean
	 * 
	 * @param newsId
	 * @return
	 */
	public TztgBean getTztgById(String id) {

		Connection con = null;
		TztgBean tztgBean = null;
		try {
			con = DbMaster.createConn();

			String sql = "select * from tztgb where id='" + id + "'";

			rsh = new BeanHandler(TztgBean.class);
			tztgBean = (TztgBean) run.query(con, sql, rsh);
			System.out.println("MMMM----tztgBean.getLrsj()==>"+tztgBean.getLrsj());
			System.out.println("MMMM----tztgBean.getLrr()==>"+tztgBean.getLrr());
		} catch (Exception e) {
			System.out.println("-->" + e);
		} finally {
			try {
				if (con != null) {
					con.close();
				}
			} catch (Exception e1) {
				System.out.println("-->" + e1);
			}
		}
		return tztgBean;
	}

	/**
	 * 删除通知通告，通过id
	 * 
	 * @param newsId
	 * @return
	 */
	public int delTztgByid(String id) {
		int i = 0;
		Connection con = null;
		try {
			con = DbMaster.createConn();

			String sql = "delete from tztgb where id='" + id + "'";
			i = run.update(con, sql);
		} catch (Exception e) {
			System.out.println("  ->" + e);
		} finally {
			try {
				if (con != null) {
					con.close();
				}
			} catch (Exception e2) {
				System.out.println(e2);
			}

		}
		return i;
	}

	/**
	 * 新增或者修改通知通告表
	 * 
	 * @param newsId
	 * @return
	 */
	public int XzOrXgTztgBean(List list) {
		int i = 0;
		Connection con = null;
		try {
			con = DbMaster.createConn();
			// 通过list的size来判断是新增还是修改，size为4是新增，size是5是修改。
			int j = list.size();
			for(int k=0;k<list.size();k++){
				list.get(k);
				
			}
			
			if (j == 4) {
				List list2 = new ArrayList();
				list2.add("");
				list2.addAll(list);
				String sql = "insert into tztgb values(?,?,?,?,?)";
				i = run.update(con, sql, list2.toArray());
			} else if (j == 5) {
				String sql = "update tztgb set bt=?,nr=?,lrsj=?,lrr=? where id=?";
				i = run.update(con, sql, list.toArray());
			}

		} catch (Exception e) {
			System.out.println("  ->" + e);
		} finally {
			try {
				if (con != null) {
					con.close();
				}
			} catch (Exception e2) {
				System.out.println(e2);
			}

		}
		return i;
	}
}