基于javaweb+jsp的药店医药信息管理系统(JavaWeb MySQL JSP Bootstrap Servlet SSM SpringBoot)

最新推荐文章于 2024-04-11 08:45:00 发布

m0_70229483

最新推荐文章于 2024-04-11 08:45:00 发布

阅读量552

点赞数

文章标签： java mysql

本文链接：https://blog.csdn.net/m0_70229483/article/details/124440944

版权

基于javaweb+jsp的药店医药信息管理系统(JavaWeb MySQL JSP Bootstrap Servlet SSM SpringBoot)

JavaWeb JavaBean JSP MVC MySQL Tomcat JavaScript Bootstrap.

基础JSP+Servlet或JSP+SSM(Spring、SpringMVC、MyBatis)框架或JSP+SSM+Maven(pom.xml)框架或SpringBoot…均可修改

开发工具：eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

            <tr>
                <td width="12%">身份证：</td><td><input class="index-content-table-td-add" type="text" id="employeeIdno" name="employeeIdno" value=""/></td>
            </tr>
            <tr>
                <td width="12%">职位：</td><td><input class="index-content-table-td-add" type="text" id="employeePosition" name="employeePosition" value=""/></td>
            </tr>
            <tr>
                <td width="12%">入职时间：</td><td><input class="index-content-table-td-add" type="text" id="employeeIntime" name="employeeIntime" value=""/></td>
            </tr>
            <tr>
                    <td width="12%">备注：</td><td><textarea id="employeeText" name="employeeText" style="width: 60%; height: 100px;padding: 0px 17px;" placeholder="请输入内容......"></textarea></td>
            </tr>
        </table>
        <br>

    /**
     * 删除公告
     *
     * @param response
     * @param request
     * @throws IOException
     */
    @RequestMapping("noticeDelete")
    public void delete(HttpServletResponse response, HttpServletRequest request) throws IOException {
        Serializable id = Util.decode(request, "id");
        noticeService.delete(Arrays.asList(id));
        this.redirectList(request, response);
    }

    /**
     * 编辑公告
     *
     * @param response
     * @param request
     * @throws IOException
     */
    @RequestMapping("noticeEdit")
    public void edit(HttpServletResponse response, HttpServletRequest request) throws IOException {
        Notice vo = new Notice();
        vo.setId(Long.valueOf(Util.decode(request, "id")));
        vo.setNoticeName(Util.decode(request, "noticeName"));
        vo.setNoticeText(Util.decode(request, "noticeText"));

import java.util.Map;

@Controller
@RequestMapping
public class UserController {

    @Autowired
    private UserService userService;

    /**
     * 增加用户
     *
     * @param response

<%@ page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8"/>
    <title>修改进货</title>
    <link rel="stylesheet" type="text/css" href="css/index.css"/>
</head>
<body>
<jsp:include page="menu.jsp"/>


    <sql id="Base_Column_List">
        `id`,`username`,`password`,`real_name`,`user_sex`,`user_phone`,`user_text`,`user_type`
    </sql>

    <!--新增-->
    <insert id="doCreate" useGeneratedKeys="true" keyColumn="id" keyProperty="id" parameterType="com.demo.vo.User">
        INSERT INTO `t_user`
        <trim prefix="(" suffix=")" suffixOverrides=",">
                    <if test ='id != null'>`id`,</if>
                    <if test ='username != null'>`username`,</if>
                    <if test ='password != null'>`password`,</if>
                    <if test ='realName != null'>`real_name`,</if>
                    <if test ='userSex != null'>`user_sex`,</if>
                    <if test ='userPhone != null'>`user_phone`,</if>
                    <if test ='userText != null'>`user_text`,</if>
                    <if test ='userType != null'>`user_type`</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
                    <if test ='id != null'>#{id},</if>
                    <if test ='username != null'>#{username},</if>
                    <if test ='password != null'>#{password},</if>
                    <if test ='realName != null'>#{realName},</if>
                    <if test ='userSex != null'>#{userSex},</if>


    <sql id="Base_Column_List">
        `id`,`medicine_name`,`medicine_no`,`medicine_price`,`medicine_producedate`,`medicine_avliabledate`,`medicine_producer`,`medicine_text`
    </sql>

    <!--新增-->
    <insert id="doCreate" useGeneratedKeys="true" keyColumn="id" keyProperty="id" parameterType="com.demo.vo.Medicine">
        INSERT INTO `t_medicine`
        <trim prefix="(" suffix=")" suffixOverrides=",">
                    <if test ='id != null'>`id`,</if>
                    <if test ='medicineName != null'>`medicine_name`,</if>
                    <if test ='medicineNo != null'>`medicine_no`,</if>
                    <if test ='medicinePrice != null'>`medicine_price`,</if>
                    <if test ='medicineProducedate != null'>`medicine_producedate`,</if>
                    <if test ='medicineAvliabledate != null'>`medicine_avliabledate`,</if>
                    <if test ='medicineProducer != null'>`medicine_producer`,</if>

        vo.setEmployeeAge(Util.decode(request, "employeeAge"));
        vo.setEmployeePhone(Util.decode(request, "employeePhone"));
        vo.setEmployeeIdno(Util.decode(request, "employeeIdno"));
        vo.setEmployeePosition(Util.decode(request, "employeePosition"));
        vo.setEmployeeIntime(Util.decode(request, "employeeIntime"));
        vo.setEmployeeText(Util.decode(request, "employeeText"));
        employeeService.update(vo);
        this.redirectList(request, response);
    }

    /**
     * 获取员工的详细信息（详情页面与编辑页面要显示该员工的详情）并跳转回页面
     *
     * @param response
     * @param request
     * @throws IOException
     */
    @RequestMapping({"employeeGet", "employeeEditPre"})

            <result column="medicine_name" property="medicineName" />
            <result column="medicine_no" property="medicineNo" />
            <result column="medicine_price" property="medicinePrice" />
            <result column="medicine_producedate" property="medicineProducedate" />
            <result column="medicine_avliabledate" property="medicineAvliabledate" />
            <result column="medicine_producer" property="medicineProducer" />
            <result column="medicine_text" property="medicineText" />
    </resultMap>

    <sql id="Base_Column_List">
        `id`,`medicine_name`,`medicine_no`,`medicine_price`,`medicine_producedate`,`medicine_avliabledate`,`medicine_producer`,`medicine_text`
    </sql>

    <!--新增-->
    <insert id="doCreate" useGeneratedKeys="true" keyColumn="id" keyProperty="id" parameterType="com.demo.vo.Medicine">
        INSERT INTO `t_medicine`
        <trim prefix="(" suffix=")" suffixOverrides=",">
                    <if test ='id != null'>`id`,</if>
                    <if test ='medicineName != null'>`medicine_name`,</if>
                    <if test ='medicineNo != null'>`medicine_no`,</if>
                    <if test ='medicinePrice != null'>`medicine_price`,</if>
                    <if test ='medicineProducedate != null'>`medicine_producedate`,</if>
                    <if test ='medicineAvliabledate != null'>`medicine_avliabledate`,</if>

        </if>
    </select>
    <!--数量-->
    <select id="getAllCount" parameterType="java.util.Map" resultType="Integer">
        SELECT COUNT(*) FROM `t_user`
        <where>
            <if test="searchColumn != null and searchColumn != '' and keyword != null and keyword != ''">
                ${searchColumn} LIKE CONCAT('%',#{keyword},'%')  AND
            </if>
            1=1
        </where>
    </select>
</mapper>
<?xml version="1.0" encoding="UTF-8"?>

import com.demo.service.UserService;
import com.demo.util.Util;
import com.demo.vo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import javax.imageio.ImageIO;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.awt.*;
import java.awt.image.BufferedImage;
import java.io.IOException;
import java.io.OutputStream;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Random;

     */
    @RequestMapping({"userGet", "userEditPre"})
    public void get(HttpServletResponse response, HttpServletRequest request) throws IOException {
        Serializable id = Util.decode(request, "id");//取出主键id
        User vo = userService.get(id);
        request.getSession().setAttribute("vo", vo);
        String to = request.getRequestURI().toLowerCase().contains("get") ? "info" : "edit";//判断是去详情显示页面还是编辑页面
        response.sendRedirect("user_" + to + ".jsp");
    }

    /**
     * 根据条件查询用户的列表并跳转回页面
     *

        DELETE FROM `t_employee` WHERE `id` IN
        <foreach collection="list" item="id" separator="," open="(" close=")">
            #{id}
        </foreach>
    </delete>

    <!--修改-->
    <update id="doUpdate" parameterType="com.demo.vo.Employee">
        UPDATE `t_employee`
        <set>
                <if test ='id != null'>`id` = #{id},</if>
                <if test ='employeeName != null'>`employee_name` = #{employeeName},</if>
                <if test ='employeeNo != null'>`employee_no` = #{employeeNo},</if>
                <if test ='employeeSex != null'>`employee_sex` = #{employeeSex},</if>
                <if test ='employeeAge != null'>`employee_age` = #{employeeAge},</if>
                <if test ='employeePhone != null'>`employee_phone` = #{employeePhone},</if>
                <if test ='employeeIdno != null'>`employee_idno` = #{employeeIdno},</if>
                <if test ='employeePosition != null'>`employee_position` = #{employeePosition},</if>
                <if test ='employeeIntime != null'>`employee_intime` = #{employeeIntime},</if>
                <if test ='employeeText != null'>`employee_text` = #{employeeText}</if>

运行环境

Java≥6、Tomcat≥7.0、MySQL≥5.5

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

技术框架

JavaWeb JavaBean JSP MVC MySQL Tomcat JavaScript Bootstrap.

基础JSP+Servlet或JSP+SSM(Spring、SpringMVC、MyBatis)框架或JSP+SSM+Maven(pom.xml)框架或SpringBoot…均可修改

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

20220319001222

20220319001223

20220319001224

20220319001225

20220319001226

20220319001227

20220319001228

20220319001229

20220319001230

20220319001231

20220319001232

document

m0_70229483

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
基于javaweb+jsp的药店医药信息管理系统(JavaWeb MySQL JSP Bootstrap Servlet SSM SpringBoot)

基于javaweb+jsp的药店医药信息管理系统(JavaWeb MySQL JSP Bootstrap Servlet SSM SpringBoot)JavaWeb JavaBean JSP MVC MySQL Tomcat JavaScript Bootstrap.基础JSP+Servlet或JSP+SSM(Spring、SpringMVC、MyBatis)框架或JSP+SSM+Maven(pom.xml)框架或SpringBoot...均可修改开发工具：eclipse/idea/myecl
复制链接

扫一扫

基于javaweb+jsp的药店医药信息管理系统(JavaWeb MySQL JSP Bootstrap Servlet SSM SpringBoot)

“相关推荐”对你有帮助么？