jdbc连接数据库

主要步骤：
1.加载数据库驱动
2.获取数据库连接
3.创建查询对象
4.执行sql

import java.sql.Connection;
import java.sql.DriverManager;

public class DBUtil {

private static final String URI = "jdbc:mysql://192.168.1.101:3306/jdbc_demo?"  
        + "user=root&password=roo123t&useUnicode=true&characterEncoding=UTF-8";  

private static final String DRIVER = "com.mysql.jdbc.Driver";  

public static Connection connectDB() throws Exception {  
    //1、加载数据库驱动  
    Class.forName(DRIVER);  
    //2、获取数据库连接  
    Connection conn = DriverManager.getConnection(URI);  

    return conn;  
}  

}

Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);