我從后臺把"order"這個表中的資料都提取出來了,現在打算點擊表格后的"安排"把對應行的資料插入表"deliver"中,不論什么操作都提示失敗,理由是"tel 不能為空",求各位大佬幫幫忙
JSP界面
<body>
<br><br><br>
<div class="container">
<table class="table table-bordered ">
<thead class="thead-light">
<tr>
<th>聯系方式</th>
<th>地址</th>
<th>訂購商品</th>
<th>時間</th>
<th>派送人員</th>
<th>操作</th>
</tr>
</thead>
<c:forEach var="order" items="${order}">
<tr>
<td><input type="text" class="input1" style="outline:none;cursor: pointer;border:none" id="tel" name="tel" value="https://bbs.csdn.net/topics/${order.tel}"></td>
<td><input type="text" style="outline:none;cursor: pointer;border:none" id="adress" name="adress" value="https://bbs.csdn.net/topics/${order.adress}"></td>
<td><input type="text" style="outline:none;cursor: pointer;border:none" id="type" name="type" value="https://bbs.csdn.net/topics/${order.type}"></td>
<td><input type="text" style="outline:none;cursor: pointer;border:none" id="time" name="time" value="https://bbs.csdn.net/topics/${order.time}"></td>
<td><input type="text" style="outline:none;cursor: pointer;border:none" id="num" name="num" value="https://bbs.csdn.net/topics/1號"></td>
<td>
<a href="https://bbs.csdn.net/topics/InsertServlet?param=1" target="framemain"><button>安排</button></a>
</td>
</tr>
</c:forEach>
</table>
</div>
</body>
Servlet代碼
if(param.equalsIgnoreCase("1"))
{
String tel=request.getParameter("order.tel");
String adress=request.getParameter("order.adress");
String type=request.getParameter("order.type");
String time=request.getParameter("order.time");
String num=request.getParameter("order.num");
AdminDao adminDao=new AdminDao();
int value=https://bbs.csdn.net/topics/adminDao.inset(connection,tel,adress,type,time,num);
if(value>0){
response.getWriter().print("<script language='javascript'>alert('安排成功！')</script>");
response.setHeader("refresh","0.05;URL=admmain.jsp");
}else{
response.getWriter().print("<script language='javascript'>alert('安排失敗！')</script>");
response.setHeader("refresh","0.05;URL=admmain.jsp");
}
}
Dao代碼
public int inset(Connection connection,String tel, String adress, String type, String time, String num){//派單
int value=https://bbs.csdn.net/topics/-1;
PreparedStatement statement=null;
String sql="insert into deliver(tel,adress,type,time,num) values(?,?,?,?,?)";
try{
statement=connection.prepareStatement(sql);
statement.setString(1,tel);
statement.setString(2,adress);
statement.setString(3,type);
statement.setString(4,time);
statement.setString(5,num);
value=https://bbs.csdn.net/topics/statement.executeUpdate();
}
catch (SQLException ex)
{
ex.printStackTrace();
}
finally
{
try
{
if(statement != null) statement.close();
}
catch (SQLException ex)
{
}
}
return value;
}
uj5u.com熱心網友回復：
我把界面中的InsertServlet?param=1改成InsertServlet?param=${order.tel}在網頁上看是可以正常獲取到當前行的tel的,我一度以為是獲取不到表格中的資料導致插入失敗 但是好像不是這樣的? qaq大佬們救救孩子uj5u.com熱心網友回復：
表格長這樣的
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/64158.html
標籤：其他
下一篇：求AI看面相手相分銷全套原始碼