studentdb.java

来自「是老师给我们的一个JAVA的学生管理系统」· Java 代码 · 共 39 行

package hit;
import java.util.*;
import java.sql.*;
public class StudentDB
{
	ArrayList list = new ArrayList();
	public void setList(String sql)
	{
		list.clear();
		hit.DBTools db = new hit.DBTools();
		ResultSet rs = db.executeQuery(sql);
		try
		{
			while(rs.next())
			{
				Student s = new Student();
				String sid = rs.getString(1);
				String sname = rs.getString(2);
				int age = rs.getInt(3);
				String sex = rs.getString(4);
				String banji = rs.getString(5);
				s.setSid(sid);
				s.setSname(sname);
				s.setAge(age);
				s.setSex(sex);
				s.setBanji(banji);
				list.add(s);
			}
			rs.close();
		}
		catch(Exception e)
		{
		}
	}
	public ArrayList getList()
	{
		return this.list;
	}
}