之前数据库安装完jdbc后还是链接不了,后来查问才发现问题
一,Diver 没写对
String URL="jdbc:mysql://localhost:3306/dateesserverTimezone=UTC&useUnicode=true&characterEncoding=utf-8";
//① 3306后面只有一个斜杠/
//② / 后面放你已经创建了的数据库
二,DriverManager.getConnection(URL, username, passwold)要用try包起来或用throws扔出去
不然运行不了。
import java.sql.*;
public class msqltext {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Class.forName("com.mysql.cj.jdbc.Driver");
String URL="jdbc:mysql://localhost:3306/datees?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8";
//3306/后面,?之前的部分是你要调用的数据库名。
try {
String username = "root";
String passwold = "abc123456";//你都数据库密码。
//这两步可以不写,直接写DriverManager.getConnection(URL,"root","abc123456")也行。
Connection connection = DriverManager.getConnection(URL, username, passwold);
Statement statement = connection.createStatement();
String mysql = "SELECT * FROM `dayo3`";
ResultSet resultSet = statement.executeQuery(mysql);
while (resultSet.next()) {
System.out.println("id" + resultSet.getObject("id"));
System.out.println("name" + resultSet.getObject("name"));
}
resultSet.close();
statement.close();
connection.close();
}catch (Exception e){
System.out.println("13134214");
}
}
}