cstudao.java

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

package value;
import java.sql.*;
import java.util.ArrayList;

/**
 * <p>标题:CStuDAO</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 CStuDAO {
	public Connection conn = null;
	public Statement stmt = null;
	public ResultSet rs = null;
	
	public CStuDAO(){
		conn = CConnFactory.newInstance(1);
	}
	/**
	 * 
	 * <p>描述:生成新学号方法</p>
	 *
	 * @return
	 */
	public String newStuID(){
		String stuID = new String();
		try
		{
			CallableStatement cstmt = conn.prepareCall("{call pro_getSid(?)}");
			cstmt.registerOutParameter(1,Types.CHAR);
			cstmt.execute();
			stuID = cstmt.getString(1);	
		}
		catch (SQLException e)
		{
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		return stuID;
	}
	
	/**
	 * 
	 * <p>描述:按sql语句查询学生信息方法</p>
	 *
	 * @param sql
	 * @return
	 */
	public ArrayList executeQuery(String sql){
		//ArrayList stuList = new ArrayList();
	    ArrayList stuList = null;
		rs = null;
		try
		{
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
			if(rs.next()){
		    stuList = new ArrayList();
		
			    do{
					CStudents stu = new CStudents();
					stu.setStrStuId(rs.getString(1));
					stu.setStrStuName(rs.getString(2));
					stu.setStrSex(rs.getString(3));
					stu.setStrClsID(rs.getString(4));
					stuList.add(stu);
			    }while(rs.next());
			}
		}
		catch (SQLException e)
		{
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		return stuList;
	}
	/**
	 * 
	 * <p>描述:添加学生信息操作方法</p>
	 *
	 * @param stu
	 * @return
	 */
    public boolean excuteInsert(CStudents stu){
        boolean b = true;
        try {
            CallableStatement cstmt = conn.prepareCall("{call pro_insertStu(?,?,?)}");
            cstmt.setString(1,stu.getStrStuName());
            cstmt.setString(2,stu.getStrSex());
            cstmt.setString(3,stu.getStrClsID());
            b = cstmt.execute();
        } catch (SQLException e) {
            // TODO 自动生成 catch 块
            e.printStackTrace();
        }
        return b;
    }
    
    /**
     * 
     * <p>描述:更新学生信息方法</p>
     *
     * @param sql
     * @return
     */
    public int executeUpdate(String sql){
        int i = 0;
        try {
            if (conn != null)
            {
              stmt = conn.createStatement();
              i = stmt.executeUpdate(sql);
              stmt.close();
            }
        } catch (SQLException e) {
            // TODO 自动生成 catch 块
            e.printStackTrace();
        }
        return i;
    }
	
}