jdbc
我这里是mysql8 所以大家导包的时候要注意
导包
代码
private static Connection conn = null; public static String user; public static String password; public static String url; public static Connection getConnection() { try { // 1、加载数据库驱动类 Class.forName("com.mysql.cj.jdbc.Driver"); user = ""; password = ""; // 这里要设置时区 serverTimezone=Asia/Shanghai url = "jdbc:mysql://localhost:3306/day23?serverTimezone=Asia/Shanghai"; // 给获取Connection的对象赋值 conn = DriverManager.getConnection(url, user, password); } catch (Exception e) { e.printStackTrace(); } return conn; }
下面的俩个导包注意
jdbc数据库连接池
//1.导入jar包 //2.定义配置文件 //3.加载配置文件 Properties pro = new Properties(); InputStream is = DruidDemo.class.getClassLoader().getResourceAsStream("druid.properties"); pro.load(is); //4.获取连接池对象 DataSource ds = DruidDataSourceFactory.createDataSource(pro); //5.获取连接 Connection conn = ds.getConnection(); System.out.println(conn);
配置文件
jdbcTemplate
** * Druid连接池的工具类 */ public class JDBCUtils { //1.定义成员变量 DataSource private static DataSource ds ; static{ try { //1.加载配置文件 Properties pro = new Properties(); pro.load(JDBCUtils.class.getClassLoader().getResourceAsStream("druid.properties")); //2.获取DataSource ds = DruidDataSourceFactory.createDataSource(pro); } catch (IOException e) { e.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } } /** * 获取连接 */ public static Connection getConnection() throws SQLException { return ds.getConnection(); } /** * 释放资源 */ public static void close(Statement stmt,Connection conn){ /* if(stmt != null){ try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } } if(conn != null){ try { conn.close();//归还连接 } catch (SQLException e) { e.printStackTrace(); } }*/ close(null,stmt,conn); }