JDBC直连——基础

最新推荐文章于 2023-03-30 23:31:00 发布

Terrysha

最新推荐文章于 2023-03-30 23:31:00 发布

阅读量529

点赞数

文章标签： jdbc exception string hashmap oracle url

本文链接：https://blog.csdn.net/Terrysha/article/details/3081272

版权

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.HashMap;
import java.util.Map;

public class Queryone {
// ORACLE驱动程序
    private static final String DRIVER = "oracle.jdbc.driver.OracleDriver";
    //ORACLE连接用URL
    private static final String URL = "jdbc:oracle:thin:@192.168.1.100:1521:oracle";
    //用户名
    private static final String USER = "goweb";
    //密码
    private static final String PASSWORD = "goweb";
    //数据库连接
    private static Connection conn = null;
    //SQL语句对象
    private static Statement stmt = null;
    public static void clobInsert( ) throws Exception {

    Class.forName(DRIVER);
    conn = DriverManager.getConnection(URL,USER,PASSWORD);
    stmt = conn.createStatement();
    ResultSet rs = stmt.executeQuery("select * from yonghubiao");
    while (rs.next()) {
    Map map = new HashMap();
    map.put("yonghubiao_id", rs.getString("yonghubiao_id"));
  map.put("mima", rs.getString("mima"));
System.out.println(map.get("yongbiao_id")+","+map.get("mima"));
    }
    }
    public static void main(String args[]) throws Exception
    {
    clobInsert();
    }
}