java查询高斯数据库表某个字段值

代码：

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

public class test {

    public static void main(String[] args) throws Exception {
        getFiberInfo("","","");

    }
    
    public static void getConnection(String databaseName, String IP, String port) {
        String driver = "gauss.jdbc.ZenithDriver";
        String url = "jdbc:zentieh:@" + IP + ":" + port;
        System.out.println(" url:"+ url);
        
        try {
//                    加载数据库驱动
            Class.forName(driver).newInstance();                        
        }catch(Exception e) {
//            System.out.println("[ErrorType]"+ AutoTestError.PUB_CONNECT_EXCEPTION.getCode() + ":" + AutoTestError.PUB_CONNECT_EXCEPTION.getMsg() + "-" + AutoTestError.FRAMEWORK_DBCONNECT_FAIL.getCode() + ":" + AutoTestError.FRAMEWORK_DBCONNECT_FAIL.getMsg(),true);
            System.out.println("##异常信息" + e.getMessage());    
            e.printStackTrace();
            return;
        }
        
        try{
            Connection conn = DriverManager.getConnection(url,databaseName,"Changeme_123");
            System.out.println("##zenith数据库连接成功！");
            
        }catch (Exception e) {
            // TODO: handle exception
//            System.out.println("[ErrorType]"+ AutoTestError.PUB_CONNECT_EXCEPTION.getCode() + ":" + AutoTestError.PUB_CONNECT_EXCEPTION.getMsg() + "-" + AutoTestError.FRAMEWORK_DBCONNECT_FAIL.getCode() + ":" + AutoTestError.FRAMEWORK_DBCONNECT_FAIL.getMsg(),true);
            System.out.println("##异常信息" + e.getMessage());    
        }
    }
    
        public static List getFiberInfo(String pmiDBName,String pmiIP,String pmiPort) throws SQLException {
//            连接存量数据库
            getConnection(pmiDBName, pmiIP, pmiPort);
//            查表tbl_fiber_info中SRCTP字段的值
            String tblfiberinfo_SQL = "select FIBERID,FIBERNAME from TBL_FIBER_INFO";
            List tblfiberinfo = getconnectionBysql_two(tblfiberinfo_SQL);
            System.out.println("tblfiberinfo= "+ tblfiberinfo);
            return tblfiberinfo;
        }
        //执行查询语句
        public static List getconnectionBysql_two(String sql) throws SQLException {
               
//            public static void SelectTest() {
                Statement stmt = null;   
                Connection conn = null;
                ArrayList list = new ArrayList();
                try {
                    stmt = conn.createStatement();            
                    //执行SELECT语句。
                    ResultSet rs = stmt.executeQuery(sql);           
                     while (rs.next()) {
                      String ss = rs.getString(1);
                      String tt =  rs.getString(2); 
                      String result = ss + "_" + tt;
                      list.add(result);
//                     如果仅仅打印
                      System.out.println("id:" + rs.getString(1) + ", c_name:" + rs.getString(2));
                    }

                    stmt.close();
                } catch (SQLException e) {         
                   if (stmt != null) {                
                   try {
                          stmt.close();
                        } catch (SQLException e1) {
                            e1.printStackTrace();
                        }
                    }
                    e.printStackTrace();
                }
                return list;
        }
        
}