测试查询方法

import java.sql.ResultSet;
import java.sql.SQLException;
import com.yxq.dao.*;
public class test_main {

	/**
	 * @param args
	 */
	public static void main(String[] args) throws Exception {
		// TODO Auto-generated method stub
		String sql1="select * from tb_type order by type_sign";
		String temp="";
		DB yuan=new DB();
		yuan.doPstm(sql1,null);
		try {
			ResultSet rs=yuan.getRs();
			if(rs!=null){
				while(rs.next()){					
					Integer sign=Integer.valueOf(rs.getInt("type_sign"));
					String intro=rs.getString("type_intro");
					temp=new String(intro.getBytes("iso-8859-1"),"gbk");
					System.out.println(sign+" "+temp);					
				}
				rs.close();
			}
		} catch (SQLException e) {			
			System.out.println("OpGetListBox()方法查询失败！");			
			e.printStackTrace();
		}finally{
			yuan.closed();			
		}

	}

}

相关代码： http://blog.csdn.net/weiyanghuadi/article/details/8913089