jsp mysql 同一数据库中把一个表中的数据存入到另一个表中_jsp数据库取出数据再存入到另一个表中...

Class.forName("com.mysql.jdbc.Driver");Connectioncon=DriverManager.getConnection("jdbc:mysql://localhost:3306/library","root","zhoujie");Statementsta=con.createStatement(...

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/library","root","zhoujie");

Statement sta=con.createStatement();

String sql="select * from bookinfo where bookid='"+bookno1+"'";

ResultSet res=sta.executeQuery(sql);

while(res.next()){

String bookid=res.getString(1);

String bookname=res.getString(2);

String price=res.getString(3);

String booktime=res.getString(4);

Class.forName("com.mysql.jdbc.Driver");

Connection con1=DriverManager.getConnection("jdbc:mysql://localhost:3306/library","root","zhoujie");

Statement sta1=con1.createStatement();

String sqlq="insert into delbookmes"+

"(bookid,bookname,price,in_time,time)"+

" values('"+bookid+"','"+bookname+"','"+price+"','"+booktime+"','"+time+"')";

ResultSet coun=sta.executeQuery(sqlq);

哪错了？？？？

展开