基本上MySQL的配置 就完成了,接下来就是写java程序连接mysql了
1 创建一个工程,在里面 build path 找到Add External JARs:是添加当前项目之外的外部目录中的jar文件。 再找到mysql 和java 相关的jar文件(例如:C:\Program Files (x86)\MySQL\Connector J 8.0)
2写一个关于java 连接MySQL的程序
例子代码package connection;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class mycon {
///jdbc 的驱动名和url
private static String url = "jdbc:mysql://localhost:3306/数据库名?serverTimezone=GMT&useSSL=false";
private static String userName = "root";
private static String password = "***";
public static void main(String[] args) throws SQLException {
mycon mysql= new mycon();
Connection con = mysql.getConnection();
if(con==null){
System.out.println("与mysql数据库连接失败!");
}else{
System.out.println("与mysql数据库连接成功!");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from mytable");
while (rs.next()){
String id =rs.getString("id");
String name=rs.getString("user");
System.out.println(id+name);
}
}
}
private Connection getConnection() {
// TODO Auto-generated met
1 创建一个工程,在里面 build path 找到Add External JARs:是添加当前项目之外的外部目录中的jar文件。 再找到mysql 和java 相关的jar文件(例如:C:\Program Files (x86)\MySQL\Connector J 8.0)
2写一个关于java 连接MySQL的程序
例子代码package connection;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class mycon {
///jdbc 的驱动名和url
private static String url = "jdbc:mysql://localhost:3306/数据库名?serverTimezone=GMT&useSSL=false";
private static String userName = "root";
private static String password = "***";
public static void main(String[] args) throws SQLException {
mycon mysql= new mycon();
Connection con = mysql.getConnection();
if(con==null){
System.out.println("与mysql数据库连接失败!");
}else{
System.out.println("与mysql数据库连接成功!");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from mytable");
while (rs.next()){
String id =rs.getString("id");
String name=rs.getString("user");
System.out.println(id+name);
}
}
}
private Connection getConnection() {
// TODO Auto-generated met