public List<Record> listRecord() {
Connection con = ConnectionUtils.getConnection();
List<Record> recordList1 = new ArrayList<Record>();
try {
String query = "SELECT bookRecordId,bookId,status,studentId from BookRecord";
PreparedStatement statement = con.prepareStatement(query);
ResultSet resultSet = statement.executeQuery();
while (resultSet.next()) {
while (resultSet.next()) {
Record record = new Record();
record.setBookRecord(resultSet.getString("bookRecordId"));
record.setBookId(resultSet.getString("bookId"));
record.setStatus(resultSet.getString("status"));
record.setStudentId(resultSet.getString("studentId"));
recordList1.add(record);
}
}
} catch (SQLException ex) {
throw new IllegalStateException(ex);
} finally {
try {
con.close();
} catch (SQLException ex2) {
throw new IllegalStateException(ex2);
}
}
return recordList1;
}
// 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);
}
}
}
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;
}
public List<Record> getRecord() {
List<Record> recList = new ArrayList<Record>();
Connection con = ConnectionUtils.getConnection();
String qury = "SELECT bookRecordId,bookId,status,studentId from BookRecord";
try {
PreparedStatement statement = con.prepareStatement(qury);
ResultSet resultSet = statement.executeQuery();
while (resultSet.next()) {
Record rec = new Record();
rec.setBookRecord(resultSet.getString("bookRecordId"));
rec.setBookId(resultSet.getString("bookId"));
rec.setStatus(resultSet.getString("status"));
rec.setStudentId(resultSet.getString("studentId"));
recList.add(rec);
}
} catch (Exception ec) {
throw new IllegalStateException(ec);
}
return recList;
}
// 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;
}
public void bookRecordList(List<Book> searchedBookList) {
List<Book> bookList = new ArrayList<Book>();
bookList = searchedBookList;
ArrayList<Book> list = (ArrayList<Book>) bookList;
Iterator<Book> itr = list.iterator();
while (itr.hasNext()) {
Book book = itr.next();
String bookId = book.getbookId();
Connection con = ConnectionUtils.getConnection();
try {
String query =
"SELECT bookRecordId,bookId,status,studentId from BookRecord where bookId=? and status=?";
PreparedStatement statement = con.prepareStatement(query);
statement.setString(1, bookId);
statement.setString(2, "available");
ResultSet resultSet = statement.executeQuery();
while (resultSet.next()) {
Record record = new Record();
record.setBookId(resultSet.getString("bookId"));
record.setBookRecord(resultSet.getString("bookRecordId"));
record.setStatus(resultSet.getString("status"));
record.setStudentId(resultSet.getString("studentId"));
recordList.add(record);
}
} catch (Exception ex) {
throw new IllegalStateException(ex);
} finally {
try {
con.close();
} catch (Exception ex1) {
throw new IllegalStateException(ex1);
}
}
}
}