java 读取mysql中的表

java 读取mysql中的表

导入 mysql-connector-java 5.1.38 的依赖包

public class MyJavaSQL {
	 public static void main(String[] args) throws Exception{
        Class.forName("com.mysql.jdbc.Driver");
        Connection connection = DriverManager.getConnection("jdbc:mysql://192.168.56.100:3306/mysql", "root", "ok");
        PreparedStatement ps = connection.prepareStatement("select name from help_keyword");
        ResultSet rs = ps.executeQuery();
        while(rs.next()){
            System.out.println(rs.getString("name"));
        }
        rs.close();
        ps.close();
        connection.close();
    }
}