创建Maven连接数据库

 注意：

    右下角会有导入的提示，必须把ifxjdbc.jar放入pjdbc目录下后，再点击导入。

        选择ifxjdbc.jar，右键，add libaries XXX 

      在src/main/java目录下创建包com.pp，在包下面创建类

package com.pp;
import com.pp.util.JdbcUtil;

import java.sql.*;

public class SelJson {
    public static void main( String[] args)
            throws SQLException, ClassNotFoundException {

        try {
            Connection conn=JdbcUtil.getCconnection();
            //查询tabjson数据表里的数据
            String sqls="select * from tabjson where col1=? ";
            PreparedStatement stmt = conn.prepareStatement(sqls);
            stmt.setInt(1,100);
            ResultSet rs1 = stmt.executeQuery();

            while ( rs1.next() ) {
                //输出查询结果
                int col1=rs1.getInt(1);
                String col2=rs1.getString(2);
                System.out.println(col1+"t"+col2);
            }
            JdbcUtil.CloseResource(conn,stmt,rs1);
        } catch( Exception e) {
            e.printStackTrace();
        }

        return;
    }
}

========================使用db.properties====================================

       resources  =>  new  =>  file

driver=com.gbasedbt.jdbc.Driver
url=jdbc:gbasedbt-sqli://192.168.69.219:9022/ttdb:GbaseDBTSERVER=gbase01;NEWCODESET=GB18030,GB18030-2000,5488;DB_LOCALE=zh_cn.GB18030-2000;CLIENT_LOCALE=zh_cn.GB18030-2000;
user=gbasedbt
password=XXXX

package com.pp.util;

import java.sql.*;
import java.util.ResourceBundle;

public class JdbcUtil {
     private static  String driver ;
     private static  String url ;
     private static  String user ;
     private static  String password ;

    static {
        try {
            ResourceBundle bundle = ResourceBundle.getBundle("db");
            driver=bundle.getString("driver");
            url=bundle.getString("url");
            user=bundle.getString("user");
            password=bundle.getString("password");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static Connection getCconnection(){
        try {
            Class.forName(driver);
            Connection connection=DriverManager.getConnection(url,user,password);
            return connection;
        } catch (Exception e) {
            e.printStackTrace();
        }
        return null;
    }

    public static void CloseConnection(Connection connection){
        if(connection!=null){
            try {
                connection.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            connection=null;
        }

    }
    public static void CloseStatement(Statement statement){
        if(statement!=null){
            try {
                statement.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            statement=null;
        }

    }
    public static void CloseResult(ResultSet resultSet){
        if(resultSet!=null){
            try {
                resultSet.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            resultSet=null;
        }

    }
    public static void CloseResource(Connection connection,Statement statement,ResultSet resultSet){
        CloseResult(resultSet);
        CloseStatement(statement);
        CloseConnection(connection);
    }
}