demodatabaseaccess.java

来自「一个JDBC应用的例子」· Java 代码 · 共 31 行

import java.sql.*;

public class DemoDatabaseAccess {
	public static void main(String args[]) {
		try {
			String sql = "DELETE FROM Person WHERE id = ?";
			ResultSet data = null;
			DatabaseAccess da = new DatabaseAccess();
			da.prepare(sql);
			da.setParameter(1, "clint");
			da.preparedUpdate();
			sql = "SELECT * FROM Person";
			data = da.query(sql);
			displayData(data);
			da.close();
		} catch (SQLException exc) {
			exc.printStackTrace();  System.exit(1);
		}
	}
	private static void displayData(ResultSet data) throws SQLException {
		System.out.println("代码\t姓名\t出生日期\t性别");
		while (data.next()) {
			String id = data.getString("id");
			String name = data.getString("name");
			Date birthDay = data.getDate("birthday");
			String sex = data.getBoolean("sex") ? "女" : "男";
			System.out.println(id + "\t" + name + "\t" + birthDay + "\t" + sex);
		}
	}
}