section.java

基于java的医院门诊管理系统

package crqs.dboperation;

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

import crqs.infobeans.SectionInfo;
import crqs.util.Page;

public class Section {
//	public String getAbbreviation(int secID) {
//
//	}

	public static synchronized ArrayList getSections() throws SQLException {
		String sql = "Select SName,SectionNO from Section";
		Connection conn = null;
		Statement stmt = null;
		try {
			conn = DBConnection.getConnection();
			stmt = conn.createStatement();
			ResultSet rs = null;
			rs = stmt.executeQuery(sql);
			rs.next();
			ArrayList al = new ArrayList();
			SectionInfo si = null;
			do {
				si = new SectionInfo();
				si.setSectionName(rs.getString("SName"));
				si.setSectionID(rs.getInt("SectionNO"));
				al.add(si);
			} while (rs.next());
			return al;
		} finally {
			conn.close();
			stmt.close();
		}
	}
}