JavaWeb基础（1）—— 使用 JDBC 连接 MySQL

package db;import java.sql.*;public class DBUtil {    private static final String URL="jdbc:mysql://localhost:3306/jdbc_learn?useUnicode=true&characterEncoding=utf-8";    private static final String USER="root";    private static final String PASSWORD="roottest";    private static Connection conn=null;    static {        try {            // 加载驱动程序            Class.forName("com.mysql.jdbc.Driver");            // 获得数据库的连接            conn=DriverManager.getConnection(URL, USER, PASSWORD);        } catch (ClassNotFoundException e) {            e.printStackTrace();        } catch (SQLException e) {            e.printStackTrace();        }    }    public static Connection getConnection(){        return conn;    }    public static void main(String[] args) throws SQLException {        Statement stmt  = conn.createStatement();        ResultSet rs = stmt.executeQuery("SELECT id, user_name FROM imooc_goddess");        while (rs.next()){            System.out.println(rs.getInt("id") + rs.getString("user_name"));        }    }}