stucourseinfordao.java

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

package com.comingnet.bean;

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

import com.db.DBUtils;

public class StuCourseInforDAO {
	private StuCourseInfor stuCourseInfor = null  ;

	public StuCourseInfor getStuCourseInfor() {
		return stuCourseInfor;
	}

	public void setStuCourseInfor(StuCourseInfor stuCourseInfor) {
		this.stuCourseInfor = stuCourseInfor;
	}
	public ArrayList<StuCourseInfor> qryStuCourseInfor(int teacherId,int xxbh){
		ArrayList<StuCourseInfor> stuCourseInforList = new ArrayList<StuCourseInfor>() ;
		Connection conn = null ;
		PreparedStatement stmt = null;
		ResultSet rs = null;
		String sqlStr ;
		
		int bjid = 0 ;
		String bjmc ="" ;
		String bjjs = "" ;
		int bjrs = 0 ;
		String bjbzr =""  ;
		String kcmc="" ;
		
		
		sqlStr = "select a.bjid,a.bjmc,a.bjjs,a.bjrs,a.bjbzr,b.kcmc from m_class a, m_class_cur b where a.bjid= b.bjbh and jsbh = ? and b.xxbh = ?";
		System.out.println(sqlStr) ;
		try{
			conn = DBUtils.getConnection() ;
			stmt = conn.prepareStatement(sqlStr) ;
			stmt.setInt(1,teacherId) ;
			stmt.setInt(2,xxbh);
			rs = stmt.executeQuery() ;
			while(rs.next()){
								
				bjid =rs.getInt("bjid") ;
				bjmc = rs.getString("bjmc") ;
				bjjs = rs.getString("bjjs") ;
				bjrs = rs.getInt("bjrs") ; 
				bjbzr = rs.getString("bjbzr") ;
				kcmc = rs.getString("kcmc") ;
				
				stuCourseInfor = new StuCourseInfor() ;
				//setter
				stuCourseInfor.setBjid(bjid);
				stuCourseInfor.setBjmc(bjmc);
				stuCourseInfor.setBjjs(bjjs);
				stuCourseInfor.setBjrs(bjrs);
				stuCourseInfor.setBjbzr(bjbzr);
				stuCourseInfor.setKcmc(kcmc);
				
				stuCourseInforList.add(stuCourseInfor) ;
			}
			DBUtils.closeResultSet(rs) ;
			DBUtils.closeStatement(stmt) ;
			
		}catch(Exception e){
			System.out.println("stuCourseInforDao.qryStuCourseInfor-->"+e) ;
		}finally{
			DBUtils.closeResultSet(rs) ;
			DBUtils.closeStatement(stmt) ;
			DBUtils.closeConnection(conn) ;
		}
		
		return stuCourseInforList ;
	}
}