java连接数据库

参考资料：
https://blog.csdn.net/caihuangshi/article/details/51265324?spm=1001.2101.3001.6650.3&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-3-51265324-blog-81036309.pc_relevant_aa&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-3-51265324-blog-81036309.pc_relevant_aa&utm_relevant_index=6

https://www.bookstack.cn/read/getting_started_with_postgresql/spilt.2.pgsql.md

导入包：

        
            org.postgresql
            postgresql
            42.2.18
        

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

public class ConnectSQL {
    public static void  main (String[] args) {
        System.out.println("connect postgreSQL: ");
        Connection c;
        Statement statement;
        try {
            Class.forName("org.postgresql.Driver");
            c = DriverManager.getConnection("jdbc:postgresql://localhost:5432/postgres","postgres","1");
            c.setAutoCommit(false);
            System.out.println("open database success");
            statement = c.createStatement();
            String sql = "CREATE TABLE STUDENTS " +
                    "(ID TEXT PRIMARY KEY NOT NULL, " +
                    " NAME  TEXT NOT NULL)";
            statement.executeUpdate(sql);
            System.out.println("table create success");
            statement.close();
            c.commit();
            c.close();

        }catch (Exception e){
            System.out.println(e);
        }
    }
}

aop实现记录操作日志

参考资料：
https://search.gitee.com/?q=%E8%AE%B0%E5%BD%95%E6%93%8D%E4%BD%9C%E6%97%A5%E5%BF%97%E3%80%81%E5%BC%82%E5%B8%B8%E6%97%A5%E5%BF%97&skin=rec&type=repository&pageno=2

https://blog.csdn.net/u010634066/article/details/102995586

https://blog.csdn.net/qq_42570879/article/details/108830089?spm=1001.2101.3001.6650.1&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-1-108830089-blog-98612532.pc_relevant_default&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7Edefault-1-108830089-blog-98612532.pc_relevant_default&utm_relevant_index=2

https://blog.csdn.net/weixin_43888891/article/details/122116930?utm_medium=distribute.pc_relevant.none-task-blog-2_defaultbaidujs_title~default-0-122116930-blog-114319643.pc_relevant_default&spm=1001.2101.3001.4242.1&utm_relevant_index=3