dbstudent.java

jsp 应用开发技术光盘 是《jsp应用开发技术》这本书的源代码

package ch14.datasource;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Date;

public class DBStudent {
	private String stuID;
	private String name;
	private String address;
	private Date birthdate;
	
	// 获得所有student表的记录返回为一个Vector
	public static Collection getAllStudent() {
		Collection stuVector = new ArrayList();

		Connection conn = null;
		Statement stmt = null;
		
		try {
			conn = SqlTestDS.getConnection();
			if (conn != null) {
				stmt = conn.createStatement();
				ResultSet rs = stmt.executeQuery("SELECT * FROM student");
				while (rs.next()) {
					DBStudent stu = new DBStudent();
					stu.setStuID(rs.getString("stu_id"));
					stu.setName(rs.getString("name"));
					stu.setAddress(rs.getString("address"));
					stu.setBirthdate(rs.getDate("birthdate"));
						
					stuVector.add(stu);				
				}
				
			}
			
		} catch(SQLException e) {
			e.printStackTrace();
		}
		
		return stuVector;
	}

	public String getAddress() {
		return address;
	}

	public Date getBirthdate() {
		return birthdate;
	}

	public String getName() {
		return name;
	}

	public String getStuID() {
		return stuID;
	}

	public void setAddress(String address) {
		this.address = address;
	}

	public void setBirthdate(Date birthday) {
		this.birthdate = birthday;
	}

	public void setName(String name) {
		this.name = name;
	}

	public void setStuID(String stuID) {
		this.stuID = stuID;
	}
}