lab6.java

来自「加拿大达内科技有限公司配需java程序员的上课时的代码」· Java 代码 · 共 33 行

package day02;

import java.sql.*;

public class Lab6 {
	public static void main(String[] args) {
		Connection con = null;
		Statement stmt = null;
		ResultSet rs = null;
		try {
			// 2.获取连接对象
			con = JdbcUtil.getConnection();
			// 3.获取Statement 对象
			stmt = con.createStatement();
			// 4.操作数据,得到结果集
			String sql = "Select * from xun";
			rs = stmt.executeQuery(sql);
			int id = 0;
			String name = null;
			StringBuffer sb = new StringBuffer();
			while (rs.next()) {
				id = rs.getInt(1);
				name = rs.getString(2);
				sb.append("id= " + id);
				sb.append("	name=" + name + "\n");
			}
			System.out.println(sb.toString());
		} catch (Exception e) {
		}
	}

}