mysql 数据库dbhelp_Java运行后说是没找到数据库“shopping”，要怎么才能将数据库“shopping”导入MySQL呢？谢谢大家！...

packageutil;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.SQLException;publicclassDBhelp{privatestaticfinalStringdriver="com.mysql.jdbc.Driver";pr...

package util;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class DBhelp {

private static final String driver="com.mysql.jdbc.Driver";

private static final String url="jdbc:mysql://localhost:3306/shopping?useUnicode=true&characterEncoding=UTF-8";

private static final String username="root";

private static final String password="botao521";

private static Connection conn=null;

static {

try {

Class.forName(driver);

} catch (Exception e) {

e.printStackTrace();

}

}

public static Connection getConnection() throws SQLException{

if(conn==null){

conn=DriverManager.getConnection(url, username, password);

return conn;

}

return conn;

}

public static void main(String[] args) {

try{

Connection conn=DBhelp.getConnection();

if(conn!=null){

System.out.println("normal");

}

else{

System.out.println("not normal");

}

}

catch(Exception ex){

ex.printStackTrace();

}

}

}

展开