JDBC快速入门
package com.company;
import java.sql.*;
import java.util.ConcurrentModificationException;
public class JDBCTest06 {
public static void main(String[] args) {
Statement stmt=null;
Connection conn=null;
try {
Driver driver = new com.mysql.jdbc.Driver();
DriverManager.registerDriver(driver);
String url = "jdbc:mysql://127.0.0.1:3306/bjpowernode?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=conver" +
"tToNull&allowMultiQueries=true&serverTimezone=Asia/Shanghai";
String user = "root";
String password = "123456";
conn = DriverManager.getConnection(url, user, password);
System.out.println("数据可的连接对象" + conn);
stmt= conn.createStatement();
String sql="SELECT * FROM bjpowernode";
int count= stmt.executeUpdate(sql);
System.out.println(count);
} catch (SQLException throwables) {
throwables.printStackTrace();
}finally {
if(stmt!=null){
try {
stmt.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
if(conn!=null){
try {
conn.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}
}
}
绑定属性文件
package com.company;
import java.sql.*;
import java.util.ResourceBundle;
public class JDBCTest04 {
public static void main(String[] args) {
Statement stmt=null;
Connection conn=null;
try {
ResourceBundle bundle=ResourceBundle.getBundle("jdbc");
String driver=bundle.getString("driver");
String url=bundle.getString("url");
String user=bundle.getString("user");
String password=bundle.getString("password");
Class.forName(driver);
conn = DriverManager.getConnection(url, user, password);
System.out.println("数据可的连接对象" + conn);
stmt= conn.createStatement();
String sql="SELECT * FROM bjpowernode";
int count= stmt.executeUpdate(sql);
System.out.println(count);
} catch (SQLException | ClassNotFoundException throwables) {
throwables.printStackTrace();
}finally {
if(stmt!=null){
try {
stmt.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
if(conn!=null){
try {
conn.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}
}
}