classinfordao.java

功能是公安和学校的管理系统,用struts+hibernate+spring等匡架组成,在eclepse就能编译

package com.comingnet.bean;

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

import com.db.DBUtils;

public class ClassInforDAO {
	private ClassInfor classInfor = null ;
	public ClassInfor getClassInfor() {
		return classInfor;
	}
	public void setClassInfor(ClassInfor classInfor) {
		this.classInfor = classInfor;
	}
	public ArrayList<ClassInfor> qryClassInfor(int stuId,int xxbh){
		Connection conn = null ;
		PreparedStatement stmt = null;
		ResultSet rs = null;
		String sqlStr = "";
		ArrayList<ClassInfor> classInforList = new ArrayList<ClassInfor>();
		
		String bjmc = "" ;
		int bjrs =0 ;
		String bjjs ="" ;
		String bjbzr ="" ;
		String bjrxnf = "";
		classInfor = new ClassInfor() ; 
		
		sqlStr = "select a.bjmc,a.bjrs,a.bjbzr,a.bjjs,a.bjrxnf from m_class a, m_student b " ;
		sqlStr = sqlStr+" where b.xsbjbh = a.bjid and b.xsid =? and b.xxbh=? ";
		System.out.println(sqlStr) ;
		try {
			conn = DBUtils.getConnection() ;
			stmt = conn.prepareStatement(sqlStr);
			stmt.setInt(1, stuId);
			stmt.setInt(2,xxbh) ;
			rs = stmt.executeQuery();
			
			while(rs.next()){
				
				bjmc = rs.getString("bjmc") ;
				bjrs = rs.getInt("bjrs") ;
				bjjs = rs.getString("bjjs") ;
				bjbzr = rs.getString("bjbzr") ;
				bjrxnf = String.valueOf(rs.getDate("bjrxnf")) ;
				
				
				//设置classinfor
				classInfor.setBjmc(bjmc) ;
				classInfor.setBjrs(bjrs) ;
				classInfor.setBjjs(bjjs) ;
				classInfor.setBjbzr(bjbzr) ;
				classInfor.setBjrxnf(bjrxnf) ;
				
				classInforList.add(classInfor);	
				}
			
			DBUtils.closeResultSet(rs);
			DBUtils.closeStatement(stmt);
		} catch (Exception e) {
			System.out.println("classInforDao.qryClassInfor--->" + e);
		} finally {
			DBUtils.closeResultSet(rs);
			DBUtils.closeStatement(stmt);
			DBUtils.closeConnection(conn);
		}
		return classInforList;
	}
}