java 连不上数据库 mysql
import java.sql.*;
public class ConnectToMySQL {
public static Connection getConnection() throws SQLException,
java.lang.ClassNotFoundException{
String url = "jdbc:mysql://localhost:3306/bookstore?";
Class.forName("com.mysql.jdbc.Driver");
String userName = "root";
String password = "123456";
Connection con = DriverManager.getConnection(url, userName, password);
return con;
}
public static void main(String[] args){
try {
Connection con = getConnection();
Statement sql=con.createStatement();
/*
*/
String query = "select UserName,PassWord,Names from shop_user";
ResultSet result = sql.executeQuery(query);
// System.out.println("bookadmin表数据如下:");
// System.out.println("----------------------");
//System.out.println("用户名" + "\t" + "密码" + "\t\t" + "姓名");
// System.out.println("----------------------");
String UserName;
String PassWord;
String Names;
// int Id=0;
while (result.next()) {
// Id++;
UserName = result.getString(" UserName");
PassWord = result.getString(" PassWord");
Names = result.getString(" Names");
System.out.println( result.getString(" UserName"));
System.out.println(result.getString(" PassWord"));
System.out.println(result.getString(" Names"));
}
sql.close();
con.close();
}catch (java.lang.ClassNotFoundException e) {
System.err.println("ClassNotFoundException:" + e.getMessage());
}
catch (SQLException ex) {
System.err.println("SQLException:" + ex.getMessage());
}
}
}