基本通用的使用jdbc文件java代码连接数据库

最新推荐文章于 2024-09-12 21:06:53 发布

jmz19910110

最新推荐文章于 2024-09-12 21:06:53 发布

阅读量211

点赞数

分类专栏： java 数据库

本文链接：https://blog.csdn.net/jmz19910110/article/details/93757140

版权

数据库同时被 2 个专栏收录

1 篇文章 0 订阅

订阅专栏

java

0 篇文章 0 订阅

订阅专栏

import java.sql.*;

public class test_dm {

    public static void getResult(ResultSet rs) throws Exception
    {
        while (rs.next()){
            String name = rs.getString(1);
            String type = rs.getString(2);
            System.out.println("Name: " + name + " Type: " + type);

        }
    }

    static String url = "jdbc:dm://192.168.7.43:5236";
    static String username = "SYSDBA";
    static String password = "sysdba";
    public static void runSelectPrepare() throws Exception
    {
        Connection con = DriverManager.getConnection(url,username,password);
        Statement stmt = con.createStatement();
        String query0 = "select * from SYSDBA.t1";

        con.commit();

        ResultSet rs0 = stmt.executeQuery(query0);

        getResult(rs0);


    }

    public static void main(String... args) throws Exception {
        try{

            runSelectPrepare();
            //runInsertPrepare();
            //runUpdatePrepare();
            //runNormalUpdateStmt();

        }catch (Exception e) {

            e.printStackTrace();

        }
    }
}