利用Java编码实现对oracle数据库的操作

最新推荐文章于 2021-01-20 00:08:56 发布

weixin_34102807

最新推荐文章于 2021-01-20 00:08:56 发布

阅读量109

点赞数

文章标签：数据库 java python

原文链接：https://my.oschina.net/u/1989867/blog/694010

版权

2019独角兽企业重金招聘Python工程师标准>>>

private static String driver = "oracle.jdbc.driver.OracleDriver"; // 驱动URL jdbc:oracle:thin:@127.0.0.1:1521:monitor private static String url = "jdbc:oracle:thin:@127.0.0.1:1521:studb"; // 登陆数据库的用户名 private static String uname = "system"; // 登陆数据的密码 private static String upassword = "student";

public static void testOracleConn() { try { // 获得DriverManager Class.forName(driver); // 创建连接 Connection conn = DriverManager .getConnection(url, uname, upassword); // 测试驱动是否获得 System.out.println(conn);

// sql语句 // String sql = "select id from student where name = ?"; // Statement // PreparedStatement pstmt = conn.prepareStatement(sql); // 注入参数 // pstmt.setString(1, "zzw");

// sql语句 String sql = "select * from student"; // Statement Statement stmt = conn.createStatement(); // ResultSet rs = stmt.executeQuery(sql); // 循环输出rs while (rs.next()) {System.out.println("姓名：" + rs.getString(2) + " 年龄：" + rs.getInt(3)); } } catch (ClassNotFoundException | SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } }

转载于:https://my.oschina.net/u/1989867/blog/694010