ordinaryhighselectdao.java

培训时做的学生管理系统.基于J2SE平台开发

package cn.com.dao.chivementdao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

import cn.com.util.DBConnection;
import cn.com.util.DBSql;
import cn.com.vo.chivementvo.ChivementVo;

public class OrdinaryHighSelectDao {
	private Connection conn = DBConnection.getConnectionOracle();

	private ChivementVo examVo;

	public OrdinaryHighSelectDao() {

	}

	public OrdinaryHighSelectDao(ChivementVo examVo) {
		this.examVo = examVo;
	}
	
	public Object[][] select011 () {
		Object date[][] = null;
		int max = 0;
		int i = 0;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			ps = conn.prepareStatement(DBSql.SELECT_OR_011);
			ps.setInt(1, examVo.getG_id());
			ps.setInt(2, examVo.getS_id());
			rs = ps.executeQuery();
			max = rs.getMetaData().getColumnCount();
			int k = 0;
			Vector vo = new Vector();
			while (rs.next()) {
				for (int j = 0; j < max; j++) {
					vo.add(rs.getObject(j + 1));
				}
				i++;
			}
			if(vo.size()>0){
				date = new Object[vo.size()/max][max];
				for(i=0;i<vo.size()/max;i++){
					for (int j = 0; j < max; j++) {
						date[i][j]=vo.get(k);
						k++;
					}
				}
			}
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return date;
	}
	
	
	
	public Object[][] select101() {
		Object date[][] = null;
		int max = 0;
		int i = 0;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			ps = conn.prepareStatement(DBSql.SELECT_OR_101);
			ps.setString(1, examVo.getS_name());
			ps.setString(2, "%" + examVo.getS_name() + "%");
			ps.setString(3, "%" + examVo.getS_name());
			ps.setString(4, examVo.getS_name() + "%");
			ps.setInt(5, examVo.getS_id());
			rs = ps.executeQuery();
			max = rs.getMetaData().getColumnCount();
			int k = 0;
			Vector vo = new Vector();
			while (rs.next()) {
				for (int j = 0; j < max; j++) {
					vo.add(rs.getObject(j + 1));
				}
				i++;
			}
			if(vo.size()>0){
				date = new Object[vo.size()/max][max];
				for(i=0;i<vo.size()/max;i++){
					for (int j = 0; j < max; j++) {
						date[i][j]=vo.get(k);
						k++;
					}
				}
			}
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return date;
	}
	
	public Object[][] select110() {
		Object date[][] = null;
		int max = 0;
		int i = 0;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			ps = conn.prepareStatement(DBSql.SELECT_OR_110);
			ps.setString(1, examVo.getS_name());
			ps.setString(2, "%" + examVo.getS_name() + "%");
			ps.setString(3, "%" + examVo.getS_name());
			ps.setString(4, examVo.getS_name() + "%");
			ps.setInt(5, examVo.getG_id());
			rs = ps.executeQuery();
			max = rs.getMetaData().getColumnCount();
			int k = 0;
			Vector vo = new Vector();
			while (rs.next()) {
				for (int j = 0; j < max; j++) {
					vo.add(rs.getObject(j + 1));
				}
				i++;
			}
			if(vo.size()>0){
				date = new Object[vo.size()/max][max];
				for(i=0;i<vo.size()/max;i++){
					for (int j = 0; j < max; j++) {
						date[i][j]=vo.get(k);
						k++;
					}
				}
			}
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return date;
	}
	public Object[][] select111() {
		Object date[][] = null;
		int max = 0;
		int i = 0;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			ps = conn.prepareStatement(DBSql.SELECT_OR_111);
			ps.setString(1, examVo.getS_name());
			ps.setString(2, "%" + examVo.getS_name() + "%");
			ps.setString(3, "%" + examVo.getS_name());
			ps.setString(4, examVo.getS_name() + "%");
			ps.setInt(5, examVo.getG_id());
			ps.setInt(6, examVo.getS_id());
			rs = ps.executeQuery();
			max = rs.getMetaData().getColumnCount();
			int k = 0;
			Vector vo = new Vector();
			while (rs.next()) {
				for (int j = 0; j < max; j++) {
					vo.add(rs.getObject(j + 1));
				}
				i++;
			}
			if(vo.size()>0){
				date = new Object[vo.size()/max][max];
				for(i=0;i<vo.size()/max;i++){
					for (int j = 0; j < max; j++) {
						date[i][j]=vo.get(k);
						k++;
					}
				}
			}
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return date;
	}
	
	
	

}