access数据库中:
假设有表works,其中的属性workid,methods,bankid,na等
又有表works2,有属性workid,methods,bankid等现小弟想从works2中选出methods,bankid,插入到works,不知道怎么写,老写不对,请各位大虾帮帮忙,有点急...
假设有表works,其中的属性workid,methods,bankid,na等
又有表works2,有属性workid,methods,bankid等现小弟想从works2中选出methods,bankid,插入到works,不知道怎么写,老写不对,请各位大虾帮帮忙,有点急...
解决方案 »
- jquery append出错
- SSH2连接多个数据库怎样配置啊?求xml具体配置
- 为什么一个页面单独执行没错误,但通过链接过去就出错了
- 导数据问题,高分,先给100!不够再加
- 新手问题,如何做个登陆的界面!在线等待!!!
- 【新手请教】SSH+EasyUI项目报错:No result defined for action and result
- 中文插库的问题!!!
- 呵呵,小不点有个小问题不明白,大家帮帮忙好吗?
- jsp 里面的 特殊字符“单引号”“双引号”的替换??(高分求解)
- 求推荐Java web 方面的书。
- 有懂ajax的嘛?
- 求助!!! debug 一个servlet的时候出现这样的错误是什么原因?
insert into works (workid,methods,bankid) select workid,methods,bankid from works2
insert into ...select .. .from .....
这是最基本的SQL语句 。
那循环条件用什么,好像不好写...
<jsp:useBean id="DBconn" class="Bean.conn.DBconn" scope="page"/>
...String sql="select workid from works";
ResultSet rs=DBconn.executeQuery(sql);
while(rs.next()){
int workid=rs.getInt("workid");
String sql2="select workid from works2 where workid="+workid;
ResultSet rs2=DBconn.executeQuery(sql2);
rs2.next();}
<jsp:useBean id="DBconn" class="Bean.conn.DBconn" scope="page"/>
...String sql="select workid from works";
ResultSet rs=DBconn.executeQuery(sql);
while(rs.next()){
int workid=rs.getInt("workid");
String sql2="select workid from works2 where workid="+workid;
ResultSet rs2=DBconn.executeQuery(sql2);
rs2.next();
String bankid=rs2.getString("bankid");
String methods=rs2.getString("methods");String sql3="insert into works(bankid,methods) values('"+bankid+"','"+methods+"')";
DBconn.executeUpdate(sql3);
}
楼上的兄弟们要是能实现,循环条件用什么???不好意思,小弟是菜鸟来着
String sql="select methods,banks from works";
ResultSet rs=DBconn.executeQuery(sql);
while(rs.next()){
int methods=rs.getInt("methods");
int bankid = rs.getInt("bankid");String sql1="insert into works(bankid,methods) values('"+bankid+"','"+methods+"')";
DBconn.executeUpdate(sql1);