<html>
<body>
<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@ page import="java.sql.*" %>
<%
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mall?user=root&password=");
Statement statement = connection.createStatement() ;
ResultSet resultset =
statement.executeQuery("select * from test") ;
%>
<TABLE BORDER="1">
<TR>
<TH>Shop Name</TH>
<TH>Shop Desc.</TH>
<TH>Owner Name</TH>
</TR>
<% while(resultset.next()){ %>
<TR>
<TD> <input type="checkbox"> <%= resultset.getString(1) %></td>
<TD><%= resultset.getString(2) %></TD>
<TD><%= resultset.getString(3) %></TD>
</TR>
<% } %>
</TABLE>
<input type="button" value="Accept" style="background-image:url(../images/accept.png)" />
<input type="button" value="Reject"/>
</body>
</html>
it showing some values frm db.
i want to when i click accept then the checkboxes s values go to another table i cant understand how to do that.
can any 1 help me with this issue.
<body>
<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@ page import="java.sql.*" %>
<%
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mall?user=root&password=");
Statement statement = connection.createStatement() ;
ResultSet resultset =
statement.executeQuery("select * from test") ;
%>
<TABLE BORDER="1">
<TR>
<TH>Shop Name</TH>
<TH>Shop Desc.</TH>
<TH>Owner Name</TH>
</TR>
<% while(resultset.next()){ %>
<TR>
<TD> <input type="checkbox"> <%= resultset.getString(1) %></td>
<TD><%= resultset.getString(2) %></TD>
<TD><%= resultset.getString(3) %></TD>
</TR>
<% } %>
</TABLE>
<input type="button" value="Accept" style="background-image:url(../images/accept.png)" />
<input type="button" value="Reject"/>
</body>
</html>
it showing some values frm db.
i want to when i click accept then the checkboxes s values go to another table i cant understand how to do that.
can any 1 help me with this issue.