该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
package windowbuilder;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Driverdemo {
public static final String DBDRIVER="com.mysql.jdbc.Driver";
public static final String DBURL="jdbc:mysql://localhost:3306/student";
public static final String DBUSER="root";
public static final String DBPASS="root";
public static void main(String[] args) {
Connection conn=null;
try {
Class.forName(DBDRIVER);
}catch(ClassNotFoundException e) {
e.printStackTrace();
}
try {
conn=DriverManager.getConnection(DBURL, DBUSER, DBPASS);
}catch(SQLException e) {
e.printStackTrace();
}
System.out.println(conn);
try {
conn.close();
}catch(SQLException e) {
e.printStackTrace();
}
}
}
控制台:
java.sql.SQLException: null, message from server: "Host 'DESKTOP-DP6VCNF' is not allowed to connect to this MySQL server"
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1095)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2031)
at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:718)
at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at windowbuilder.Driverdemo.main(Driverdemo.java:21)
Exception in thread "main" java.lang.NullPointerException
at windowbuilder.Driverdemo.main(Driverdemo.java:27)
null