表结构: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都能,是不是这样写的呢?
解决方案 »
- 异常信息,高手进来帮帮忙
- oracle text 创建索引报 ora:04030错误!
- 新手问改不了user_dump_dest、backgroud_dump_dest参数的问题!
- 如何从表中查询出某列的值包含“tab”字符或“回车”字符的数据
- Oracle 可以实现像SQL Server 的合并复制功能吗?
- 请问SQLCODE ,-1001代表什么错误?
- 提问!!!!!!请高手们赐教!!!!!!!!!!!!!!查询问题
- 急求解决方法,急!急!!急!!!
- 急救!
- 【求助】关于一个SQL分组合并取值的语句,如果写?请大牛给出思路
- VB.net能连接ORACLE;ASP.net却不能连接ORACLE。这是怎么回事????
- 查询条件中的1=1或1=0是什么意思?
pstmt.setString(1,mDo.getWeb_id());
pstmt.setString(2,mDo.getCust_no());
pstmt.setString(3,mDo.getCust_no());
pstmt.setString(4,mDo.getOrder_no());