getfirstnamebykey.txt

噶额外噶外骨骼感广泛高热感 就 啊啊

	public String getFirstNameByKey(String key) {
		String result = new String();

		Connection con = null;
		con = connect();

		Statement stmt = null;
		ResultSet rs = null;
		String select =
			"SELECT * FROM ITSO." + dbtab + " WHERE lastName = '" + key + "'";
		try {
			stmt = con.createStatement();
			rs = stmt.executeQuery(select);
			while (rs.next()) {
				result = rs.getString("firstName");
			}
		} catch (Exception e) {
			System.err.println("Exception: " + e.getMessage());
		} finally {
			try {
				if (rs   != null) rs.close();
				if (stmt != null) stmt.close();
				if (con  != null) con.close();
			} catch (SQLException e) {}
		}
		return result;
	}