UPDATE `demossmtest`.`orders` 
SET 
`name` = '电脑AS', 
`foondname` = '华为OS', 
`ordertime` = '2022.6.9',
 `count` = 3456, 
`price` = 3452.09,
 `amount` = 1234.09 
WHERE 
`id` = 6

//    定义方法修改页面 转入参数id
        function update(id) {
            confirm("开始修改页面信息")
            alert("请用户开始操作页面即将跳到修改的数据页面")
            location.href = "update1.do?id=" + id;
        }

<script src="js/jquery-3.2.1.min.js"></script>
    <script>
        $(function () {
            $.ajax({
                url: "Update2.do",
                type: "GET",
                data: "",
                //将所有的修改的值展示到表格中
                success: function (json) {
                    $("input[name='name']").val(json.name)
                    $("input[name='foondname']").val(json.foondname)
                    $("input[name='price']").val(json.price)
                    $("input[name='count']").val(json.count)
                    $("input[name='ordertime']").val(json.ordertime)
                    $("input[name='amount']").val(json.amount)
                },
                error: function () {
                    alert("连接数据库失败")
                },
                dataType: "json"
            })
        })
    </script>

<div align="center">
    <h1>淘宝页面修改页面的内容管理</h1>
    <form action="update3.do" method="get">
        <table>
            <tr>
                <td>用户名:</td>
                <td><input type="text" name="name"></td>
            </tr>
            <tr>
                <td>商品名称:</td>
                <td><input type="text" name="foondname"></td>
            </tr>
            <tr>
                <td>商品单价:</td>
                <td><input type="text" name="price"></td>
            </tr>
            <tr>
                <td>商品数量:</td>
                <td><input type="number" name="count"></td>
            </tr>
            <tr>
                <td>订单更新时间:</td>
                <td><input type="text" name="ordertime"></td>
            </tr>
            <tr>
                <td>金额</td>
                <td><input type="text" name="amount"></td>
            </tr>
            <tr>
                <th colspan="2"><input type="submit" value="完成修改信息"></th>
            </tr>
        </table>
    </form>
</div>

@RequestMapping("/update3.do")
    public String update3(
                          @RequestParam String name,
                          @RequestParam String foondname,
                          @RequestParam String ordertime,
                          @RequestParam int count,
                          @RequestParam double price,
                          @RequestParam double amount,
                          HttpSession  session) {
        Map<String, Object> map = new HashMap<>();
        int id = (int) session.getAttribute("id");
        map.put("id",id);
        map.put("name",name);
        map.put("foondname",foondname);
        map.put("ordertime",ordertime);
        map.put("count",count);
        map.put("price", price);
        map.put("amount",amount);
        int i = service.update3(map);
        return "Service.html";
    }

package Com.Orders.Service;
import java.util.List;
import java.util.Map;
/**
 * 业务逻辑层的接口
 */
public interface IOrderService {
    List<Map<String, String>> getList();
    Map<String, Object> update2(int id);
    int update3(Map<String, Object> map);
}

@Override
    public int update3(Map<String, Object> map) {
        return dao.update3(map);
    }

@Update("UPDATE `demossmtest`.`orders` SET  name = #{name}, foondname = #{foondname}, ordertime = #{ordertime}, count = #{count}, price = #{price}, amount =#{amount} where id = #{id}")
    int update3(Map<String, Object> map)

@Update("UPDATE `demossmtest`.`orders` SET  name = #{name}, foondname = #{foondname}, ordertime = #{ordertime}, count = #{count}, price = #{price}, amount =#{amount} where id = #{id}")
    int update3(Map<String, Object> map);