public boolean registeredStundent(StudentVO studentVO)
			throws LibraryManagementException {

		PreparedStatement preparedStatement = null;
		ConnectionFactory connectionFactory = new ConnectionFactory();
		Connection connection = connectionFactory.getConnection();

		String sqlquery = "insert into STUDENT (FIRST_NAME, LAST_NAME, "
				+ "FATHER_NAME, GENDER, EMAIL, MOBILE, STUDENT_NUMBER"
				+ ", ADMISSION_YEAR, ENROLL_NUMBER, U_ID, PASSWORD) values(?,?,?,?,?,?,?,?,?,?,?)";
		boolean created;
		int flag=0;
		try {
			preparedStatement = connection.prepareStatement(sqlquery);
			preparedStatement.setString(1, studentVO.getFirstName());
			preparedStatement.setString(2, studentVO.getLastName());
			preparedStatement.setString(3, studentVO.getFatherName());
			preparedStatement.setString(4, studentVO.getGender());
			preparedStatement.setString(5, studentVO.getEmail());
			preparedStatement.setString(6, studentVO.getMobile());
			preparedStatement.setString(7, studentVO.getStudentNumber());
			preparedStatement.setInt(8, studentVO.getAdmissionYear());
			preparedStatement.setString(9, studentVO.getEnrollNumber());
			preparedStatement.setString(10, studentVO.getuID());
			preparedStatement.setString(11, studentVO.getPassword());
			flag = preparedStatement.executeUpdate();
			if(flag == 0) {
				created = false;
			} else {
				created =true;
			}
		} catch (SQLException e) {
			throw new LibraryManagementException(ExceptionCategory.SYSTEM);
		}
		if (preparedStatement != null) {
			try {
				preparedStatement.close();
			} catch (SQLException e) {
				throw new LibraryManagementException(ExceptionCategory.SYSTEM);
			}
		}

		try {
			connection.close();
		} catch (SQLException e) {
			throw new LibraryManagementException(ExceptionCategory.SYSTEM);
		}
		return created;
	}