使用JSP调用数据库进行查询和插入的问题

来源：百度知道 编辑：UC知道 时间：2024/05/09 13:41:53
我从一个表wareinfo中取出3个量,并将其插入到另一个表buylist中,并且插入的第四项为手动输入的amount1,请问这几句代码怎么写,很急!
<%
request.setCharacterEncoding("GBK");
String wareno = request.getParameter("wareno");
String amount1 = request.getParameter("amount1");
//int amount1=Integer.parseInt(A_amount1);

Connection conn = null;
Statement stmt = null;
ResultSet rs=null;
String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=chaoshi";
String loginname = "sa";
String password = "sa";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager.getConnection(url, loginname, password);

String sql1 = "select * from wareinfo where wareinfo.wareno ='"+wareno+"'";
stmt = conn.createStatement();
rs = stmt.executeQuery(sql1);

String sql2 = "insert into buylist (wareno,warename,price,amount1) values(rs

试试下面这段，应该没问题的：

<%
request.setCharacterEncoding("GBK");
String wareno = request.getParameter("wareno");
String amount1 = request.getParameter("amount1");
//int amount1=Integer.parseInt(A_amount1);

Connection conn = null;
Statement stmt = null;
ResultSet rs=null;
String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=chaoshi";
String loginname = "sa";
String password = "sa";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager.getConnection(url, loginname, password);

String sql1 = "select * from wareinfo where wareinfo.wareno ='"+wareno+"'";
stmt = conn.createStatement();
rs = stmt.executeQuery(sql1);

String sql2 = "insert into buylist (wareno,warename,price,amount1) values(" + rs.getString(1) + ","