java使用main 方法进行调用数据库操作(mysql ，oracle)

最新推荐文章于 2024-04-24 15:25:50 发布

qq_39838930

最新推荐文章于 2024-04-24 15:25:50 发布

阅读量2.4k

点赞数 1

文章标签： oracle 数据库 java

本文链接：https://blog.csdn.net/qq_39838930/article/details/126904851

版权

本文是适用jdbctemplate 进行操作数据库，方便自己进行一些其他的相关操作
连接mysql 依赖

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>5.3.9</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.30</version>
</dependency>

Mysql main方法相关代码

private static JdbcTemplate jdbcTemplate;
    static {
        String driver = "com.mysql.cj.jdbc.Driver";//mysql驱动
        String url ="jdbc:mysql://127.0.0.1:3306/local";//连接地址
        String user ="ctuser";//用户
        String password ="workout";//密码

        DriverManagerDataSource dataSource=new DriverManagerDataSource();
        dataSource.setUrl(url);
        dataSource.setDriverClassName(driver);
        dataSource.setUsername(user);
        dataSource.setPassword(password);

        jdbcTemplate=new JdbcTemplate(dataSource);
    }

    public static void main(String[] args) {
        String sql ="select * from  student;";//student 数据库表明
        List<Map<String, Object>> maps = jdbcTemplate.queryForList(sql);
        System.out.println(maps.size());
    }

连接oracle 相关依赖

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>5.3.9</version>
</dependency>
<dependency>
   <groupId>com.oracle.database.jdbc</groupId>
    <artifactId>ojdbc8</artifactId>
    <version>21.7.0.0</version>
</dependency>

Mysql main方法相关代码

private static JdbcTemplate jdbcTemplate;
    static {
        String driver = "oracle.jdbc.driver.OracleDriver";
        String url ="jdbc:oracle:thin:@IP:PORT:orcl11g";//连接地址
        String user ="root";//用户
        String password ="root";//密码

        DriverManagerDataSource dataSource=new DriverManagerDataSource();
        dataSource.setUrl(url);
        dataSource.setDriverClassName(driver);
        dataSource.setUsername(user);
        dataSource.setPassword(password);
        dataSource.setSchema("RYCLOUD");


        jdbcTemplate=new JdbcTemplate(dataSource);
    }

    public static void main(String[] args) {
        String sql ="SELECT\n" +
                "\t*\n" +
                "FROM\n" +
                "\tDM_CHINALIFE_PE_ACT A\n" +
                "WHERE\n" +
                "\tA .DELETE_FLAG = 0\n" +
                "AND A .BIZ_DT >= TO_DATE (\n" +
                "\tCONCAT ('2022-09-01', ' 00:00:00'),\n" +
                "\t'yyyy-mm-dd hh24:mi:ss'\n" +
                ")\n" +
                "AND A .BIZ_DT <= TO_DATE (\n" +
                "\tCONCAT ('2022-09-30', ' 00:00:00'),\n" +
                "\t'yyyy-mm-dd hh24:mi:ss'\n" +
                ")";// sql

        List<Map<String, Object>> maps = jdbcTemplate.queryForList(sql);
        System.out.println(maps.size());
    }