@POST @Consumes(MediaType.APPLICATION_JSON) public Response addEvent(Event event) { if (authenticated) { Event evt = new Event(event); String sql = "INSERT INTO event (eventName, eventDescription, dateFrom, dateTo) VALUES( '" + evt.getEventName() + "', '" + evt.getEventDescription() + "', '" + evt.getDateFromString() + "'" + ",'" + evt.getDateToString() + "')"; try { sqlCon.getStatement().executeUpdate(sql); return Response.status(Status.ACCEPTED).build(); } catch (Exception e) { e.printStackTrace(); return Response.status(Status.BAD_REQUEST).build(); } finally { sqlCon.closeConnection(); } } else { return Response.status(Status.FORBIDDEN).build(); } }
public ArrayList<NhanVien> getTatCaNhanVien() { this.listNhanVien = new ArrayList<NhanVien>(); try { con = SQLConnection.getConnection(); pstmt = con.prepareStatement(sqlGetTatCaNhanVien); rs = pstmt.executeQuery(); while (rs.next()) { this.nhanVien = new NhanVien( rs.getInt(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getString(5)); this.listNhanVien.add(this.nhanVien); } } catch (SQLException e) { e.printStackTrace(); } finally { SQLConnection.closeConnection(this.con); SQLConnection.closePrepareStatement(pstmt); SQLConnection.closeResultSet(rs); } return this.listNhanVien; }
public NhanVien getNhanVienTheoTenDangNhapVaMatKhau(String tenDangNhap, String matKhau) { this.nhanVien = null; try { con = SQLConnection.getConnection(); pstmt = con.prepareStatement(sqlGetNhanVienTheoTenDangNhapVaMatKhau); pstmt.setString(1, tenDangNhap); pstmt.setString(2, matKhau); rs = pstmt.executeQuery(); if (rs.next()) { this.nhanVien = new NhanVien( rs.getInt(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getString(5)); } } catch (SQLException e) { e.printStackTrace(); } finally { SQLConnection.closeConnection(this.con); SQLConnection.closePrepareStatement(pstmt); SQLConnection.closeResultSet(rs); } return this.nhanVien; }
@DELETE @Path("/{eventId}") public Response deleteEvent(@PathParam("eventId") String eventId) { if (authenticated) { try { sqlCon.getStatement().executeUpdate("DELETE FROM event WHERE eventId = " + eventId); return Response.status(Status.ACCEPTED).build(); } catch (Exception e) { e.printStackTrace(); return Response.status(Status.BAD_REQUEST).build(); } finally { sqlCon.closeConnection(); } } else { return Response.status(Status.FORBIDDEN).build(); } }
@GET @Produces(MediaType.APPLICATION_JSON) @Path("register/{userId}") public Response getEventsAvailableForRegistration(@PathParam("userId") String userId) { List<Event> events = new ArrayList<Event>(); if (authenticated) { try { ResultSet rs = sqlCon .getStatement() .executeQuery( "SELECT event.eventId, event.eventName, event.eventDescription, event.dateFrom, event.dateTo " + "FROM event where not exists ( select eventId from user_event where event.eventId = user_event.eventId " + "AND user_event.userId = " + userId + " );"); while (rs.next()) { Event event = new Event(); long eventId = Long.parseLong(rs.getString("eventId")); event.setEventId(eventId); event.setEventName(rs.getString("eventName")); event.setEventDescription(rs.getString("eventDescription")); Calendar cal = new GregorianCalendar(); cal.set(2012, Calendar.AUGUST, 15, 15, 30); // event.setDateFrom(cal); // event.setDateTo(rs.getString("dateTo")); events.add(event); } } catch (Exception e) { e.printStackTrace(); } finally { sqlCon.closeConnection(); } GenericEntity<List<Event>> entity = new GenericEntity<List<Event>>(events) {}; return Response.status(Status.ACCEPTED).entity(entity).build(); } else { return Response.status(Status.FORBIDDEN).build(); } }
public int deleteNhanVien(int maNhanVien) { int result = 0; try { con = SQLConnection.getConnection(); pstmt = con.prepareStatement(sqlDeleteNhanVien); pstmt.setInt(1, maNhanVien); result = pstmt.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } finally { SQLConnection.closeConnection(this.con); SQLConnection.closePrepareStatement(pstmt); } return result; }
public int addLoaiSanPham(LoaiSanPham lsp) { int result = 0; try { con = SQLConnection.getConnection(); pstmt = con.prepareStatement(sqlAddLoaiSanPham); pstmt.setString(1, lsp.getTen()); pstmt.setString(2, lsp.getMoTa()); result = pstmt.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } finally { SQLConnection.closeConnection(this.con); SQLConnection.closePrepareStatement(pstmt); } return result; }
public int addNhanVien(NhanVien nv) { int result = 0; try { con = SQLConnection.getConnection(); pstmt = con.prepareStatement(sqlAddNhanVien); pstmt.setString(1, nv.getTen()); pstmt.setString(2, nv.getTenDangNhap()); pstmt.setString(3, nv.getMatKhau()); pstmt.setString(4, nv.getGhiChu()); result = pstmt.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } finally { SQLConnection.closeConnection(this.con); SQLConnection.closePrepareStatement(pstmt); } return result; }
public LoaiSanPham getLoaiSanPhamTheoMa(int maLoaiSanPham) { this.loaiSanPham = null; try { con = SQLConnection.getConnection(); pstmt = con.prepareStatement(sqlGetLoaiSanPhamTheoMa); pstmt.setInt(1, maLoaiSanPham); rs = pstmt.executeQuery(); if (rs.next()) { this.loaiSanPham = new LoaiSanPham(rs.getInt(1), rs.getString(2), rs.getString(3)); } } catch (SQLException e) { e.printStackTrace(); } finally { SQLConnection.closeConnection(this.con); SQLConnection.closePrepareStatement(pstmt); SQLConnection.closeResultSet(rs); } return this.loaiSanPham; }
public ArrayList<LoaiSanPham> getTatCaLoaiSanPham() { this.listLoaiSanPham = new ArrayList<LoaiSanPham>(); try { con = SQLConnection.getConnection(); pstmt = con.prepareStatement(sqlGetTatCaLoaiSanPham); rs = pstmt.executeQuery(); while (rs.next()) { this.loaiSanPham = new LoaiSanPham(rs.getInt(1), rs.getString(2), rs.getString(3)); this.listLoaiSanPham.add(this.loaiSanPham); } } catch (SQLException e) { e.printStackTrace(); } finally { SQLConnection.closeConnection(this.con); SQLConnection.closePrepareStatement(pstmt); SQLConnection.closeResultSet(rs); } return this.listLoaiSanPham; }
@PUT @Path("/{eventId}") @Consumes(MediaType.APPLICATION_JSON) public Response updateEvent(Event event, @PathParam("eventId") String eventId) { if (authenticated) { Event evt = new Event(event); String sql = "UPDATE event SET eventName = '" + evt.getEventName() + "', eventDescription = " + "'" + evt.getEventDescription() + "', dateFrom = " + "'" + evt.getDateFrom() + "'" + ", dateTo = " + "'" + evt.getDateTo() + "'" + " WHERE eventId =" + eventId; try { sqlCon.getStatement().executeUpdate(sql); return Response.status(Status.ACCEPTED).build(); } catch (Exception e) { e.printStackTrace(); return Response.status(Status.BAD_REQUEST).build(); } finally { sqlCon.closeConnection(); } } else { return Response.status(Status.FORBIDDEN).build(); } }
@GET @Produces(MediaType.APPLICATION_JSON) public Response getEvents() { List<Event> events = new ArrayList<Event>(); if (authenticated) { try { ResultSet rs = sqlCon.getStatement().executeQuery("SELECT * FROM event"); while (rs.next()) { Event event = new Event(); long eventId = Long.parseLong(rs.getString("eventId")); event.setEventId(eventId); event.setEventName(rs.getString("eventName")); event.setEventDescription(rs.getString("eventDescription")); Calendar cal = new GregorianCalendar(); cal.set(2012, Calendar.AUGUST, 15, 15, 30); // event.setDateFrom(cal); // event.setDateTo(rs.getString("dateTo")); events.add(event); } } catch (Exception e) { e.printStackTrace(); } finally { sqlCon.closeConnection(); } GenericEntity<List<Event>> entity = new GenericEntity<List<Event>>(events) {}; return Response.status(Status.ACCEPTED).entity(entity).build(); } else { return Response.status(Status.FORBIDDEN).build(); } }