groups.java

来自「改代码是采用JSP实现的在线办公自动化管理系统」· Java 代码 · 共 35 行

package swing;

import java.sql.*;
import com.zh.conpool.Condata;

public class Groups{

	private Connection conn=null;
	private ResultSet rs=null;
	private Condata con=new Condata();
	private String sql="SELECT Name FROM tb_th_plan GROUP BY Name";
	
	public  ResultSet rbRs(){
		try{
			con.getConnection();
			rs=con.executeQuery(sql);
		}catch(Exception e){
			System.out.println(e.getStackTrace());
		}
		return rs;
	}
	public void close(){
		try{
				rs.close();
			}catch(Exception e){
			}try{
				conn.close();
			}catch(Exception ee){
				
			}finally{
				con.close();
			}	
	}
}