电脑上安装了mysql,创建了数据库student和表student,也导入了jdbc驱动,不知道是哪里出了问题,希望大神帮忙看下
连接数据库的代码如下:
package Database;
import java.io.IOException;
import java.io.InputStream;
import java.sql.*;
import javax.swing.JOptionPane;
public class database {
static Connection conn =null;
private static String username = "root";
private static String password = "1234";
private static String driverClassName = "com.mysql.jdbc.Driver";
private static String url =
"jdbc:mysql://localhost:3306/student?useUnicode=true&characterEncoding = UTF-8";
public Connection getConnection(){
try{
Class.forName(driverClassName);
conn = DriverManager.getConnection(url,username,password);
}
catch(Exception e){
e.printStackTrace();
}
return conn;
}
public void closeConnection() throws SQLException{
if(conn!= null){
try{
conn.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
}
}