jobsutil.java

J2EE连接Oracle数据库的操作

package com.hygj.util;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

import com.hygj.bean.JobsBean;

public class JobsUtil {
	
	private Connection conn = null;
	private Statement st = null;
	private ResultSet rs = null;
	private ArrayList list = null;
	private JobsBean bean = null;
	
	/**
	 * 全部查询
	 */
	public ArrayList chaxun(){
		list = new ArrayList();
		conn = com.hygj.ConnDB.ConnDB.getConn();
		try {
			st = conn.createStatement();
			rs = st.executeQuery("select * from hr.jobs");
			while(rs.next()){
				bean = new JobsBean(rs.getString(1),rs.getString(2),rs.getInt(3),rs.getInt(4));
				list.add(bean);
			}			
		} catch (Exception e) {
			// TODO: handle exception
		} finally{
			try {
				if (rs != null) {
					rs.close();
				}
				if(st!= null){
					st.close();
				}
				if(conn != null){
					conn.close();
				}
			} catch (Exception e) {
				// TODO: handle exception
			}			
			
		}	
		return list;
	}
}