institutiondao.java

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

/*
 * 创建日期 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.institution.institutionBean;
import oracle.DBConnection;
;
/**
 * @author Administrator
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class institutionDao {
	//向institution表里调价信息
	
	public int instAdd(institutionBean bean){
		int ret = 0;
		String sql =" insert into institution values(ins_seq.nextval,?,?,?,sysdate)";
		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.getReason());
			stm.setString(3,bean.getExplain());
			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(false);
				stm.close();
				conn.close();
			} catch (SQLException e1) {
				// TODO 自动生成 catch 块
				e1.printStackTrace();
			}
		}
		return ret ;
		
	}
	
	//查询所有信息
	
	public List selectAll(){
		List list = new ArrayList();
		String sql =" select * from institution ";
		Connection conn = null;
		PreparedStatement stm = null;
		ResultSet rs = null;
		try {
			conn = DBConnection.getConnection();
			stm = conn.prepareStatement(sql);
			rs = stm.executeQuery();
			while(rs.next()){
				institutionBean bean = new institutionBean();
				bean.setId(rs.getString("id"));
				bean.setName(rs.getString("name"));
				bean.setReason(rs.getString("reason"));
				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 institutionBean select(institutionBean bean){
		String sql =" select * from institution 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.setReason(rs.getString("reason"));
				bean.setExplain(rs.getString("explain"));
			}
		} 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 drop(institutionBean bean){
		int ret = 0;
		String sql =" delete from institution 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;
	}

}