title.java

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

package crqs.dboperation;

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

import crqs.infobeans.TitleInfo;

public class Title implements Serializable {

	public static synchronized ArrayList getTitles()throws SQLException{
		String sql="Select * from Title";
		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();
			TitleInfo ti=null;
			do{
				ti=new TitleInfo();
				ti.setTitle(rs.getString("TName"));
				ti.setTitleID(rs.getInt("TitleNO"));
				al.add(ti);
			}while(rs.next());
			return al;		
		}finally{
			conn.close();
			stmt.close();
		}
	}
	
}