package swing;

import com.bwm.string.Str;
import com.zh.conpool.*;
import java.sql.Connection;
import java.sql.ResultSet;


public class Arraysql{
	
	private ResultSet rs=null;
	private String sql="";
	
	Condata con=new Condata();
	Connection conn=null;
	Str str=new Str();
	
	public ResultSet toRs(){
		sql="SELECT * FROM tb_th_types";
		try{
			con.getConnection();
			rs=con.executeQuery(sql);
		}catch(Exception eee){
			System.out.println(eee.getMessage()+"3333");
		}
		return rs;
	}

	public ResultSet toRst(){
		sql="SELECT * FROM tb_th_unit";
		try{
			con.getConnection();
			rs=con.executeQuery(sql);
		}catch(Exception eee){
			System.out.println(eee.getMessage()+"3333");
		}
		return rs;
	}
	public ResultSet toRstb(){
		sql="SELECT * FROM tb_th_boss";
		try{
			con.getConnection();
			rs=con.executeQuery(sql);
		}catch(Exception eee){
			System.out.println(eee.getMessage()+"3333");
		}
		return rs;
	}
	
	public void close(){
		try{
			conn=null;
		}catch(Exception e){
			System.out.print("f1");
		}
		try{
			con.close();
			con=null;
		}catch(Exception ee){
			System.out.print("f");
		}finally{
			conn=null;
			con=null;
		}
	}
}