educatedao.java

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

/*
 * 创建日期 2007-5-1
 *
 * 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.educate.educateBean;
import oracle.DBConnection;
/**
 * @author Administrator
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class educateDao {
	
	//根据提供的数据向educate表了添加数据
	
	public int educateAdd(educateBean bean){
		
		int ret = 0;
		String sql =" insert into educate values(ed_seq.nextval,?,?," +
				"to_date(?,'YYYY-MM-DD'),to_date(?,'YYYY-MM-DD'),?,?,?,sysdate,0,'null','null')";
		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.getPurpose());
			stm.setString(3,bean.getBeginTime());
			stm.setString(4,bean.getEndTime());
			stm.setString(5,bean.getDatum());
			stm.setString(6,bean.getTeacher());
			stm.setString(7,bean.getStudent());
			stm.execute();
			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 educateLook(){
		List list = new ArrayList();
		String sql =" select * from educate where educate=0";
		Connection conn = null;
		PreparedStatement stm = null;
		ResultSet rs = null;
		try {
			conn =DBConnection.getConnection();
			stm = conn.prepareStatement(sql);
			rs = stm.executeQuery();
			while(rs.next()){
				educateBean bean = new educateBean();
				bean.setId(rs.getString("id"));
				bean.setName(rs.getString("name"));
				bean.setTeacher(rs.getString("teacher"));
				bean.setStudent(rs.getString("student"));
				bean.setBeginTime(rs.getString("beginTime"));
				bean.setEndTime(rs.getString("endTime"));
			    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;
	}
	
//	根据id查询所有信息
	
	public educateBean SelectAll(educateBean bean){
		
		String sql =" select * from educate 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.setId(rs.getString("id"));
				bean.setName(rs.getString("name"));
				bean.setTeacher(rs.getString("teacher"));
				bean.setStudent(rs.getString("student"));
				bean.setBeginTime(rs.getString("beginTime"));
				bean.setEndTime(rs.getString("endTime"));
				bean.setPurpose(rs.getString("purpose"));
				bean.setDatum(rs.getString("datum"));
			}
		} 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修改表educate
	
	public int educateUpdate(educateBean bean){
		int ret = 0;
		String sql =" update educate set educate=1 ,effect='"+bean.getEffect()+"', summanrize='" +
				bean.getSummanrize()+"' 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;
	}
	
	//查询已经培训完的所有信息
	
	public List educateEnd(){
		List list = new ArrayList();
		String sql =" select * from educate where educate=1";
		Connection conn = null;
		PreparedStatement stm = null;
		ResultSet rs = null;
		try {
			conn =DBConnection.getConnection();
			stm = conn.prepareStatement(sql);
			rs = stm.executeQuery();
			while(rs.next()){
				educateBean bean = new educateBean();
				bean.setId(rs.getString("id"));
				bean.setName(rs.getString("name"));
				bean.setTeacher(rs.getString("teacher"));
				bean.setStudent(rs.getString("student"));
				bean.setBeginTime(rs.getString("beginTime"));
				bean.setEndTime(rs.getString("endTime"));
			    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 int educateDrop(educateBean bean){
		int ret =0;
		String sql =" delete from educate 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;
	}
	
	//查询培训完成详细资料
	
	public educateBean All(educateBean bean){
		String sql =" select * from educate 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.setId(rs.getString("id"));
				bean.setName(rs.getString("name"));
				bean.setTeacher(rs.getString("teacher"));
				bean.setStudent(rs.getString("student"));
				bean.setBeginTime(rs.getString("beginTime"));
				bean.setEndTime(rs.getString("endTime"));
				bean.setPurpose(rs.getString("purpose"));
				bean.setDatum(rs.getString("datum"));
				bean.setEffect(rs.getString("effect"));
				bean.setSummanrize(rs.getString("summanrize"));
				
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}finally{
			try {
				rs.close();
				stm.close();
				conn.close();
			} catch (SQLException e1) {
				// TODO 自动生成 catch 块
				e1.printStackTrace();
			}
		}
		return bean;
		
	}
}