departmentdao.java

学生信息管理系统

package dao;
import java.sql.*;
import conn.ConnectDB;
import java.util.ArrayList;

import vo.*;
public class DepartmentDAO 
{
	public DepartmentDAO()
	{
		
	}
	 public ArrayList getDepartments()
    {
    	ArrayList departments = null;
    	try
    	{
    		departments = new ArrayList();
    		String sql="select * from department";
    		Connection conn = ConnectDB.getConnection();
			Statement stmt =conn.createStatement();
			ResultSet rs=stmt.executeQuery(sql);	
    		while(rs.next())
    		{
    			DepartmentVO departmentvo=new DepartmentVO();
    			departmentvo.setDepartmentId(rs.getString("department_id").trim());
    			departmentvo.setDepartmentName(rs.getString("departmentName").trim());
    			departments.add(departmentvo);
    		}
    		conn.close();
    	}
    
	    catch(Exception e)
		{
			e.printStackTrace();
		}
		return 	departments;
   } 
}