How do i do the insert operation after select query at same jsp program.
Here is the code which is running successfully for select stmt.
Connection connection = DriverManager.getConnection("jdbc:odbc:emaildb", "", "");
Statement statement = connection.createStatement();
ResultSet resultset = statement.executeQuery("select CompanyName as CN, sum(ForQtr)as Tota from Imports where CompanyName = '"+Cname+"' group by CompanyName") ;%>
<% String CompName=resultset.getString("CN");%>
Now , after some calculations how do I continue to insert data into db inthe same table within this same jsp program.
advance thanks ,