Medicine management system based on ssm+mysql+jquery

home page

User query

Operator information query

Customer entry

Browse customer information

Information view

Drug information inquiry

Customer information

User management

Operator data report

Customer number

home page

Technical description

development tool ： Idea/Eclipse
database ： mysql
Jar Warehouse ： Maven
Front frame ：jquery/Jsp
Back end framework ： Spring+SpringMVC+Mybatis

Information note

be based on SSM+MySQL+JQuery Medical management system , Divided into administrators , agent , Customers and other roles , Assign different menu interfaces . The overall function includes customer management , The operator manages , Drug information inquiry , Delete drug information , modify , Data reports , User management, etc .

package mms.controller;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;

import mms.pojo.Agency;
import mms.pojo.EasyUIResult;
import mms.services.AgencyService;

@RequestMapping("Agency")
@Controller
public class AgencyController {
	//  agent controller
	@Autowired
	private AgencyService agencyService;

	//  adopt ano Query a single handler 
	@RequestMapping("GetAgency")
	@ResponseBody
	public Agency queryAgencyByAno(String ano) {
		Agency agency = agencyService.queryAgencyByAno(ano);
		return agency;
	}

	@RequestMapping(value = "DeleteAgency", produces = "text/html;charset=UTF-8")
	@ResponseBody
	//  Delete by number 
	public String deleteAgencyByAno(String ano) {
		return agencyService.deleteAgencyByAno(ano);
	}

	//  Batch deletion 
	@RequestMapping(value = "DeleteRows", produces = "text/html;charset=UTF-8")
	@ResponseBody
	public String deleteAgencyByRows(@RequestParam(value = "array[]") String[] array) {
		try {
			return agencyService.deleteAgencyByRows(array);
		} catch (Exception e) {
			// TODO: handle exception
			//  Capture exception ,spring Perform transaction rollback 
			return " Abnormal operation ,, Some operators have processed customer information , The handler cannot be deleted , Please reselect ";
		}

	}

	//  Modify the operator information 
	@RequestMapping(value = "ModifyAgency", produces = "text/html;charset=UTF-8")
	@ResponseBody
	public String modifyAgency(Agency agency) {
		return agencyService.modifyAgency(agency);
	}

	// easyui The data table is returned to all operators json
	@RequestMapping("GetMessage")
	@ResponseBody
	public EasyUIResult queryAllAgency(@RequestParam(value = "page", defaultValue = "1") Integer page,
			@RequestParam(value = "rows", defaultValue = "5") Integer rows) {
		return this.agencyService.queryAllAgency(page, rows);
	}

	//  Save the handler information 
	@RequestMapping(value = "SaveAgency", produces = "text/html;charset=UTF-8")
	@ResponseBody
	public String saveAgency(Agency agency) {
		return agencyService.saveAgency(agency);
	}

	//  Return to all handlers 
	@RequestMapping("GetAllAgency")
	@ResponseBody
	public java.util.List<Agency> getAllAgency() {
		java.util.List<Agency> allAgency = agencyService.getAllAgency();
		return allAgency;
	}
}

@RequestMapping("Client")
@Controller
public class ClientController {
	//  customer controller
	@Autowired
	//  Inject service
	private ClientService clientService;

	//  Search by number 
	@RequestMapping("GetClient")
	@ResponseBody
	public Client queryClientBycno(String cno) {
		Client client = clientService.queryClientBycno(cno);
		return client;
	}

	//  Delete by number 
	@RequestMapping("DeleteClient")
	@ResponseBody
	public void deleteClientBycno(String cno) {
		clientService.deleteClientBycno(cno);
	}
//	 Batch deletion 
	@RequestMapping(value = "DeleteRows", produces = "text/html;charset=UTF-8")
	@ResponseBody
	public String deleteClientByRows(
			@RequestParam(value = "array[]") String[] array) {
		return clientService.deleteClientByRows(array);
		
//		clientService.deleteClientBycno(cno);
	}

	//  Keep customer information 
	@RequestMapping(value = "SaveClient", produces = "text/html;charset=UTF-8")
	@ResponseBody
	public String saveClient(Client client) {
		return clientService.saveClient(client);
	}

	@RequestMapping("GetMessage")
	@ResponseBody
	// easyui return json
	public EasyUIResult queryAllClient(@RequestParam(value = "page", defaultValue = "1") Integer page,
			@RequestParam(value = "rows", defaultValue = "5") Integer rows) {
		EasyUIResult queryAllClient = clientService.queryAllClient(page, rows);
		return queryAllClient;
	}

	//  Modify customer information 
	@RequestMapping(value = "ModifyClient", produces = "text/html;charset=UTF-8")
	@ResponseBody
	public String modifyClient(Client client) {
		return clientService.modifyClient(client);
	}
}