Mysql_JDBC查询操作

1、ResultSet接口

对数据库的查询操作，一般需要返回查询结果，在程序中，JDBC为我们提供了ResultSet接口来处理查询结果集。

ResultSet executeQuery(String sql) throws SQl Exceptions;

示例代码：

import java.sql.DriverManager;
import java.sql.ResultSet;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;

public class Jdbc_querydemo {
	public final static String URL = "jdbc:mysql://localhost:3306/test";
	public final static String USERNAME = "root";
	public final static String PASSWORD = "root";
	public final static String DRIVER = "com.mysql.jdbc.Driver";

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		query();
		System.out.println("success");
	}

	private static void query() {
		// TODO Auto-generated method stub
		try {
			Class.forName(DRIVER);
			java.sql.Connection conn = DriverManager.getConnection(URL,
					USERNAME, PASSWORD);
			String sql = "select id,name,age,description from person1";
			java.sql.Statement state = conn.createStatement();
			// 执行查询并返回结果集
			ResultSet rs = state.executeQuery(sql);

			while (rs.next()) {
				int id=rs.getInt(1);
				String name=rs.getString(2);
				int age=rs.getInt(3);
				String description =rs.getString(4);
				System.out.println("id="+id+",name="+name+",age="+age+",des="+description);
			}
			rs.close();
			state.close();
			conn.close();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

}