Laufumgebung:
JDK1.8, Tomcat8, Eclipse, MySQL5.6, Navicat
Funktionsimplementierung:
Benutzer: Benutzer Name, Login-Passwort, Name, Geschlecht, Geburtsdatum, Benutzerfoto, Kontaktnummer, E-Mail, Privatadresse, Registrierungszeit
Ältere Person: Seniorennummer, Name, Geschlecht, Alter, Seniorenfoto, Einführung für Senioren, Registrierter Benutzer, Registrierungszeit
Zimmertyp: Zimmertyp-ID, Zimmertypname
Zimmer: Zimmernummer, Zimmertyp, Zimmername, Zimmerhauptbild, Zimmerpreis, Zimmerdetails, Zimmerstatus
Bestellung: Bestellnummer, Zimmer zum Übernachten, ältere Person zum Übernachten, Datum des Check-ins, Uhrzeit des Check-ins, Gesamtbetrag der Bestellung, Bestellung Status, Bestellgebührendetails, Bestellzeit
Altenpflege: Datensatz-ID, Informationskategorie, Informationstitel, Informationsinhalt, Veröffentlichungszeit
Empfang: Empfangsdatensatz-ID, Empfangskategorie, Empfangsthema, Empfangsinhalt, Empfangsdatum
Abteilung: Abteilungsnummer, Abteilungsname, Gründungsdatum, verantwortliche Person
Mitarbeiter: Benutzername, Login-Passwort, Abteilung, Name , Geschlecht, Geburtsdatum, Mitarbeiterfoto, Kontaktnummer, Privatadresse #🎜🎜 #
Gehalt: Gehalts-ID, Mitarbeiter, Gehaltsjahr, Gehaltsmonat, Gehaltshöhe, Zahlungsdatum, Gehaltsbemerkungen#🎜 🎜#
#🎜 🎜# 
Steuerungsebene für die Benutzerverwaltung: # 🎜🎜#
//UserInfo管理控制层
@Controller
@RequestMapping("/UserInfo")
public class UserInfoController extends BaseController {
/*业务层对象*/
@Resource UserInfoService userInfoService;
@InitBinder("userInfo")
public void initBinderUserInfo(WebDataBinder binder) {
binder.setFieldDefaultPrefix("userInfo.");
}
/*跳转到添加UserInfo视图*/
@RequestMapping(value = "/add", method = RequestMethod.GET)
public String add(Model model,HttpServletRequest request) throws Exception {
model.addAttribute(new UserInfo());
return "UserInfo_add";
}
/*客户端ajax方式提交添加用户信息*/
@RequestMapping(value = "/add", method = RequestMethod.POST)
public void add(@Validated UserInfo userInfo, BindingResult br,
Model model, HttpServletRequest request,HttpServletResponse response) throws Exception {
String message = "";
boolean success = false;
if (br.hasErrors()) {
message = "输入信息不符合要求！";
writeJsonResponse(response, success, message);
return ;
}
if(userInfoService.getUserInfo(userInfo.getUser_name()) != null) {
message = "用户名已经存在！";
writeJsonResponse(response, success, message);
return ;
}
try {
userInfo.setUserPhoto(this.handlePhotoUpload(request, "userPhotoFile"));
} catch(UserException ex) {
message = "图片格式不正确！";
writeJsonResponse(response, success, message);
return ;
}
userInfoService.addUserInfo(userInfo);
message = "用户添加成功!";
success = true;
writeJsonResponse(response, success, message);
}
/*ajax方式按照查询条件分页查询用户信息*/
@RequestMapping(value = { "/list" }, method = {RequestMethod.GET,RequestMethod.POST})
public void list(String user_name,String name,String birthDate,String telephone,Integer page,Integer rows, Model model, HttpServletRequest request,HttpServletResponse response) throws Exception {
if (page==null || page == 0) page = 1;
if (user_name == null) user_name = "";
if (name == null) name = "";
if (birthDate == null) birthDate = "";
if (telephone == null) telephone = "";
if(rows != 0)userInfoService.setRows(rows);
List<UserInfo> userInfoList = userInfoService.queryUserInfo(user_name, name, birthDate, telephone, page);
/*计算总的页数和总的记录数*/
userInfoService.queryTotalPageAndRecordNumber(user_name, name, birthDate, telephone);
/*获取到总的页码数目*/
int totalPage = userInfoService.getTotalPage();
/*当前查询条件下总记录数*/
int recordNumber = userInfoService.getRecordNumber();
response.setContentType("text/json;charset=UTF-8");
PrintWriter out = response.getWriter();
//将要被返回到客户端的对象
JSONObject jsonObj=new JSONObject();
jsonObj.accumulate("total", recordNumber);
JSONArray jsonArray = new JSONArray();
for(UserInfo userInfo:userInfoList) {
JSONObject jsonUserInfo = userInfo.getJsonObject();
jsonArray.put(jsonUserInfo);
}
jsonObj.accumulate("rows", jsonArray);
out.println(jsonObj.toString());
out.flush();
out.close();
}
/*ajax方式按照查询条件分页查询用户信息*/
@RequestMapping(value = { "/listAll" }, method = {RequestMethod.GET,RequestMethod.POST})
public void listAll(HttpServletResponse response) throws Exception {
List<UserInfo> userInfoList = userInfoService.queryAllUserInfo();
response.setContentType("text/json;charset=UTF-8");
PrintWriter out = response.getWriter();
JSONArray jsonArray = new JSONArray();
for(UserInfo userInfo:userInfoList) {
JSONObject jsonUserInfo = new JSONObject();
jsonUserInfo.accumulate("user_name", userInfo.getUser_name());
jsonUserInfo.accumulate("name", userInfo.getName());
jsonArray.put(jsonUserInfo);
}
out.println(jsonArray.toString());
out.flush();
out.close();
}
/*前台按照查询条件分页查询用户信息*/
@RequestMapping(value = { "/frontlist" }, method = {RequestMethod.GET,RequestMethod.POST})
public String frontlist(String user_name,String name,String birthDate,String telephone,Integer currentPage, Model model, HttpServletRequest request) throws Exception {
if (currentPage==null || currentPage == 0) currentPage = 1;
if (user_name == null) user_name = "";
if (name == null) name = "";
if (birthDate == null) birthDate = "";
if (telephone == null) telephone = "";
List<UserInfo> userInfoList = userInfoService.queryUserInfo(user_name, name, birthDate, telephone, currentPage);
/*计算总的页数和总的记录数*/
userInfoService.queryTotalPageAndRecordNumber(user_name, name, birthDate, telephone);
/*获取到总的页码数目*/
int totalPage = userInfoService.getTotalPage();
/*当前查询条件下总记录数*/
int recordNumber = userInfoService.getRecordNumber();
request.setAttribute("userInfoList", userInfoList);
request.setAttribute("totalPage", totalPage);
request.setAttribute("recordNumber", recordNumber);
request.setAttribute("currentPage", currentPage);
request.setAttribute("user_name", user_name);
request.setAttribute("name", name);
request.setAttribute("birthDate", birthDate);
request.setAttribute("telephone", telephone);
return "UserInfo/userInfo_frontquery_result";
}
/*前台查询UserInfo信息*/
@RequestMapping(value="/{user_name}/frontshow",method=RequestMethod.GET)
public String frontshow(@PathVariable String user_name,Model model,HttpServletRequest request) throws Exception {
/*根据主键user_name获取UserInfo对象*/
UserInfo userInfo = userInfoService.getUserInfo(user_name);
request.setAttribute("userInfo", userInfo);
return "UserInfo/userInfo_frontshow";
}
/*ajax方式显示用户修改jsp视图页*/
@RequestMapping(value="/{user_name}/update",method=RequestMethod.GET)
public void update(@PathVariable String user_name,Model model,HttpServletRequest request,HttpServletResponse response) throws Exception {
/*根据主键user_name获取UserInfo对象*/
UserInfo userInfo = userInfoService.getUserInfo(user_name);
response.setContentType("text/json;charset=UTF-8");
PrintWriter out = response.getWriter();
//将要被返回到客户端的对象
JSONObject jsonUserInfo = userInfo.getJsonObject();
out.println(jsonUserInfo.toString());
out.flush();
out.close();
}
/*ajax方式更新用户信息*/
@RequestMapping(value = "/{user_name}/update", method = RequestMethod.POST)
public void update(@Validated UserInfo userInfo, BindingResult br,
Model model, HttpServletRequest request,HttpServletResponse response) throws Exception {
String message = "";
boolean success = false;
if (br.hasErrors()) {
message = "输入的信息有错误！";
writeJsonResponse(response, success, message);
return;
}
String userPhotoFileName = this.handlePhotoUpload(request, "userPhotoFile");
if(!userPhotoFileName.equals("upload/NoImage.jpg"))userInfo.setUserPhoto(userPhotoFileName);
try {
userInfoService.updateUserInfo(userInfo);
message = "用户更新成功!";
success = true;
writeJsonResponse(response, success, message);
} catch (Exception e) {
e.printStackTrace();
message = "用户更新失败!";
writeJsonResponse(response, success, message);
}
}
/*删除用户信息*/
@RequestMapping(value="/{user_name}/delete",method=RequestMethod.GET)
public String delete(@PathVariable String user_name,HttpServletRequest request) throws UnsupportedEncodingException {
try {
userInfoService.deleteUserInfo(user_name);
request.setAttribute("message", "用户删除成功!");
return "message";
} catch (Exception e) {
e.printStackTrace();
request.setAttribute("error", "用户删除失败!");
return "error";
}
}
/*ajax方式删除多条用户记录*/
@RequestMapping(value="/deletes",method=RequestMethod.POST)
public void delete(String user_names,HttpServletRequest request,HttpServletResponse response) throws IOException, JSONException {
String message = "";
boolean success = false;
try {
int count = userInfoService.deleteUserInfos(user_names);
success = true;
message = count + "条记录删除成功";
writeJsonResponse(response, success, message);
} catch (Exception e) {
//e.printStackTrace();
message = "有记录存在外键约束,删除失败";
writeJsonResponse(response, success, message);
}
}
/*按照查询条件导出用户信息到Excel*/
@RequestMapping(value = { "/OutToExcel" }, method = {RequestMethod.GET,RequestMethod.POST})
public void OutToExcel(String user_name,String name,String birthDate,String telephone, Model model, HttpServletRequest request,HttpServletResponse response) throws Exception {
if(user_name == null) user_name = "";
if(name == null) name = "";
if(birthDate == null) birthDate = "";
if(telephone == null) telephone = "";
List<UserInfo> userInfoList = userInfoService.queryUserInfo(user_name,name,birthDate,telephone);
ExportExcelUtil ex = new ExportExcelUtil();
String _title = "UserInfo信息记录";
String[] headers = { "用户名","姓名","性别","出生日期","用户照片","联系电话","邮箱","注册时间"};
List<String[]> dataset = new ArrayList<String[]>();
for(int i=0;i<userInfoList.size();i++) {
UserInfo userInfo = userInfoList.get(i);
dataset.add(new String[]{userInfo.getUser_name(),userInfo.getName(),userInfo.getGender(),userInfo.getBirthDate(),userInfo.getUserPhoto(),userInfo.getTelephone(),userInfo.getEmail(),userInfo.getRegTime()});
}
/*
OutputStream out = null;
try {
out = new FileOutputStream("C://output.xls");
ex.exportExcel(title,headers, dataset, out);
out.close();
} catch (Exception e) {
e.printStackTrace();
}
*/
OutputStream out = null;//创建一个输出流对象
try {
out = response.getOutputStream();//
response.setHeader("Content-disposition","attachment; filename="+"UserInfo.xls");//filename是下载的xls的名，建议最好用英文
response.setContentType("application/msexcel;charset=UTF-8");//设置类型
response.setHeader("Pragma","No-cache");//设置头
response.setHeader("Cache-Control","no-cache");//设置头
response.setDateHeader("Expires", 0);//设置日期头
String rootPath = request.getSession().getServletContext().getRealPath("/");
ex.exportExcel(rootPath,_title,headers, dataset, out);
out.flush();
} catch (IOException e) {
e.printStackTrace();
}finally{
try{
if(out!=null){
out.close();
}
}catch(IOException e){
e.printStackTrace();
}
}
}
}
Steuerungsebene für die Administratorverwaltung: @Controller
@SessionAttributes("username")
public class SystemController {
@Resource AdminService adminService;
@Resource UserInfoService userInfoService;
@RequestMapping(value="/login",method=RequestMethod.GET)
public String login(Model model) {
model.addAttribute(new Admin());
return "login";
}
//前台用户登录
@RequestMapping(value="/frontLogin",method=RequestMethod.POST)
public void frontLogin(@RequestParam("userName")String userName,@RequestParam("password")String password,HttpServletResponse response,HttpSession session) throws Exception {
boolean success = true;
String msg = "";
if (!userInfoService.checkLogin(userName, password)) {
msg = userInfoService.getErrMessage();
success = false;
}
if(success) {
session.setAttribute("user_name", userName);
}
response.setContentType("text/json;charset=UTF-8");
PrintWriter out = response.getWriter();
//将要被返回到客户端的对象
JSONObject json=new JSONObject();
json.accumulate("success", success);
json.accumulate("msg", msg);
out.println(json.toString());
out.flush();
out.close();
}
@RequestMapping(value="/login",method=RequestMethod.POST)
public void login(@Validated Admin admin,BindingResult br,Model model,HttpServletRequest request,HttpServletResponse response,HttpSession session) throws Exception {
boolean success = true;
String msg = "";
if(br.hasErrors()) {
msg = br.getAllErrors().toString();
success = false;
}
if (!adminService.checkLogin(admin)) {
msg = adminService.getErrMessage();
success = false;
}
if(success) {
session.setAttribute("username", admin.getUsername());
}
response.setContentType("text/json;charset=UTF-8");
PrintWriter out = response.getWriter();
//将要被返回到客户端的对象
JSONObject json=new JSONObject();
json.accumulate("success", success);
json.accumulate("msg", msg);
out.println(json.toString());
out.flush();
out.close();
}
@RequestMapping("/logout")
public String logout(Model model,HttpSession session) {
model.asMap().remove("username");
session.invalidate();
return "redirect:/login";
}
@RequestMapping(value="/changePassword",method=RequestMethod.POST)
public String ChangePassword(String oldPassword,String newPassword,String newPassword2,HttpServletRequest request,HttpSession session) throws Exception {
if(oldPassword.equals("")) throw new UserException("请输入旧密码！");
if(newPassword.equals("")) throw new UserException("请输入新密码！");
if(!newPassword.equals(newPassword2)) throw new UserException("两次新密码输入不一致");
String username = (String)session.getAttribute("username");
if(username == null) throw new UserException("session会话超时，请重新登录系统!");
Admin admin = adminService.findAdminByUserName(username);
if(!admin.getPassword().equals(oldPassword)) throw new UserException("输入的旧密码不正确!");
try {
adminService.changePassword(username,newPassword);
request.setAttribute("message", java.net.URLEncoder.encode(
"密码修改成功!", "GBK"));
return "message";
} catch (Exception e) {
e.printStackTrace();
request.setAttribute("error", java.net.URLEncoder
.encode("密码修改失败!","GBK"));
return "error";
}
}
}Steuerungsebene für die Raumverwaltung:
//Room管理控制层
@Controller
@RequestMapping("/Room")
public class RoomController extends BaseController {
/*业务层对象*/
@Resource RoomService roomService;
@Resource RoomTypeService roomTypeService;
@InitBinder("roomTypeObj")
public void initBinderroomTypeObj(WebDataBinder binder) {
binder.setFieldDefaultPrefix("roomTypeObj.");
}
@InitBinder("room")
public void initBinderRoom(WebDataBinder binder) {
binder.setFieldDefaultPrefix("room.");
}
/*跳转到添加Room视图*/
@RequestMapping(value = "/add", method = RequestMethod.GET)
public String add(Model model,HttpServletRequest request) throws Exception {
model.addAttribute(new Room());
/*查询所有的RoomType信息*/
List<RoomType> roomTypeList = roomTypeService.queryAllRoomType();
request.setAttribute("roomTypeList", roomTypeList);
return "Room_add";
}
/*客户端ajax方式提交添加房间信息*/
@RequestMapping(value = "/add", method = RequestMethod.POST)
public void add(@Validated Room room, BindingResult br,
Model model, HttpServletRequest request,HttpServletResponse response) throws Exception {
String message = "";
boolean success = false;
if (br.hasErrors()) {
message = "输入信息不符合要求！";
writeJsonResponse(response, success, message);
return ;
}
if(roomService.getRoom(room.getRoomNo()) != null) {
message = "房间编号已经存在！";
writeJsonResponse(response, success, message);
return ;
}
try {
room.setMainPhoto(this.handlePhotoUpload(request, "mainPhotoFile"));
} catch(UserException ex) {
message = "图片格式不正确！";
writeJsonResponse(response, success, message);
return ;
}
roomService.addRoom(room);
message = "房间添加成功!";
success = true;
writeJsonResponse(response, success, message);
}
/*ajax方式按照查询条件分页查询房间信息*/
@RequestMapping(value = { "/list" }, method = {RequestMethod.GET,RequestMethod.POST})
public void list(String roomNo,@ModelAttribute("roomTypeObj") RoomType roomTypeObj,String roomName,String roomState,Integer page,Integer rows, Model model, HttpServletRequest request,HttpServletResponse response) throws Exception {
if (page==null || page == 0) page = 1;
if (roomNo == null) roomNo = "";
if (roomName == null) roomName = "";
if (roomState == null) roomState = "";
if(rows != 0)roomService.setRows(rows);
List<Room> roomList = roomService.queryRoom(roomNo, roomTypeObj, roomName, roomState, page);
/*计算总的页数和总的记录数*/
roomService.queryTotalPageAndRecordNumber(roomNo, roomTypeObj, roomName, roomState);
/*获取到总的页码数目*/
int totalPage = roomService.getTotalPage();
/*当前查询条件下总记录数*/
int recordNumber = roomService.getRecordNumber();
response.setContentType("text/json;charset=UTF-8");
PrintWriter out = response.getWriter();
//将要被返回到客户端的对象
JSONObject jsonObj=new JSONObject();
jsonObj.accumulate("total", recordNumber);
JSONArray jsonArray = new JSONArray();
for(Room room:roomList) {
JSONObject jsonRoom = room.getJsonObject();
jsonArray.put(jsonRoom);
}
jsonObj.accumulate("rows", jsonArray);
out.println(jsonObj.toString());
out.flush();
out.close();
}
/*ajax方式按照查询条件分页查询房间信息*/
@RequestMapping(value = { "/listAll" }, method = {RequestMethod.GET,RequestMethod.POST})
public void listAll(HttpServletResponse response) throws Exception {
List<Room> roomList = roomService.queryAllRoom();
response.setContentType("text/json;charset=UTF-8");
PrintWriter out = response.getWriter();
JSONArray jsonArray = new JSONArray();
for(Room room:roomList) {
JSONObject jsonRoom = new JSONObject();
jsonRoom.accumulate("roomNo", room.getRoomNo());
jsonRoom.accumulate("roomName", room.getRoomName());
jsonArray.put(jsonRoom);
}
out.println(jsonArray.toString());
out.flush();
out.close();
}
/*前台按照查询条件分页查询房间信息*/
@RequestMapping(value = { "/frontlist" }, method = {RequestMethod.GET,RequestMethod.POST})
public String frontlist(String roomNo,@ModelAttribute("roomTypeObj") RoomType roomTypeObj,String roomName,String roomState,Integer currentPage, Model model, HttpServletRequest request) throws Exception {
if (currentPage==null || currentPage == 0) currentPage = 1;
if (roomNo == null) roomNo = "";
if (roomName == null) roomName = "";
if (roomState == null) roomState = "";
List<Room> roomList = roomService.queryRoom(roomNo, roomTypeObj, roomName, roomState, currentPage);
/*计算总的页数和总的记录数*/
roomService.queryTotalPageAndRecordNumber(roomNo, roomTypeObj, roomName, roomState);
/*获取到总的页码数目*/
int totalPage = roomService.getTotalPage();
/*当前查询条件下总记录数*/
int recordNumber = roomService.getRecordNumber();
request.setAttribute("roomList", roomList);
request.setAttribute("totalPage", totalPage);
request.setAttribute("recordNumber", recordNumber);
request.setAttribute("currentPage", currentPage);
request.setAttribute("roomNo", roomNo);
request.setAttribute("roomTypeObj", roomTypeObj);
request.setAttribute("roomName", roomName);
request.setAttribute("roomState", roomState);
List<RoomType> roomTypeList = roomTypeService.queryAllRoomType();
request.setAttribute("roomTypeList", roomTypeList);
return "Room/room_frontquery_result";
}
/*前台查询Room信息*/
@RequestMapping(value="/{roomNo}/frontshow",method=RequestMethod.GET)
public String frontshow(@PathVariable String roomNo,Model model,HttpServletRequest request) throws Exception {
/*根据主键roomNo获取Room对象*/
Room room = roomService.getRoom(roomNo);
List<RoomType> roomTypeList = roomTypeService.queryAllRoomType();
request.setAttribute("roomTypeList", roomTypeList);
request.setAttribute("room", room);
return "Room/room_frontshow";
}
/*ajax方式显示房间修改jsp视图页*/
@RequestMapping(value="/{roomNo}/update",method=RequestMethod.GET)
public void update(@PathVariable String roomNo,Model model,HttpServletRequest request,HttpServletResponse response) throws Exception {
/*根据主键roomNo获取Room对象*/
Room room = roomService.getRoom(roomNo);
response.setContentType("text/json;charset=UTF-8");
PrintWriter out = response.getWriter();
//将要被返回到客户端的对象
JSONObject jsonRoom = room.getJsonObject();
out.println(jsonRoom.toString());
out.flush();
out.close();
}
/*ajax方式更新房间信息*/
@RequestMapping(value = "/{roomNo}/update", method = RequestMethod.POST)
public void update(@Validated Room room, BindingResult br,
Model model, HttpServletRequest request,HttpServletResponse response) throws Exception {
String message = "";
boolean success = false;
if (br.hasErrors()) {
message = "输入的信息有错误！";
writeJsonResponse(response, success, message);
return;
}
String mainPhotoFileName = this.handlePhotoUpload(request, "mainPhotoFile");
if(!mainPhotoFileName.equals("upload/NoImage.jpg"))room.setMainPhoto(mainPhotoFileName);
try {
roomService.updateRoom(room);
message = "房间更新成功!";
success = true;
writeJsonResponse(response, success, message);
} catch (Exception e) {
e.printStackTrace();
message = "房间更新失败!";
writeJsonResponse(response, success, message);
}
}
/*删除房间信息*/
@RequestMapping(value="/{roomNo}/delete",method=RequestMethod.GET)
public String delete(@PathVariable String roomNo,HttpServletRequest request) throws UnsupportedEncodingException {
try {
roomService.deleteRoom(roomNo);
request.setAttribute("message", "房间删除成功!");
return "message";
} catch (Exception e) {
e.printStackTrace();
request.setAttribute("error", "房间删除失败!");
return "error";
}
}
/*ajax方式删除多条房间记录*/
@RequestMapping(value="/deletes",method=RequestMethod.POST)
public void delete(String roomNos,HttpServletRequest request,HttpServletResponse response) throws IOException, JSONException {
String message = "";
boolean success = false;
try {
int count = roomService.deleteRooms(roomNos);
success = true;
message = count + "条记录删除成功";
writeJsonResponse(response, success, message);
} catch (Exception e) {
//e.printStackTrace();
message = "有记录存在外键约束,删除失败";
writeJsonResponse(response, success, message);
}
}
/*按照查询条件导出房间信息到Excel*/
@RequestMapping(value = { "/OutToExcel" }, method = {RequestMethod.GET,RequestMethod.POST})
public void OutToExcel(String roomNo,@ModelAttribute("roomTypeObj") RoomType roomTypeObj,String roomName,String roomState, Model model, HttpServletRequest request,HttpServletResponse response) throws Exception {
if(roomNo == null) roomNo = "";
if(roomName == null) roomName = "";
if(roomState == null) roomState = "";
List<Room> roomList = roomService.queryRoom(roomNo,roomTypeObj,roomName,roomState);
ExportExcelUtil ex = new ExportExcelUtil();
String _title = "Room信息记录";
String[] headers = { "房间编号","房间类型","房间名称","房间主图","房间价格","房间状态"};
List<String[]> dataset = new ArrayList<String[]>();
for(int i=0;i<roomList.size();i++) {
Room room = roomList.get(i);
dataset.add(new String[]{room.getRoomNo(),room.getRoomTypeObj().getTypeName(),room.getRoomName(),room.getMainPhoto(),room.getPrice() + "",room.getRoomState()});
}
/*
OutputStream out = null;
try {
out = new FileOutputStream("C://output.xls");
ex.exportExcel(title,headers, dataset, out);
out.close();
} catch (Exception e) {
e.printStackTrace();
}
*/
OutputStream out = null;//创建一个输出流对象
try {
out = response.getOutputStream();//
response.setHeader("Content-disposition","attachment; filename="+"Room.xls");//filename是下载的xls的名，建议最好用英文
response.setContentType("application/msexcel;charset=UTF-8");//设置类型
response.setHeader("Pragma","No-cache");//设置头
response.setHeader("Cache-Control","no-cache");//设置头
response.setDateHeader("Expires", 0);//设置日期头
String rootPath = request.getSession().getServletContext().getRealPath("/");
ex.exportExcel(rootPath,_title,headers, dataset, out);
out.flush();
} catch (IOException e) {
e.printStackTrace();
}finally{
try{
if(out!=null){
out.close();
}
}catch(IOException e){
e.printStackTrace();
}
}
}
}Das obige ist der detaillierte Inhalt vonSo implementieren Sie ein Pflegeheimverwaltungssystem in Java. Für weitere Informationen folgen Sie bitte anderen verwandten Artikeln auf der PHP chinesischen Website!
Stellungnahme
Dieser Artikel ist reproduziert unter:亿速云. Bei Verstößen wenden Sie sich bitte an admin@php.cn löschen
Wie benutze ich Maven oder Gradle für das fortschrittliche Java -Projektmanagement, die Erstellung von Automatisierung und Abhängigkeitslösung?Mar 17, 2025 pm 05:46 PMIn dem Artikel werden Maven und Gradle für Java -Projektmanagement, Aufbau von Automatisierung und Abhängigkeitslösung erörtert, die ihre Ansätze und Optimierungsstrategien vergleichen.
Wie erstelle und verwende ich benutzerdefinierte Java -Bibliotheken (JAR -Dateien) mit ordnungsgemäßem Versioning und Abhängigkeitsmanagement?Mar 17, 2025 pm 05:45 PMIn dem Artikel werden benutzerdefinierte Java -Bibliotheken (JAR -Dateien) mit ordnungsgemäßem Versioning- und Abhängigkeitsmanagement erstellt und verwendet, wobei Tools wie Maven und Gradle verwendet werden.
Wie implementiere ich mehrstufige Caching in Java-Anwendungen mit Bibliotheken wie Koffein oder Guava-Cache?Mar 17, 2025 pm 05:44 PMIn dem Artikel wird in der Implementierung von mehrstufigem Caching in Java mithilfe von Koffein- und Guava-Cache zur Verbesserung der Anwendungsleistung erläutert. Es deckt die Einrichtungs-, Integrations- und Leistungsvorteile sowie die Bestrafung des Konfigurations- und Räumungsrichtlinienmanagements ab
Wie kann ich JPA (Java Persistence-API) für Objektrelationszuordnungen mit erweiterten Funktionen wie Caching und faulen Laden verwenden?Mar 17, 2025 pm 05:43 PMIn dem Artikel werden mit JPA für Objektrelationszuordnungen mit erweiterten Funktionen wie Caching und faulen Laden erläutert. Es deckt Setup, Entity -Mapping und Best Practices zur Optimierung der Leistung ab und hebt potenzielle Fallstricke hervor. [159 Charaktere]
Wie funktioniert der Klassenladungsmechanismus von Java, einschließlich verschiedener Klassenloader und deren Delegationsmodelle?Mar 17, 2025 pm 05:35 PMMit der Klassenbelastung von Java wird das Laden, Verknüpfen und Initialisieren von Klassen mithilfe eines hierarchischen Systems mit Bootstrap-, Erweiterungs- und Anwendungsklassenloadern umfasst. Das übergeordnete Delegationsmodell stellt sicher
Heiße KI -Werkzeuge
Undresser.AI Undress
KI-gestützte App zum Erstellen realistischer Aktfotos
AI Clothes Remover
Online-KI-Tool zum Entfernen von Kleidung aus Fotos.
Undress AI Tool
Ausziehbilder kostenlos
Clothoff.io
KI-Kleiderentferner
AI Hentai Generator
Erstellen Sie kostenlos Ai Hentai.
Heißer Artikel
R.E.P.O. Energiekristalle erklärten und was sie tun (gelber Kristall)
4 Wochen vorBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Beste grafische Einstellungen
4 Wochen vorBy尊渡假赌尊渡假赌尊渡假赌
Assassin's Creed Shadows: Seashell Riddle -Lösung
2 Wochen vorByDDD
R.E.P.O. So reparieren Sie Audio, wenn Sie niemanden hören können
1 Monate vorBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Chat -Befehle und wie man sie benutzt
1 Monate vorBy尊渡假赌尊渡假赌尊渡假赌
Heiße Werkzeuge
MantisBT
Mantis ist ein einfach zu implementierendes webbasiertes Tool zur Fehlerverfolgung, das die Fehlerverfolgung von Produkten unterstützen soll. Es erfordert PHP, MySQL und einen Webserver. Schauen Sie sich unsere Demo- und Hosting-Services an.
SAP NetWeaver Server-Adapter für Eclipse
Integrieren Sie Eclipse mit dem SAP NetWeaver-Anwendungsserver.
VSCode Windows 64-Bit-Download
Ein kostenloser und leistungsstarker IDE-Editor von Microsoft
SublimeText3 Englische Version
Empfohlen: Win-Version, unterstützt Code-Eingabeaufforderungen!
ZendStudio 13.5.1 Mac
Leistungsstarke integrierte PHP-Entwicklungsumgebung
