stipenddao.java

来自「xueyuan gongzuojieshao」· Java 代码 · 共 240 行

/*
 * 创建日期 2007-5-2
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package dao.login;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import bean.stipend.stipendBean;
import oracle.DBConnection;
/**
 * @author Administrator
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class stipendDao {
	
	//向stipend表里插如相关信息
	
	public int stipendInsert(stipendBean bean){
		int ret = 0;
		String sql =" insert into stipend values(sti_seq.nextval,?,?,?,?,?,?,?,?,to_date(?,'YYYY-MM-DD'),?)";
		Connection conn = null;
		PreparedStatement stm = null;
		try {
			conn = DBConnection.getConnection();
			conn.setAutoCommit(false);
			stm = conn.prepareStatement(sql);
			stm.setString(1,bean.getName());
			stm.setString(2,bean.getBasic());
			stm.setString(3,bean.getEat());
			stm.setString(4,bean.getHouse());
			stm.setString(5,bean.getDuty());
			stm.setString(6,bean.getScot());
			stm.setString(7,bean.getPunisthMent());
			stm.setString(8,bean.getOther());
			stm.setString(9,bean.getGrantTime());
			stm.setString(10,bean.getTotal());
			stm.executeUpdate();
			conn.commit();
			ret = 1;
		} catch (SQLException e) {
			try {
				conn.rollback();
			} catch (SQLException e1) {
				// TODO 自动生成 catch 块
				e1.printStackTrace();
			}
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}finally{
			try {
				conn.setAutoCommit(true);
				stm.close();
				conn.close();
			} catch (SQLException e1) {
				// TODO 自动生成 catch 块
				e1.printStackTrace();
			}
		}
		return ret;
	}
	
	//查询所有信息
	
	public List stipendSelect(){
		List list = new ArrayList();
		String sql =" select * from stipend";
		Connection conn = null;
		PreparedStatement stm = null;
		ResultSet rs = null;
		try {
			conn =DBConnection.getConnection();
			stm = conn.prepareStatement(sql);
			rs = stm.executeQuery();
			while(rs.next()){
				stipendBean bean = new stipendBean();
				bean.setId(rs.getString("id"));
				bean.setName(rs.getString("name"));
				bean.setBasic(rs.getString("basic"));
				bean.setEat(rs.getString("eat"));
				bean.setHouse(rs.getString("house"));
				bean.setDuty(rs.getString("duty"));
				bean.setScot(rs.getString("scot"));
				bean.setOther(rs.getString("other"));
				bean.setPunisthMent(rs.getString("punisthMent"));
				bean.setGrantTime(rs.getString("grantTime"));
				bean.setTotal(rs.getString("total"));
				list.add(bean);		
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}finally{
			try {
				rs.close();
				stm.close();
				conn.close();
			} catch (SQLException e1) {
				// TODO 自动生成 catch 块
				e1.printStackTrace();
			}
		}
		return list;
	}
	
	public stipendBean stipendSelectAll(stipendBean bean){
		List list = new ArrayList();
		String sql =" select * from stipend where id="+bean.getId();
		Connection conn = null;
		PreparedStatement stm = null;
		ResultSet rs = null;
		try {
			conn =DBConnection.getConnection();
			stm = conn.prepareStatement(sql);
			rs = stm.executeQuery();
			while(rs.next()){
				bean.setName(rs.getString("name"));
				bean.setBasic(rs.getString("basic"));
				bean.setEat(rs.getString("eat"));
				bean.setHouse(rs.getString("house"));
				bean.setDuty(rs.getString("duty"));
				bean.setScot(rs.getString("scot"));
				bean.setOther(rs.getString("other"));
				bean.setPunisthMent(rs.getString("punisthMent"));
				bean.setGrantTime(rs.getString("grantTime"));
				bean.setTotal(rs.getString("total"));		
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}finally{
			try {
				rs.close();
				stm.close();
				conn.close();
			} catch (SQLException e1) {
				// TODO 自动生成 catch 块
				e1.printStackTrace();
			}
		}
		return bean;
	}
	
	//根据id修改相应的信息
	
	public int update(stipendBean bean){
		int ret = 0;
		String sql =" update stipend set name='"+bean.getName()+"' ," +
				" basic = "+bean.getBasic()+", eat="+bean.getEat()+
				", house="+bean.getHouse()+", duty="+bean.getDuty()+
				", scot="+bean.getScot()+", punisthMent="+bean.getPunisthMent()+
				", other="+bean.getOther()+", " +
			"grantTime=to_date('"+bean.getGrantTime()+"','YYYY-MM-DD') , total="+bean.getTotal()+
			" where id="+bean.getId();
		Connection conn = null;
		PreparedStatement stm = null;
		try {
			conn = DBConnection.getConnection();
			stm = conn.prepareStatement(sql);
			ret = stm.executeUpdate();
		} catch (SQLException e) {
			try {
				conn.rollback();
			} catch (SQLException e1) {
				// TODO 自动生成 catch 块
				e1.printStackTrace();
			}
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}finally{
			try {
				stm.close();
				conn.close();
			} catch (SQLException e1) {
				// TODO 自动生成 catch 块
				e1.printStackTrace();
			}
		}
		return ret;
		
	}
	
	//根据id删除表里的数据
	
	public int delete(String id){
		int ret = 0;
		String sql =" delete from stipend where id="+id;
		Connection conn = null;
		PreparedStatement stm = null;
		try {
			conn = DBConnection.getConnection();
			stm = conn.prepareStatement(sql);
			ret = stm.executeUpdate();
		} catch (SQLException e) {
			try {
				conn.rollback();
			} catch (SQLException e1) {
				// TODO 自动生成 catch 块
				e1.printStackTrace();
			}
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}finally{
			try {
				stm.close();
				conn.close();
			} catch (SQLException e1) {
				// TODO 自动生成 catch 块
				e1.printStackTrace();
			}
		}
		return ret;
	}
	

}