Java(61):Java访问mysql/postgres数据库示例(连接调试用)

Java访问mysql/postgres数据库示例(为了封装做连接调试用)

Java对于jdbc对数据库的封装，封装方法参考：

1、Java(32):Java对于jdbc对数据库的封装(Bean)https://blog.csdn.net/fen_fen/article/details/120518266

2、Java(31):Java对于jdbc对数据库的封装[2]https://blog.csdn.net/fen_fen/article/details/120469074

3、Java(23):Java对于jdbc对数据库的封装[1]

https://blog.csdn.net/fen_fen/article/details/120379997

一、Java访问mysql数据库示例

1、Maven引用(或直接导入jar包)

       <dependency>

            <groupId>mysql</groupId>

            <artifactId>mysql-connector-java</artifactId>

            <version>5.1.48</version>

        </dependency>

2、连接mysql数据库配置

static final String JDBC_DRIVER="com.mysql.jdbc.Driver";

    static final String  DB_URL="jdbc:mysql://10.1.1.143:3306/aoe_java?useSSL=false&useUnicode=yes&characterEncoding=UTF-8";

    static final String USER = "root";

    static final String PASSWORD = "123456";

3、连接mysql数据库示例

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

public class mysqlSqlTest {

    static final String JDBC_DRIVER="com.mysql.jdbc.Driver";
    static final String  DB_URL="jdbc:mysql://10.1.1.143:3306/aoe_java?useSSL=false&useUnicode=yes&characterEncoding=UTF-8";

    static final String USER = "root";
    static final String PASSWORD = "123456";

    public static void main(String[] args){

        Connection conn = null;
        Statement stmt = null;

        try{
            //注册 JDBC 驱动
            Class.forName(JDBC_DRIVER);
            //打开链接
            System.out.println("Connect DB...");
            conn= DriverManager.getConnection(DB_URL,USER,PASSWORD);

            //执行查询
            System.out.println("实例化Statement对象...");
            stmt = conn.createStatement();
            String sql;
            sql = "SELECT * FROM aoedata";
            ResultSet rs = stmt.executeQuery(sql);

            //展开结果集数据库
            System.out.println("aoeId"+"\t"+"aoeAes"+"\t"+"aoeSm4");
            while (rs.next()){
                System.out.print(rs.getInt(1) + "\t");
                System.out.print(rs.getString(2) + "\t");
                System.out.print(rs.getString(3) + "\t");
                System.out.println();
            }
            rs.close();
            stmt.close();
            conn.close();

        }
        catch(Exception e){
            e.printStackTrace();
        }

    }
}

4、执行结果

 二、Java访问postgres数据库示例

1、Maven引用(或直接导入jar包)

2、连接postgres数据库配置

    static final String JDBC_DRIVER="org.postgresql.Driver";

 static final String  DB_URL="jdbc:postgresql://10.1.1.112:5432/aoe_java?currentSchema=public";

    static final String USER = "postgres";

    static final String PASSWORD = "postgres";

3、连接postgres数据库示例

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

public class postgresSqlTest {

    static final String JDBC_DRIVER="org.postgresql.Driver";
    static final String  DB_URL="jdbc:postgresql://10.1.1.112:5432/aoe_java?currentSchema=public";

    static final String USER = "postgres";
    static final String PASSWORD = "postgres";

    public static void main(String[] args){

        Connection conn = null;
        Statement stmt = null;

        try{
            //注册 JDBC 驱动
            Class.forName(JDBC_DRIVER);
            //打开链接
            System.out.println("Connect DB...");
            conn= DriverManager.getConnection(DB_URL,USER,PASSWORD);

            //执行查询
            System.out.println("实例化Statement对象...");
            stmt = conn.createStatement();
            String sql;
            sql = "SELECT * FROM aoedata";
            ResultSet rs = stmt.executeQuery(sql);

            //展开结果集数据库
            System.out.println("aoeId"+"\t"+"aoeAes"+"\t"+"aoeSm4");
            while (rs.next()){
                System.out.print(rs.getInt(1) + "\t");
                System.out.print(rs.getString(2) + "\t");
                System.out.print(rs.getString(3) + "\t");
                System.out.println();
            }
            rs.close();
            stmt.close();
            conn.close();

        }
        catch(Exception e){
            e.printStackTrace();
        }

    }
}

4、执行结果