teachernamedao.java

学生信息管理系统

package dao;
import java.sql.*;
import java.util.*;
import conn.ConnectDB;
import vo.TeacherNameVO;
public class TeacherNameDAO 
{
	public TeacherNameDAO()
	{
		
	}
	public ArrayList getTeacherNames()
	{
		ResultSet rs=null;
		ArrayList teachers=null;
		try
		{
			teachers=new ArrayList();
			
			Connection conn=ConnectDB.getConnection();
			Statement stat=conn.createStatement();
			rs=stat.executeQuery("select * from teacherInformation ");
			while(rs.next())
			{
				TeacherNameVO teachername=new TeacherNameVO();
				
				teachername.setTeacherId(rs.getString("teacher_id").trim());
				teachername.setTeacherName(rs.getString("name").trim());
				teachers.add(teachername);
				
			}
			conn.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return teachers;
	}
}