// update Record will take the two arguemts one as the StudentList and other
// one is the RecordList recordList1
public void updateRecord(List<Student> studentList, List<Record> recordList) {
Student student2 = new Student();
Record record2 = new Record();
String studentid;
Iterator<Student> itr = studentList.iterator();
while (itr.hasNext()) {
student2 = (Student) itr.next();
}
studentid = student2.getStudentId();
String bookRecordId;
Iterator<Record> itr1 = recordList.iterator();
while (itr1.hasNext()) {
record2 = (Record) itr1.next();
}
bookRecordId = record2.getBookRecord();
Connection con = ConnectionUtils.getConnection();
String query = "UPDATE BookRecord set status=?,studentId=? where bookRecordId=? ";
try {
PreparedStatement statement = con.prepareStatement(query);
statement.setString(1, "issued");
statement.setString(2, student2.getStudentId());
statement.setString(3, record2.getBookRecord());
int result = statement.executeUpdate();
} catch (Exception ex) {
throw new IllegalStateException(ex);
} finally {
try {
con.close();
} catch (Exception ex1) {
throw new IllegalStateException(ex1);
}
}
}
// change the name in the issue Service for createRecord to
// createSearchBookRecord
public void createSearchRecord(Record record) {
// TODO Auto-generated method stub
List<Record> recordList1 = new ArrayList<Record>();
Connection con = ConnectionUtils.getConnection();
String query =
"SELECT bookRecordId,bookId,status,studentId from BookRecord where bookRecordId =?";
try {
PreparedStatement statement = con.prepareStatement(query);
statement.setString(1, record.getBookRecord());
ResultSet resultSet = statement.executeQuery();
while (resultSet.next()) {
Record record1 = new Record();
record1.setBookRecord(resultSet.getString("bookRecordId"));
record1.setBookId(resultSet.getString("bookId"));
record1.setStatus(resultSet.getString("status"));
record1.setStudentId(resultSet.getString("studentId"));
recordList1.add(record1);
}
} catch (Exception ex) {
throw new IllegalStateException(ex);
} finally {
try {
con.close();
} catch (Exception ex1) {
throw new IllegalStateException(ex1);
}
}
searchedRecordList = recordList1;
}
private PreparedStatement populateCreateRecordStatement(Record record, Connection con)
throws SQLException {
String query = "INSERT into BookRecord values(?,?,?,?)";
PreparedStatement statement = con.prepareStatement(query);
statement.setString(1, record.getBookRecord());
statement.setString(2, record.getBookId());
statement.setString(3, record.getStatus());
statement.setString(4, record.getStudentId());
return statement;
}