数据库连接代码

package exportexcel;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class ExportExcel {

 /**
  * @param args
  */
 public static void main(String[] args) {
  try {
   Class.forName("com.kingbase.Driver");
   Connection con=DriverManager.getConnection("jdbc:kingbase://192.16.3.40:55555/HISDB", "HISDB", "HISDB");
   String sql="select * from hisdb.idp_pdwsb_new.业务_概况_配电变压器 where 汇总月份='2015-03' ";
   PreparedStatement ps=con.prepareStatement(sql);
   ResultSet rs=ps.executeQuery();
   while(rs.next()){
    System.out.println(rs.getString(13));
   }
   if(rs!=null){
    rs.close();
   }
   if(ps!=null){
    ps.close();
   }
   if(con!=null){
    con.close(); 
   }
  } catch (Exception e) {
   e.printStackTrace();
  }
 }

}