jdbc实现对数据库的查询

package csdn1;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

//操作数据库--查询
public class jdbc2 {

	public static void main(String[] args) {
		String sql = "select * from user;";// 已提前向表插入过数据
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		String url = "jdbc:mysql://localhost:3306/mydbs2";
		try (Connection connection = DriverManager.getConnection(url, "root", "root");
				Statement statement = connection.createStatement();) {
			// 查询语句有两种执行方式
			// 1.executeQuery直接返回查询的结果集
			ResultSet set1 = statement.executeQuery(sql);

			while (set1.next()) {//next()方法判断有无数据
				String id = set1.getString(1);
				String name = set1.getString(2);
				String password = set1.getString(3);
				System.out.println(id + "\t" + name + "\t" + password);
			}
			System.out.println("-----------------------");

			// 2.execute需要通过getResultSet把结果集取出来
			boolean bool = statement.execute(sql);
			ResultSet set2 = statement.getResultSet();

			while (set2.next()) {
				String id = set2.getString("id");// 通过第几列或列的属性名获取值
				String name = set2.getString("name");
				String password = set2.getString("password");
				System.out.println(id + "\t" + name + "\t" + password);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}
//流关闭：ResultSet可以不用关、关闭Statement时会自动关闭它
//当然，这里使用try-with-resource，流会都会自动关闭。