coursenamedao.java

学生信息管理系统

package dao;
import java.util.*;
import conn.ConnectDB;
import java.sql.*;
import vo.CourseNameVO;
public class CourseNameDAO
{
	public CourseNameDAO()
	{
		
	}
	public ArrayList getCourseNames()
	{
		ArrayList coursenames=null;
		
		try
		{
			coursenames=new ArrayList();
			Connection conn=ConnectDB.getConnection();
			Statement stat=conn.createStatement();
			ResultSet rs=stat.executeQuery("select * from course ");
			while(rs.next())
			{
				CourseNameVO coursenamevo=new CourseNameVO();
				coursenamevo.setCourseId(rs.getString("course_id").trim());
				coursenamevo.setCourseName(rs.getString("coursename").trim());
				coursenames.add(coursenamevo);
			}
			conn.close();
		}
		 catch(Exception e)
		{
			e.printStackTrace();
		}
		return coursenames;
	}
}