英文:
How can I get value from one table row using checkbox ( JSP & HTML )?
问题
productCatalog.jsp
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Product Catalog</title>
</head>
<body>
<%
String sql;
String output;
String table;
ResultSet rs;
Class.forName("org.hsqldb.jdbc.JDBCDriver");
Connection connection = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost/", "SA", "");
Statement stmt = connection.createStatement();
rs = stmt.executeQuery("SELECT * FROM PRODUCT_CATALOG");
output = "<tr><th>SELECT PRODUCT</th><th>PRODUCT ID</th><th>PRODUCT NAME</th><th>PRICE</th></tr>";
while (rs.next()) {
output += "<tr><td><input type='checkbox'></td>" +
"<td>" + rs.getString(1) + "</td>" +
"<td>" + rs.getString(2) + "</td>" +
"<td>" + rs.getString(3) + "</td></tr>";
}
table = "<html>" +
"<head>" +
"</head>" +
"<body>" +
"<div>" +
"<h1>Product Catalog</h1>" +
"<form action='invoiceTable.jsp' method='POST'>" +
"<table>" +
output +
"</table>" +
"<button onclick='history.go(-1)' type='button'>Back</button>" +
"<button type='submit'>Create invoice</button>" +
"</form>" +
"</div>" +
"</body>" +
"</html>";
out.println(table);
rs.close();
%>
</body>
</html>
invoiceTable.jsp
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Invoices</title>
</head>
<body>
<%
String sql;
String output;
String table;
ResultSet rs;
String Articles = request.getParameter("???");
String Total_price = request.getParameter("???");
Class.forName("org.hsqldb.jdbc.JDBCDriver");
Connection connection = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost/", "SA", "");
Statement stmt = connection.createStatement();
sql = "INSERT INTO INVOICES (Articles, Total_price)" +
"VALUES( '" + Articles + "', '" + Total_price + "');";
stmt.executeUpdate(sql);
rs = stmt.executeQuery("SELECT * FROM INVOICES");
output = "<tr><th>INVOICE NR.</th><th>ARTICLES</th><th>TOTAL PRICE</th></tr>";
while (rs.next()) {
output += "<tr><td>" + rs.getString(1) + "</td>" +
"<td>" + rs.getString(2) + "</td>" +
"<td>" + rs.getString(3) + "</td></tr>";
}
table = "<html>" +
"<head>" +
"</head>" +
"<body>" +
"<div>" +
"<h1>Invoices</h1>" +
"<table>" +
output +
"</table>" +
"</div>" +
"</body>" +
"</html>";
out.println(table);
rs.close();
%>
</body>
</html>
英文:
So, I'm using JSP to display in internet page data from database. I have two tables ( "Product Catalog" & "Invoices" ). I want to choose one product from table ( Product Catalog ) with help of checkbox and insert into another table ( Invoices ).
productCatalog.jsp
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Product Catalog</title>
</head>
<body>
<%
String sql;
String output;
String table;
ResultSet rs;
Class.forName("org.hsqldb.jdbc.JDBCDriver");
Connection connection = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost/", "SA", "");
Statement stmt = connection.createStatement();
rs = stmt.executeQuery("SELECT * FROM PRODUCT_CATALOG");
output = "<tr>" + "<th>SELECT PRODUCT</th>" + "<th>PRODUCT ID</th>" + "<th>PRODUCT NAME</th>" + "<th>PRICE</th></tr>";
while (rs.next()) {
output += "<tr><td><input type='checkbox'></td>" + "<td>" + rs.getString(1) + "</td>" + "<td>" + rs.getString(2) + "</td>" + "<td>" + rs.getString(3) + "</td></tr>";
}
table = "<html>"
+ "<head>"
+ "</head>"
+ "<body>"
+ "<div>"
+ "<h1>Product Catalog</h1>"
+ "<form action='invoiceTable.jsp' method='POST'>"
+ "<table>"
+ output
+ "</table>"
+ "<button onclick='history.go(-1)' type='button'>Back</button>"
+ "<button type='submit'>Create invoice</button>"
+ "</form>"
+ "</div>"
+ "</body>"
+ "</html>";
out.println(table);
rs.close();
%>
</body>
</html>
invoiceTable.jsp --- I wrote "???", because there must be data/values from table row which I selected. And I don't know which function or which parameter I must use.
String Articles = request.getParameter("???");
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Invoices</title>
</head>
<body>
<%
String sql;
String output;
String table;
ResultSet rs;
String Articles = request.getParameter("???");
String Total_price = request.getParameter("???");
Class.forName("org.hsqldb.jdbc.JDBCDriver");
Connection connection = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost/", "SA", "");
Statement stmt = connection.createStatement();
sql = "INSERT INTO INVOICES (Articles, Total_price)"
+ "VALUES( '" + Articles + "', '" + Total_price + "');";
stmt.executeUpdate(sql);
rs = stmt.executeQuery("SELECT * FROM INVOICES");
output = "<tr><th>INVOICE NR.</th>" + "<th>ARTICLES</th>" + "<th>TOTAL PRICE</th></tr>";
while (rs.next()) {
output += "<tr><td>" + rs.getString(1) + "</td>" + "<td>" + rs.getString(2) + "</td>" + "<td>" + rs.getString(3) + "</td></tr>";
}
table = "<html>"
+ "<head>"
+ "</head>"
+ "<body>"
+ "<div>"
+ "<h1>Invoices</h1>"
+ "<table>"
+ output
+ "</table>"
+ "</form>"
+ "</div>"
+ "</body>"
+ "</html>";
out.println(table);
rs.close();
%>
</body>
</html>
答案1
得分: 1
首先，您需要在productCatalog.jsp中修改以下语句：
while (rs.next()){
output += "<tr><td><input type='checkbox'></td>" + "<td>" + rs.getString(1) + "</td>" + "<td>" + rs.getString(2) + "</td>" + "<td>" + rs.getString(3) + "</td></tr>";
}
改为：
int count=0;
while (rs.next()){
output+="<tr>";
output+="<td><input type='checkbox' name='row"+(count++)+"' value="+rs.getString(1)+","+rs.getString(2)+","+rs.getString(3)+"></td>";
output+="<td>" + rs.getString(1) + "</td>";
output+="<td>" + rs.getString(2) + "</td>";
output+="<td>" + rs.getString(3) + "</td></tr>";
}
output+="<input type=hidden name='rowCount' value='"+count+"'>";
在invoiceTable.jsp中，您可以参考以下代码提取所选行数据。
String article="";
String selectedRow;
String[] temp;
int totalPrice=0;
int rowCount = Integer.parseInt(request.getParameter("rowCount"));
if (rowCount>0){
for (int i=0;i<rowCount;i++) {
selectedRow=request.getParameter("row"+i);
if (selectedRow!=null){ //that mean the row is selected by user.
temp=selectedRow.split(","); //where temp[0]=product id,temp[1]=product name,temp[2]=product price.
article+=temp[1]+" ";
totalPrice+=Integer.parseInt(temp[2]);
}
}
....................... //prepare your SQL statement and insert the data to the database.
}
英文:
First, you need to modify the following statement in productCatalog.jsp:
while (rs.next()){
output += "<tr><td><input type='checkbox'></td>" + "<td>" + rs.getString(1) + "</td>" + "<td>" + rs.getString(2) + "</td>" + "<td>" + rs.getString(3) + "</td></tr>";
}
to
int count=0;
while (rs.next()){
output+="<tr>";
output+="<td><input type='checkbox' name=row"+(count++)+" value="+rs.getString(1)+","+rs.getString(2)+","+rs.getString(3)+"></td>";
output+="<td>" + rs.getString(1) + "</td>";
output+="<td>" + rs.getString(2) + "</td>";
output+="<td>" + rs.getString(3) + "</td></tr>";
}
output+="<input type=hidden name='rowCount' value='"+count+"'>";
In invoiceTable.jsp, you can refer the following coding to extract the selected row data.
String article="";
String selectedRow;
String[] temp;
int totalPrice=0;
int rowCount = Integer.parse(request.getParameter("rowCount"));
if (rowCount>0){
for (int i=0;i<rowCount;i++) {
selectedRow=request.getParameter("row"+i);
if (selectedRow!=null){ //that mean the row is selected by user.
temp=selectedRow.split(","); //where temp[0]=product id,temp[1]=product name,temp[2]=product price.
article+=temp[1]+" ";
totalPrice+=Integer.parse(temp[2]);
}
}
....................... //prepare your SQL statement and insert the data to the database.
}
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论