cclsdao.java

java版的windows界面的学生管理系统

package value;

import java.sql.*;
import java.util.*;

/**
 * <p>标题:CClsDAO</p>
 * <p>描述:班级信息处理类</p>
 * <p>作者@author:李涛</p>
 * <p>公司:com.thinkbank.04024</p>
 * <p>版权:Copyrigth (c) 2005 </p>
 * <p>编写日期:2005-10-10</p>
 * <p>版本号@version 1.0.06.01 
 */
public class CClsDAO {
    private Connection conn = null;
    private Statement stmt = null;
    private ResultSet rs = null;
    
    public CClsDAO(){
        conn = CConnFactory.newInstance(1);
    }
    /**
     * 
     * <p>描述:更新班级信息方法</p>
     *
     * @param cls
     */
    public void executeUpdate(CClasses cls){
        try {
            PreparedStatement pstmt = conn.prepareStatement("update T_class "+
            											"set cClassName=?,dBeginDate=?,dEndDate=? where cClassID=?");
            pstmt.setString(1,cls.getStrClsType());
            pstmt.setString(2,cls.getStrBeginData());
            pstmt.setString(3,cls.getStrEndData());
            pstmt.setString(4,cls.getStrClsId());
            pstmt.execute();
        } catch (SQLException e) {
            // TODO 自动生成 catch 块
            e.printStackTrace();
        }
        
        
    }
    /**
     * 
     * <p>描述:添加班级信息方法</p>
     *
     * @param cls
     * @return
     */
    public boolean excuteInsert(CClasses cls){
        boolean b = true;
        try {
            CallableStatement cstmt = conn.prepareCall("{call pro_insertClass(?,?,?)}");
            cstmt.setString(1,cls.getStrClsType());
            cstmt.setString(2,cls.getStrBeginData());
            cstmt.setString(3,cls.getStrEndData());
            b = cstmt.execute();
            return b;
        } catch (SQLException e) {
            // TODO 自动生成 catch 块
            e.printStackTrace();
            return b;
        }
    }
    /**
     * 
     * <p>描述:删除班级信息方法</p>
     *
     * @param strClsID
     * @return
     */
    public int executeDelete(String strClsID){
        int i = 0;
        try {
            CallableStatement cstmt = conn.prepareCall("{call prc_delClass(?,?)}");
            cstmt.setString(1,strClsID);
            cstmt.registerOutParameter(2,Types.INTEGER);
            cstmt.execute();
            i = cstmt.getInt(2);
        } catch (SQLException e) {
            // TODO 自动生成 catch 块
            e.printStackTrace();
        }
        return i;
    }
    
   
    /**
     * 
     * <p>描述:按班级号查找班级方法</p>
     *
     * @param strClsID
     * @return
     */
    public ArrayList executeQueryID(String strClsID){
        ArrayList clsList = null;
        String sql = "select *  from T_class where cClassId='" + strClsID + "'";
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            if (rs.next()){
                clsList = new ArrayList();
	            do{
	                CClasses cls = new CClasses();
		            cls.setStrClsId(rs.getString(1));
		            cls.setStrClsType(rs.getString(2));
		            cls.setStrBeginData(rs.getString(3));
		            cls.setStrEndData(rs.getString(4));
		            clsList.add(cls);
	            }while(rs.next());
            }
            return clsList;
        } catch (SQLException e) {
            // TODO 自动生成 catch 块
            e.printStackTrace();
            return clsList;
        }
    }
    
    /**
     * 
     * <p>描述:查询所有班级信息方法</p>
     *
     * @return
     */
    public ArrayList executeQuery(){
        ArrayList clsList = new ArrayList();
        String sql = "select cClassId,cClassName,CONVERT(char(10),dBeginDate,111),CONVERT(char(10),dEndDate,111) from T_class";
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            while(rs.next()){
                CClasses cls = new CClasses();
                cls.setStrClsId(rs.getString(1));
                cls.setStrClsType(rs.getString(2));
                cls.setStrBeginData(rs.getString(3));
                cls.setStrEndData(rs.getString(4));
                clsList.add(cls);
            }
         
        } catch (SQLException e) {
            // TODO 自动生成 catch 块
            e.printStackTrace();
        }
        return clsList;
    }
    /**
     * 
     * <p>描述:生成新班级号方法</p>
     *
     * @return
     */
    public String newClsID(){
		String str = null;
    	try
		{
			CallableStatement cstmt = conn.prepareCall("{ call pro_getClassid(?) } ");
			cstmt.registerOutParameter(1,Types.CHAR);
			cstmt.execute();
			str = cstmt.getString(1);
            return str;
		}
		catch (SQLException e)
		{
			// TODO 自动生成 catch 块
			e.printStackTrace();
			return  str;
		}
    }
}