import java.sql.*;
public class selectStu {
static Connection con;
static PreparedStatement sql; //执行sql语句接口
static ResultSet res; //用于临时存放查询结果集接口
public Connection getConnection() {
try {
Class.forName("com.mysql.jdbc.Driver"); //初始化给定的类
//指定连接数据库地址和相关参数
con = DriverManager.getConnection("jdbc:mysql://172.00.00.00:3306/databaseN阿么?useUnicode=true&characterEncoding=utf-8&useSSL=false","user","password");
} catch (Exception e) {
e.printStackTrace();
}
return con;
}
public static void main(String[] args) {
InsertStu c = new InsertStu();
con = c.getConnection();
try {
//执行sql语句方法,返回PreparedStatement对象
sql = con.prepareStatement("SELECT * FROM wxwork_city WHERE wxwork_city.PROVINCE_CODE IN(SELECT wxwork_province.PROVINCE_CODE FROM wxwork_province WHERE wxwork_province.PROVINCE_NAME = '江苏省')");
System.out.println("数据查询成功。");
res =sql.executeQuery(); //返回的结果集
//循环获取到查询结果集的第三例数据
while(res.next())
{
String bookname=res.getString(3);
System.out.println(bookname);
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}