java.util.PropertyResourceBundle@4554617c
package com.yanyu; import java.sql.*; import java.util.ResourceBundle; public class JDBCTest01 { public static void main(String[] args) throws SQLException { // 获取属性配置文件 ResourceBundle bundle = ResourceBundle.getBundle("com/yanyu/db");//ctrl alt v // System.out.println(bundle);// CTRL SHIFT F10 java.util.PropertyResourceBundle@4554617c String driver = bundle.getString("driver"); String url = bundle.getString("url"); String user = bundle.getString("user"); String password = bundle.getString("password"); // Connection con = null; Statement st = null; ResultSet rs = null; // 注册驱动 try { Class.forName(driver);// alt enter con = DriverManager.getConnection(url, user, password); // System.out.println(connection); con.setAutoCommit(false); st = con.createStatement(); // 关闭十五自动提交 String sql = "insert into t_user values(2,'yanyu2')"; boolean execute = st.execute(sql); // System.out.println(execute?"数据插入成功":"数据插入失败"); con.commit(); } catch (ClassNotFoundException e) { throw new RuntimeException(e); } catch (SQLException e) { if (con != null) { con.rollback(); } throw new RuntimeException(e); } finally { if (rs != null) { rs.close(); } if (st != null) { st.close(); } if (con != null) { con.close(); } } // 异常 方法未重写(继承 父类 接口) } }
driver=com.mysql.cj.jdbc.Driver url=jdbc:mysql://127.0.0.1:3306/soft03 #https:www.baidu.com user=root password=root
还没有评论,来说两句吧...