JDBC数据库连接

JDBC数据库连接

package util;

import java.sql.*;
public class DBUtil {
    public static Connection getConnection(){
        Connection con = null;
        String jb = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://localhost:33066/test?useUnicode=true&characterEncoding=utf-8";
        String user = "root";
        String password = "password";
        try {
            Class.forName(jb);
            con = (Connection) DriverManager.getConnection(url,user,password);
           /* System.out.println("连接成功！");
            String sql = "select * from user";
            Statement statement = con.createStatement();
            ResultSet resultSet = statement.executeQuery(sql);
            while(resultSet.next()){
                System.out.println(resultSet.getString("username"));
                System.out.println(resultSet.getString("password"));
            }*/
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
        return con;
    }
    public static void close(Connection con){
        if(con!=null){
            try {
                con.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
    }

    public static void main(String[] args) {
        Connection connection = DBUtil.getConnection();
        System.out.println(connection);
    }
}