必须在同一数据库的另一个SQL表中更新一个表中的产品ID [英] product ID from one table must be updated in another SQL table of same database

问题描述

**下面是我在jsp文件中的代码**

**Below is my code in my jsp file**

<table class="table" style="width:30%;">
        <tr > <td>
        <div class="dropdown">

< button class =btn btn-default dropdown-toggletype =buttonid =dropdownMenu1data-toggle =dropdown aria-expanded =true>

选择产品



< /按钮>

<％for（RecipieProductAllergen app1：RecipieProductAllergen）{

％>


• 
  
  
  
  < c：url value =recipie.jspvar = displayURLxmlns：c =＃unknown>
  
  < c：param name =ProdIDvalue =$ {param.Name}>
  
  
  
  
  
  ><％= app1.getProdID（）％><％= app1.getProdName（）％>
<％}％>






<button class="btn btn-default dropdown-toggle" type="button" id="dropdownMenu1" data-toggle="dropdown" aria-expanded="true">
Select product

</button>



<% for(RecipieProductAllergen app1:RecipieProductAllergen) {
%>

• 
  
  <c:url value="recipie.jsp" var="displayURL" xmlns:c="#unknown">
  <c:param name="ProdID" value="${param.Name}">
  
  
  ><%= app1.getProdID() %><%= app1.getProdName() %>
<%}%>


推荐答案

{param.Name}>





><％= app1.getProdID（）％><％= app1.getProdName（）％> <％}％>



{param.Name}">


><%= app1.getProdID() %><%= app1.getProdName() %> <%}%>





如果我理解你的问题，那么这就是你想做的 -

您有两个网页，其中第一个包含项目名称（下拉框）

第二个网页包含一些其他字段，您接受与第一个网页中所选产品相关的用户值

现在你要保存数据库表中的第二页字段以及在第一页中选择的产品的产品ID



如果这是正确的那么这是我的建议

1）在Index_Change甚至Product下拉框中编写代码以从数据库获取产品ID并将该Id存储到cookie中

2导航到第二页并将所有字段以及来自cookie的id存储到数据库表中



-

RDBurmon
有意义

如果是，那么请接受并且投票我的解决方案

If I understand your problem correctly then here is what you want to do -
You have two web pages where first one contains project name (drop down box)
Second web page contains some other fields where you are accepting values from user related to the product selected in first web page
Now you want to save second page fields in database table along with product id of product selected in first page

If this is correct then here is my suggestion
1) Write code on "Index_Change" even of "Product" drop down box to get the product id from database and store that Id into cookie
2) Navigate to second page and store all fields along with id from cookie into database table

--
RDBurmon
Make sense
If yes then please accept and vote my solution




这篇关于必须在同一数据库的另一个SQL表中更新一个表中的产品ID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！