表结构:TCUSTOMER
--------------------表一
cust_no web_id200601 null
200602 null
200603 null
TORDETAIL
--------------------表二
cust_no order_no200603 0301
200604 0302
200605 0303cust_no = request.getParameter("cust_no");//接收cust_no编号
String order_no = request.getParameter("order_no");//接收order_no号码
String web_id = request.getParameter("web_id");//接收用户名dataObj.setCust_no(cust_no);
dataObj.setOrder_no(order_no);
dataObj.setWeb_id(web_id);
UPDATE TCUSTOMER A SET \n"
+ " A.WEB_ID = ? , \n"
+ " WHERE A.CUST_NO IN (SELECT A.CUST B.CUST B.ORDER_NO FROM TCUSTOMER A,TORDERDETAIL B WHERE A.CUST_NO= ? AND B.CUST_NO = ? AND B.ORDER_NO = ?)pstmt.setString(1,mDo.getWeb_id());
pstmt.setString(2,mDo.getCust_no());
pstmt.setString(3,mDo.getCust_no());
pstmt.setString(4,mDo.getOrder_no());
在更新用户的web_id字段时候,在表一里面能找到,而且在第二个表里面也能找到,并且cust_no和order_no都能,是不是这样写的呢?
--------------------表一
cust_no web_id200601 null
200602 null
200603 null
TORDETAIL
--------------------表二
cust_no order_no200603 0301
200604 0302
200605 0303cust_no = request.getParameter("cust_no");//接收cust_no编号
String order_no = request.getParameter("order_no");//接收order_no号码
String web_id = request.getParameter("web_id");//接收用户名dataObj.setCust_no(cust_no);
dataObj.setOrder_no(order_no);
dataObj.setWeb_id(web_id);
UPDATE TCUSTOMER A SET \n"
+ " A.WEB_ID = ? , \n"
+ " WHERE A.CUST_NO IN (SELECT A.CUST B.CUST B.ORDER_NO FROM TCUSTOMER A,TORDERDETAIL B WHERE A.CUST_NO= ? AND B.CUST_NO = ? AND B.ORDER_NO = ?)pstmt.setString(1,mDo.getWeb_id());
pstmt.setString(2,mDo.getCust_no());
pstmt.setString(3,mDo.getCust_no());
pstmt.setString(4,mDo.getOrder_no());
在更新用户的web_id字段时候,在表一里面能找到,而且在第二个表里面也能找到,并且cust_no和order_no都能,是不是这样写的呢?
pstmt.setString(1,mDo.getWeb_id());
pstmt.setString(2,mDo.getCust_no());
pstmt.setString(3,mDo.getCust_no());
pstmt.setString(4,mDo.getOrder_no());