花了一天的时间,终于弄明白了。
从网上抄了一段代码也不行:
import java.sql.*;
public class TestMySql {
public static void main(String[] args) {
// TODO Auto-generated method stub
Statement st = null;
Connection con = null;
ResultSet rs=null;
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
System.out.print("驱动错误");
}
try {
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mldn?useUnicode=true&characterEncoding=GBK","root","root");
String sql="select * from user";
st = con.createStatement();
rs=st.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getString("userpass"));
}
} catch (SQLException e) {
System.out.print("错误");
e.printStackTrace();
} }
}
刚开始的时候,以为是驱动,后来加mysql-connector-java-3.11-bin.jar加到环境变量里,也是不行
最后把myeclipse里的jdbc:mysql://hostname:3306/mysql 改成 127.0.0.1 就行了。