Java實(shí)戰(zhàn)之課程信息管理系統(tǒng)的實(shí)現(xiàn)
更新時(shí)間：2022年04月01日 11:54:09 作者：qq_1334611189
這篇文章主要介紹了如何利用Java實(shí)現(xiàn)課程信息管理系統(tǒng)，文中采用到的技術(shù)有：Springboot、SpringMVC、MyBatis、FreeMarker等，感興趣的可以了解一下
一、項(xiàng)目運(yùn)行
環(huán)境配置：
Jdk1.8 + Tomcat8.0 + mysql + Eclispe（IntelliJ IDEA,Eclispe,MyEclispe,Sts都支持）
項(xiàng)目技術(shù)：
Springboot + SpringMVC + MyBatis + FreeMarker + JavaScript + JQuery + Ajax + maven等等。
二、效果圖展示
三、核心代碼
用戶管理控制層
@Controller
@RequestMapping("/User")
public class UserController {
@Autowired
private UserService userService;
@Autowired
private PowerService powerService;
@Autowired
private RoleService roleService;
@Autowired
private NoticeService noticeService;
@RequestMapping("/Main")
public String res(HttpServletRequest request){
String time = DateUtil.getStringToday();
request.getSession().setAttribute("time", time);
Notice notice = new Notice();
List<Notice> list = noticeService.queryAll(notice);
notice = list.get(0);
User user = userService.selectByPrimaryKey(notice.getUserid());
notice.setUserid(user.getName());
request.getSession().setAttribute("notice", notice);
return "Main";
}
@RequestMapping("/changePa")
public String res1(){
return "changePass";
}
@RequestMapping("/Login")
public ModelAndView login(HttpServletRequest request,String id,String password) throws Exception{
ModelAndView mav = new ModelAndView();
User user1 = userService.selectByPrimaryKey(id);
if(user1 == null || !password.equals(user1.getPassword())){
mav.setViewName("index");
request.getSession().setAttribute("info", "error");
return mav;
}else{
Role role = new Role();
role.setRoleid(user1.getRoleid());
List<Role> list =roleService.QueryAll(role);
role =list.get(0);
request.getSession().setAttribute("roleName", role.getRolename());
Power power = powerService.selectByPrimaryKey(role.getPowerid());
if(!StringUtil.isNullOrEmpty(power.getPower())){
request.getSession().setAttribute("power", power.getPower());
}
String time = DateUtil.getStringToday();
request.getSession().setAttribute("time", time);
request.getSession().setAttribute("user", user1);
mav.setViewName("redirect:/User/Main");
}
return mav;
}
@RequestMapping("/updateStudent")
public String update(User user){
userService.updateByPrimaryKey(user);
return "redirect:/User/student";
}
@RequestMapping("/updateTeacher")
public String updatet(User user){
userService.updateByPrimaryKey(user);
return "redirect:/User/teacher";
}
@RequestMapping("/updatePa")
public String updatePa(String userID,String password){
User user = new User();
System.out.println(userID);
User user1 = userService.selectByPrimaryKey(userID);
user1.setPassword(password);
userService.updateByPrimaryKey(user1);
return "Main";
}
@RequestMapping("/delete")
public String delete(String ID){
userService.deleteByPrimaryKey(ID);
return "redirect:/User/queryAll";
}
@RequestMapping("/teacher")
public String QueryAllTeacher(HttpServletRequest request,User user){
List<User> list = userService.QueryAllTeacher(user);
request.setAttribute("list", list);
if(null != user.getName()){
request.setAttribute("name", user.getName());
}
if(null != user.getMobile()){
request.setAttribute("mobile", user.getMobile());
}
return "teacher";
}
@ResponseBody
@RequestMapping("/jsonteacher")
public String QueryAllTeacherjson(HttpServletRequest request,User user){
List<User> list = userService.QueryAllTeacher(user);
JSONObject json = new JSONObject();
return json.toJSONString(list);
}
@RequestMapping("/student")
public String QueryAllStudent(HttpServletRequest request,User user){
List<User> list = userService.QueryAllStudent(user);
request.setAttribute("list", list);
if(null != user.getName()){
request.setAttribute("name", user.getName());
}
if(null != user.getMobile()){
request.setAttribute("mobile", user.getMobile());
}
return "student";
}
@RequestMapping("/addteacher")
public String addUser(User user){
String passWord = "123456";
user.setPassword(passWord);
user.setType(Constans.TEACHER);
userService.insert(user);
return "redirect:/User/teacher";
}
@RequestMapping("/addstudent")
public String addStudent(User user){
String passWord = "123456";
user.setPassword(passWord);
user.setType(Constans.STUDENT);
userService.insert(user);
return "redirect:/User/student";
}
@ResponseBody
@RequestMapping("/queryOne")
public String queryOne(String ID){
User user = new User();
user.setId(ID);
List<User> list = userService.QueryAll(user);
user = list.get(0);
JSONObject json = new JSONObject();
String data = json.toJSONString(user);
return data;
}
@RequestMapping("/quit")
public ModelAndView quit(HttpServletRequest request) throws Exception{
ModelAndView mav = new ModelAndView();
HttpSession session1 = request.getSession();
session1.invalidate();
request.getSession().setAttribute("info", "quit");
mav.setViewName("index");
return mav;
}
}排課控制層
@Controller
@RequestMapping("/Course")
public class CourseController {
@Autowired
private CourseService courseService;
@Autowired
private CurelationService curelationService;
@Autowired
private CoursecommentService coursecommentService;
@ResponseBody
@RequestMapping("/queryOneCom")
public String queryOneCom(String ID){
Coursecomment course = new Coursecomment();
course.setId(ID);
System.out.println("===================================="+ID);
List<Coursecomment> list = coursecommentService.queryAll(course);
course = list.get(0);
JSONObject json = new JSONObject();
return json.toJSONString(course);
}
@RequestMapping("addComment")
public String addComment(HttpServletRequest request, Coursecomment coursecomment){
User user = (User) request.getSession().getAttribute("user");
coursecomment.setCreatetime(DateUtil.getStringToday());
coursecomment.setUserid(user.getName());
coursecomment.setId(String.valueOf(Math.random()).substring(2,10));
coursecommentService.insert(coursecomment);
return "redirect:/Course/suggeetion";
}
@ResponseBody
@RequestMapping("jsoncourse")
public String jsoncourse(HttpServletRequest request, Curelation course){
User user = (User) request.getSession().getAttribute("user");
/*String type = "1";
if ("1".equals(user.getType())){
type="2";
}
course.setType(type);
course.setUserid(user.getId());*/
List<Curelation> curelationList = curelationService.queryAll(course);
List<Course> dataList = new ArrayList<>();
for (int i = 0; i < curelationList.size(); i++) {
Course curelation = courseService.selectByPrimaryKey(curelationList.get(i).getCourseid());
dataList.add(curelation);
}
JSONObject json = new JSONObject();
return json.toJSONString(dataList);
}
@RequestMapping("suggeetion")
public String suggeetion(HttpServletRequest request, Coursecomment coursecomment){
List<Coursecomment> coursecomments = coursecommentService.queryAll(coursecomment);
request.setAttribute("list",coursecomments);
return "suggeetion";
}
@RequestMapping("view")
public String view(HttpServletRequest request){
User user = (User) request.getSession().getAttribute("user");
String type = "1";
if ("1".equals(user.getType())){
type="2";
}
List<Map<String,String>> list=curelationService.courseview(type,user.getId());
request.setAttribute("list",list);
return "courseview";
}
@RequestMapping("deletecomment")
public String deletecomment(String ID){
coursecommentService.deleteByPrimaryKey(ID);
return "redirect:/Course/suggeetion";
}
@RequestMapping("queryAll")
public String queryAll(HttpServletRequest request, Course course){
List<Course> list = courseService.queryAll(course);
request.setAttribute("list",list);
return "course";
}
@RequestMapping("/receive")
public String receive(HttpServletRequest request, HttpServletResponse response, MultipartFile file){
try {
//也可以用request獲取上傳文件
//MultipartFile fileFile = request.getFile("file"); //這里是頁(yè)面的name屬性
//轉(zhuǎn)換成輸入流
InputStream is = file.getInputStream();
//得到excel
Workbook workbook = Workbook.getWorkbook(is);
//得到sheet
Sheet sheet = workbook.getSheet(0);
//得到列數(shù)
int colsNum = sheet.getColumns();
//得到行數(shù)
int rowsNum = sheet.getRows();
//單元格
Cell cell;
Cell cell1;
List<Map> list = new ArrayList<>();
Map<Integer, String> map = new HashMap<Integer, String>();
for (int i = 1; i < rowsNum; i++) {//我的excel第一行是標(biāo)題,所以 i從1開(kāi)始
cell = sheet.getCell(0,i);
cell1 = sheet.getCell(5,i);
Curelation curelation = new Curelation();
curelation.setId(cell.getContents());
curelation.setScore(cell1.getContents());
curelationService.updateByPrimaryKey(curelation);
}
} catch (IOException e) {
e.printStackTrace();
} catch (BiffException e) {
e.printStackTrace();
}
return "redirect:/Course/queryCourse";
}
@RequestMapping("/queryCourse")
public String queryScore(HttpServletRequest request,Curelation curelation){
curelation.setType("1");
List<Curelation> list = curelationService.queryAll(curelation);
request.setAttribute("list",list );
return "ScoreList";
}
@RequestMapping("/teacher")
public String teacher(HttpServletRequest request){
User user = (User) request.getSession().getAttribute("user");
Course course = new Course();
course.setCourseteacher(user.getName());
List<Course> courseList = courseService.queryAll(course);
request.setAttribute("list",courseList);
return "teacherDeal";
}
@RequestMapping("/student")
public String student(HttpServletRequest request){
Course course = new Course();
course.setStatus("1");
List<Course> courseList = courseService.queryAll(course);
request.setAttribute("list",courseList);
return "studentChoose";
}
@RequestMapping("/upload")
public String upload(){
return "uploadScore";
}
@RequestMapping("/Export")
public void Export(HttpServletResponse response, User user){
response.setContentType("application/binary;charset=UTF-8");
try {
ServletOutputStream out = response.getOutputStream();
String fileName1 = "學(xué)生信息";
String fileName2 = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss").format(new Date());
String fileName = fileName1+fileName2;
response.setHeader("Content-disposition", "attachment; filename=" +new String(fileName.getBytes("gbk"),"iso8859-1") + ".xls");
String[] titles = { "成績(jī)編號(hào)","學(xué)生編號(hào)", "學(xué)生姓名", "課程編號(hào)", "課程名稱(chēng)", "成績(jī)" };
courseService.export(titles, out,user);
} catch (Exception e) {
e.printStackTrace();
}
}
@RequestMapping("delete")
public String delete(String ID){
courseService.deleteByPrimaryKey(ID);
return "redirect:/Course/queryAll";
}
@RequestMapping("update")
public String update(Course course){
courseService.updateByPrimaryKey(course);
return "redirect:/Course/queryAll";
}
@Transactional
@RequestMapping("update1")
public String update1(HttpServletRequest request,Course course){
course.setStatus("1");
courseService.updateByPrimaryKey(course);
User user = (User) request.getSession().getAttribute("user");
Curelation curelation1 = new Curelation();
curelation1.setCourseid(course.getId());
curelation1.setUserid(user.getId());
List<Curelation> curelationList = curelationService.queryAll(curelation1);
if(curelationList.size()==0){
Curelation curelation = new Curelation();
curelation.setUserid(user.getId());
curelation.setCourseid(course.getId());
curelation.setId(String.valueOf(Math.random()).substring(2, 10));
curelation.setType("2");
curelationService.insert(curelation);
}
return "redirect:/Course/teacher";
}
@RequestMapping("update2")
public String update2(HttpServletRequest request,Course course){
User user = (User) request.getSession().getAttribute("user");
Curelation curelation = new Curelation();
curelation.setUserid(user.getId());
curelation.setCourseid(course.getId());
List<Curelation> curelationList = curelationService.queryAll(curelation);
if(curelationList.size() == 0){
curelation.setId(String.valueOf(Math.random()).substring(2, 10));
curelation.setType("1");
curelationService.insert(curelation);
}else{
Curelation curelation1 = curelationList.get(0);
curelation1.setUserid(user.getId());
curelation1.setCourseid(course.getId());
System.out.println(curelation1.toString());
curelationService.updateByPrimaryKey(curelation1);
}
return "redirect:/Course/student";
}
@ResponseBody
@RequestMapping("/queryOne")
public String queryOne(String ID){
Course course = new Course();
course.setId(ID);
List<Course> list = courseService.queryAll(course);
course = list.get(0);
JSONObject json = new JSONObject();
return json.toJSONString(course);
}
@RequestMapping("add")
public String addCourse(Course course){
course.setId(String.valueOf(Math.random()).substring(2, 10));
System.out.println(course.toString());
courseService.insert(course);
return "redirect:/Course/queryAll";
}
}公告控制層
@Controller
@RequestMapping("/Notice")
public class NoticeController {
@Autowired
private NoticeService noticeService;
@RequestMapping("/add")
public String toAdd(){
return "NoticeAdd";
}
@RequestMapping("/modify")
public String modify(HttpServletRequest request,Notice notice){
List<Notice> noticeList = noticeService.queryAll(notice);
request.setAttribute("list",noticeList);
return "noticeModfiy";
}
@RequestMapping("/update")
public String update(HttpServletRequest request,Notice notice){
User user = (User) request.getSession().getAttribute("user");
notice.setUserid(user.getId());
notice.setCreatdate(DateUtil.getStringToday());
noticeService.update(notice);
return "redirect:/Notice/modify";
}
@RequestMapping("/delete")
public String delete(HttpServletRequest request,Notice notice){
List<Notice> noticeList = noticeService.queryAll(notice);
request.setAttribute("list",noticeList);
return "noticeDelete";
}
@RequestMapping("/delete1")
public String delete1(String ID){
noticeService.delete(ID);
return "redirect:/Notice/delete";
}
@ResponseBody
@RequestMapping("/queryOne")
public String queryOne(String id){
System.out.println("=================="+id);
Notice notice = new Notice();
notice.setId(id);
List<Notice> noticeList = noticeService.queryAll(notice);
JSONObject json = new JSONObject();
return json.toJSONString(noticeList.get(0));
}
@RequestMapping("/add1")
public String add(HttpServletRequest request,String Content,String biaoti) throws Exception{
User user = (User) request.getSession().getAttribute("user");
Notice notice = new Notice();
notice.setContent(Content);
notice.setTitle(biaoti);
notice.setCreatdate(DateUtil.Date2String(new Date()));
notice.setId(String.valueOf(Math.random()).substring(2, 8));
notice.setUserid(user.getId());
noticeService.add(notice);
return "redirect:/User/Main";
}
}角色控制層
@Controller
@RequestMapping("/Role")
public class RoleController {
@Autowired
private RoleService depotService;
@Autowired
private PowerService powerService;
@RequestMapping("/update")
public String update(String id,String rolename,String powerContent){
Role role = new Role();
role.setRoleid(id);
role.setRolename(rolename);
depotService.update(role);
List<Role> list = depotService.QueryAll(role);
Role role1 = list.get(0);
Power power = new Power();
if(powerContent.indexOf("110") != -1){
powerContent = powerContent + ",1100";
}
if(powerContent.indexOf("120") != -1){
powerContent = powerContent + ",1200";
}
if(powerContent.indexOf("130") != -1){
powerContent = powerContent + ",1300";
}
if(powerContent.indexOf("140") != -1){
powerContent = powerContent + ",1400";
}
if(powerContent.indexOf("150") != -1){
powerContent = powerContent + ",1500";
}
power.setPower(powerContent);
power.setRoleid(role1.getPowerid());
powerService.update(power);
return "redirect:/Role/queryAll";
}
@RequestMapping("/delete")
public String delete(String ID){
depotService.deleteByPrimaryKey(ID);
return "redirect:/Role/queryAll";
}
@RequestMapping("/queryAll")
public String queryAll(HttpServletRequest request,Role role){
List<Role> list = depotService.QueryAll(role);
request.setAttribute("list", list);
if(null != role.getRolename()){
request.setAttribute("rolename", role.getRolename());
}
return "Role";
}
@RequestMapping("/add")
public String add(String roleid,String rolename,String powerContent){
Power power1 = new Power();
Role role = new Role();
String powerid = String.valueOf(Math.random()).substring(2, 8);
role.setRoleid(String.valueOf(Math.random()).substring(2, 6));
role.setPowerid(powerid);
role.setRolename(rolename);
power1.setPower(powerContent);
power1.setRoleid(powerid);
power1.setId(String.valueOf(Math.random()).substring(2, 8));
powerService.insert(power1);
depotService.insert(role);
return "redirect:/Role/queryAll";
}
@ResponseBody
@RequestMapping("/queryOne")
public String queryOne(String ID){
JSONObject json = new JSONObject();
Role depot = new Role();
Power power = new Power();
power.setId(ID);
System.out.println(ID);
depot.setRoleid(ID);
List<Role> list = depotService.QueryAll(depot);
Role role1 = list.get(0);
Power power1 = powerService.selectByPrimaryKey(role1.getPowerid());
String name = role1.getRolename();
role1.setPowerid(power1.getPower());
String data = json.toJSONString(role1);
return data;
}
@ResponseBody
@RequestMapping("/getAll")
public String getAll(Role role){
JSONObject json = new JSONObject();
List<Role> list = depotService.QueryAll(role);
String jsonq = json.toJSONString(list);
System.out.println(jsonq);
return jsonq;
}
}以上就是Java實(shí)戰(zhàn)之課程信息管理系統(tǒng)的實(shí)現(xiàn)的詳細(xì)內(nèi)容，更多關(guān)于Java課程管理系統(tǒng)的資料請(qǐng)關(guān)注腳本之家其它相關(guān)文章！
您可能感興趣的文章:
- java實(shí)現(xiàn)人員信息管理系統(tǒng)
- Java畢業(yè)設(shè)計(jì)實(shí)戰(zhàn)之共享租車(chē)信息管理系統(tǒng)的實(shí)現(xiàn)
- Java畢業(yè)設(shè)計(jì)實(shí)戰(zhàn)之藥店信息管理系統(tǒng)的實(shí)現(xiàn)
- java+sqlserver實(shí)現(xiàn)學(xué)生信息管理系統(tǒng)
- Java?實(shí)戰(zhàn)項(xiàng)目之學(xué)生信息管理系統(tǒng)的實(shí)現(xiàn)流程
- 用java實(shí)現(xiàn)學(xué)生信息管理系統(tǒng)
相關(guān)文章
這篇文章主要介紹了activiti獲取流程圖的方法,需要的朋友可以參考下2014-08-08
代理模式:JAVA靜態(tài)代理和動(dòng)態(tài)代理的實(shí)例和實(shí)現(xiàn)詳解
這篇文章主要給大家介紹了關(guān)于Java靜態(tài)代理和動(dòng)態(tài)代理的相關(guān)資料，文中通過(guò)示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧2021-08-08
SpringBoot+Vue項(xiàng)目打包部署完整步驟教程
這篇文章主要介紹了SpringBoot+Vue項(xiàng)目打包部署的相關(guān)資料,包括Vue項(xiàng)目的打包設(shè)置、SpringBoot的配置修改、跨域問(wèn)題處理、使用Nginx配置反向代理以及最終的項(xiàng)目啟動(dòng),教程假定開(kāi)發(fā)者已具備完整的前后端分離項(xiàng)目和配置好環(huán)境的服務(wù)器,需要的朋友可以參考下2024-10-10
通過(guò)實(shí)例解析Java class文件編譯加載過(guò)程
這篇文章主要介紹了通過(guò)實(shí)例解析Java class文件編譯加載過(guò)程,文中通過(guò)示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友可以參考下2020-07-07
SpringBoot+Docker+IDEA實(shí)現(xiàn)一鍵構(gòu)建+推送、運(yùn)行、同鏡像多容器啟動(dòng)
這篇文章主要介紹了SpringBoot+Docker+IDEA實(shí)現(xiàn)一鍵構(gòu)建+推送、運(yùn)行、同鏡像多容器啟動(dòng),文中通過(guò)示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧2021-04-04
Java基本數(shù)據(jù)類(lèi)型存儲(chǔ)在JVM中的存儲(chǔ)位置介紹
這篇文章主要介紹了Java基本數(shù)據(jù)類(lèi)型存儲(chǔ)在JVM中的存儲(chǔ)位置,具有很好的參考價(jià)值,希望對(duì)大家有所幫助,如有錯(cuò)誤或未考慮完全的地方,望不吝賜教2023-07-07
在Java8與Java7中HashMap源碼實(shí)現(xiàn)的對(duì)比
這篇文章主要介紹了在Java8與Java7中HashMap源碼實(shí)現(xiàn)的對(duì)比,內(nèi)容包括HashMap 的原理簡(jiǎn)單介紹、結(jié)合源碼在Java7中是如何解決hash沖突的以及優(yōu)缺點(diǎn)，結(jié)合源碼以及在Java8中如何解決hash沖突，balance tree相關(guān)源碼介紹，需要的朋友可以參考借鑒。2017-01-01
詳解Java如何使用集合來(lái)實(shí)現(xiàn)一個(gè)客戶信息管理系統(tǒng)
讀萬(wàn)卷書(shū)不如行萬(wàn)里路，只學(xué)書(shū)上的理論是遠(yuǎn)遠(yuǎn)不夠的，只有在實(shí)戰(zhàn)中才能獲得能力的提升，本篇文章手把手帶你用Java 集合實(shí)現(xiàn)一個(gè)客戶信息管理系統(tǒng),大家可以在過(guò)程中查缺補(bǔ)漏，提升水平2021-11-11
這篇文章主要介紹了解決kafka消息堆積及分區(qū)不均勻的問(wèn)題，具有很好的參考價(jià)值，希望對(duì)大家有所幫助。如有錯(cuò)誤或未考慮完全的地方，望不吝賜教2021-09-09
Java中redisTemplate注入失敗NullPointerException異常問(wèn)題解決
這篇文章主要介紹了Java中redisTemplate注入失敗NullPointerException異常問(wèn)題解決,文中通過(guò)示例代碼介紹的非常詳細(xì),具有一定的參考價(jià)值,感興趣的小伙伴們可以參考一下2023-08-08