1、安装MySql软件:
下载地址:https://dev.mysql.com/downloads/installer/
2、安装过后找出JDBC连接驱动jar文件:mysql-connector-java-xxx.jar, 复制到Java工程中;
我的本地路径:C:\Program Files (x86)\MySQL\Connector J 8.0
3、Java JDBC连接MySql数据库代码如下:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
public class ConnectMySql {
public static void main(String[] args) {
connect();
}
private static void connect() {
// DriverManager:驱动管理器类,getConnection(url,数据库登录名,密码):获得连接的方法
// jdbc:mysql://localhost:3306/mydb的格式由来
// jdbc:mysql://本机地址:端口号/数据库名称
try {
// 1.加载数据访问驱动
Class.forName("com.mysql.cj.jdbc.Driver");
// 2.连接到数据"库"上去 下面语句中mydb是库名 ****是你的密码
String ip = "localhost";
String port = "3306";
String databaseName = "mydb";
String param = "?useSSL=false&useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8";
String url = "jdbc:mysql://" + ip + ":" + port + "/" + databaseName + param;
String user = "root";
String pwd = "123456";
Connection conn = DriverManager.getConnection(url, user, pwd);
// 3.构建SQL命令
System.out.println(conn.nativeSQL("select * from xs;"));
Statement statement = conn.createStatement();
String sql = conn.nativeSQL("select * from xs;");
ResultSet result = statement.executeQuery(sql);
System.out.println("\n----------------------------------------");
while(result.next()) {
ResultSetMetaData metaData = result.getMetaData();
int size = metaData.getColumnCount();
for(int i = 1 ; i <= size ; i++) {
System.out.print(metaData.getColumnName(i) + " = " + result.getObject(i) + ", ");
}
System.out.println("\n----------------------------------------");
}
statement.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
4、启动数据库,运行Java代码,完事,齐活;
Demo下载地址: