Class.forName("com.mysql.jdbc.Driver");Connectioncon=DriverManager.getConnection("jdbc:mysql://localhost/lxfood","root","123456");Statementst=con.createStatement();Result...
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/lxfood","root","123456");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from orderinfo where o_userid='"+uid+"'");
while(rs.next()){
String foodname=rs.getString(3);
String foodnumber=rs.getString(5);
System.out.println(foodname+foodnumber);
Connection con1=DriverManager.getConnection("jdbc:mysql://localhost/lxfood","root","123456");
Statement st1 = con.createStatement();
int row=st1.executeUpdate("insert into sureorder(o_foodname,o_foodnumber) values('"+foodname+"','"+foodnumber+"')");}
这是我的代码,求大神指点!感激不尽!
我的意图是根据userid先从orderinfo表中查出食物和数量然后将这两项插入到sureorder表中。因为orderinfo表中根据userid能查出有很多数据,所以只能遍历,我写的执行不出来,毕业设计着急,求大神帮忙啊
展开