1 package com.java1234.jdbc.chap02.sec04; 2 3 import java.sql.Connection; 4 import java.sql.DriverManager; 5 import java.sql.SQLException; 6 7 8 public class Demo1 { 9 //数据库地址 10 private static String dbUrl="jdbc:mysql://localhost:3306/db_book"; 11 private static String dbUrl1="jdbc:mysql://localhost:3306/db_book?characterEncoding=utf8&useSSL=false"; 12 //用户名 13 private static String dbUserName="root"; 14 //密码 15 private static String dbPassword="shendianxin123"; 16 //驱动名称 17 private static String jdbcName = "com.mysql.jdbc.Driver"; 18 19 public static void main(String[] args) { 20 try { 21 Class.forName(jdbcName); 22 System.out.println("加载驱动成功!"); 23 } catch (ClassNotFoundException e) { 24 // TODO Auto-generated catch block 25 e.printStackTrace(); 26 System.out.println("加载驱动失败!"); 27 } 28 29 Connection con = null; 30 try { 31 //获取数据库连接 32 con = DriverManager.getConnection(dbUrl1, dbUserName, dbPassword); 33 System.out.println("获取数据库连接成功!"); 34 System.out.println("进行数据库操作!"); 35 } catch (SQLException e) { 36 // TODO Auto-generated catch block 37 e.printStackTrace(); 38 System.out.println("获取数据库连接失败!"); 39 }finally{ 40 try { 41 con.close(); 42 } catch (SQLException e) { 43 // TODO Auto-generated catch block 44 e.printStackTrace(); 45 } 46 } 47 48 } 49 }