java连接MySql数据库(jdbc5.0)
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
//数据库连接工具类
public class DBUtil {
private static String username="root";//用户名
private static String pwd="123456";//密码
private static String driverClass="com.mysql.jdbc.Driver";//驱动类名 MySQL8.0以上的格式为“com.mysql.cj.jdbc.Diver” 版本查看方法:select version
private static String url="jdbc:mysql://localhost:3306/DatabaseName?characterEncoding=utf-8";//连接地址
public static Connection getConn() throws ClassNotFoundException, SQLException {
Class.forName(driverClass);//加载驱动//throws ClassNotFoundException, SQLException 后面报错alt+enter自动生成解决方案,不用敲
Connection conn= DriverManager.getConnection(url,username,pwd);
return conn;
}
}
jdbc5.0下载地址:http://static.runoob.com/download/mysql-connector-java-5.1.39-bin.jar
jdbc8.0下载地址:https://static.runoob.com/download/mysql-connector-java-8.0.16.jar