package cn.tedu; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class Test02 { public static void main(String[] args) throws Exception { //查询 年龄 在25 - 30 之间的用户 显示id 名字 年龄 //1.注册驱动 Class.forName("com.mysql.jdbc.Driver"); //2.获取链接 String url="jdbc:mysql://localhost:3306/db10?characterEncoding=utf8&useSSL=false"; String name="root"; String ma="root"; Connection conn = DriverManager.getConnection(url, name, ma); //3.获取传输器 Statement stat = conn.createStatement(); //4.执行SQL String sql = "select id,name,age from stu where age >= 25 and age <= 30"; ResultSet rs = stat.executeQuery(sql); //5.遍历结果集 while (rs.next()){ int id = rs.getInt("id"); String name1 = rs.getString("name"); int age = rs.getInt("age"); System.out.println(id+name1+age); } //6.关闭资源 rs.close(); stat.close(); conn.close(); } }
05-19
1471