Forum:

insert checked checkbox into table

Ranch Hand

Posts: 225

posted 9 years ago

hi guys

i am preparing a page on which i have used select & checkbox i need now that those all checkbox whicch a re checked their data should be entered into the new table

the checked checkboxes are to be printed on next page which i am getting printed correctly now i ant to insert it into table but as they all are printed through for loop so when i try to insert them into an array they all are either lost or might not be getting properly

Help me to solve this problem

thank you

Swastik Dey

Bartender

Posts: 2266

I like...

posted 9 years ago

they all are either lost or might not be getting properly

What exactly do you mean by this? Could you please show your code, and highlight where the problem is?

Swastik

Aditi agarwal

Ranch Hand

Posts: 225

posted 9 years ago

thanks Swastik for your prompt reply

actually i am checking some checkbox on one page & printing them on another page jsp only

now i need that those checkboxes which are printed are also to be inserted into Postgre SQL table

" I am sorry for inserting my connections in jsp"
my code is :-
one.jsp

<%@ page language="java" pageEncoding="ISO-8859-1"%>
<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean"%> 
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html"%>
<%@ page import="java.io.*,java.sql.* ,ams.database.*,javax.servlet.http.*,javax.servlet.*"%>
<html>   
<head> 
<%
response.setHeader("Cache-Control","no-cache"); //HTTP 1.1
response.setHeader("Pragma","no-cache"); //HTTP 1.0
response.setDateHeader ("Expires", 0); //prevents caching at the proxy server
%>
</head>   
<body style=" background-color:#FFFFCC;">  
<form name="checkedbox"  method="post" action="map.jsp">   
<% 
Connection connection =new database().getConnection();   
Statement s=null;   
Statement st =null;  
Statement st1=null;    
 
ResultSet rs =null;   
ResultSet rst=null;   
ResultSet rst1=null; 
   
s=connection.createStatement();  
st = connection.createStatement(); 
 
int id=0;   
 %>
 <%  
rs=st.executeQuery("SELECT * from ams_division;");  //"SELECT * from ams_division;"
rst=s.executeQuery("Select * from sec_code;");  //"Select * from sec_code;"
 %> 
<select name="combo" id=""> 
<option value="-1">--select--</option>
<% while(rs.next()){%>
<option value="<%=rs.getString(2) %>"><%=rs.getString(2) %></option>
<%} %>
</select><br/><br/><br/>
<font size="4" color="blue">Check the Sections of above selected division</font>
<br/><BR/>
<br/>

<% while(rst.next())
{ id=rst.getInt(1);%>
<table><tr><td>
<input type="checkbox" name="section" value="<table><tr><td><%=rst.getInt(1) %></td><td><%=rst.getString(2) %></td></tr></table>"/></td><td><%=rst.getInt(1) %></td><td><%=rst.getString(2) %></td><td><%=rst.getString(3) %></td></tr></table>
<br/>
<%} %>
<br/>
<input type="submit" value="submit" />
</form>  
</body>   
</html>

two.jsp

rs=st.executeQuery("select divcode from ams_division where divname=\'"+div.trim()+"\';");
 		 for (int j=0;j<divcode.length;j++) 
 		{ 
 			rst=s.executeQuery("SELECT * from sec_code where sec_name=\'"+seccode[j].trim()+"\';");
 		
while(rst.next()){
} 
}
%><br/><br/>
		<% 
		try
		{
			while(rs.next())
  	{
  	  		st1 = conn.prepareStatement("INSERT INTO divsec(div_code,sec_code,sec_name,login) VALUES (?, ?, ?, ?)");
  		 	st1.setInt(1, rs.getInt(1));
  		 	st1.setShort(2,rs.getShort(1));
  		 	st1.setString(3,"hi");
			st1.setString(4,"heiilo");
			out.println("Insertion Done");
		}
		}
		catch(Exception e)
		{out.println(e);
		}
			 
   %>

</form>
  </body>
</html>

thank you if you still cant understand my problem still let me kno please

Aditi agarwal

Ranch Hand

Posts: 225

posted 9 years ago

i would like to tell you one more thing i am selecteing many checkbox at a time

Swastik Dey

Bartender

Posts: 2266

I like...

posted 9 years ago

I understood about sections, that multiple sections can be selected. How about division? Can multiple divisions be selected too? If yes, how do you identify which section comes under which division?

Swastik

Aditi agarwal

Ranch Hand

Posts: 225

posted 9 years ago

thank you for the reply actually i am selecting oly one division under which there are many sections so division is in combo & sections are in chckbox both retrieved from database

thats why i need one division which i can retrieve easily & getting it correctly in my table as i am trying

but the main problem is in sections

looking forward for your reply

Swastik Dey

Bartender

Posts: 2266

I like...

posted 9 years ago

I made few changes in page2, kindly have a look. I don't have any way to test. Please do keep backup of your existing code.

<%@ page language="java" pageEncoding="ISO-8859-1"%>
<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean"%> 
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html"%>
 <%@ page import="java.io.*" %>
 <%@ page import="java.sql.*" %>
 <%@ page import="ams.database.*" %>
 <%@ page import="javax.servlet.http.*" %>
 <%@ page import="javax.servlet.*"%>
 <%@ page import="java.util.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <html:base />
    <title>map.jsp</title>
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	
  </head>
  <body style=" background-color:#FFFFCC;">
    <form name="form">
<font size="4" color="blue">The Selected Division is :-</font><br/><br/>
 <%!
   String divcode="";
   String secCode="";
   HashMap <String,String> secCodeAndName=new HashMap<String,String>();
 %>
 <% 
 String name1="combo";
    String div="";
  
 divcode=request.getParameter(name1); 
  out.println(divcode);  
 div = divcode;
 database db = new database();
 int a1=0;
 Connection conn =db.getConnection();
 ResultSet rs=null; 
 ResultSet rst=null; 
 ResultSet rs1=null;
 Statement s=null; 
 PreparedStatement st1=null; 
 Statement st=null;
 st=conn.createStatement(); 
 s=conn.createStatement(); 
 rs=st.executeQuery("select divcode from ams_division where divname=\'"+div.trim()+"\';");
 if(rs.next()){
    divcode=rs.getString(1);
 }
 %>
<br></br><font size="4" color="blue">The Sections of Above Selected Division are :-</font><br/><br/>
 
 <%
   String name="section"; 
   String sec="";
    String[] seccode=request.getParameterValues(name); 
    for(int i=0;i<seccode.length;i++) 
    { 
    out.println(seccode[i]);
    //sec=sec+seccode[i];
    sec=seccode[i];
    rst=s.executeQuery("SELECT sec_code from sec_code where sec_name=\'"+sec+"\';");
    if(rst.next()){
    	secCode=rst.getString(1);
    	secCodeAndName.put(secCode,sec);	
    }
    }
    Iterator itr=secCodeAndName.keySet().iterator();
    while(itr.hasNext()){
       String sectionCode=itr.next();
       String sectionName=secCodeAndName.get(sectionCode);
       st1 = conn.prepareStatement("INSERT INTO divsec(div_code,sec_code,sec_name,login) VALUES (?, ?, ?, ?)");  
       st1.setInt(1, Integer.parseInt(divcode));  
       st1.setShort(2,Short.parseShort(sectionCode));  
       st1.setString(3,sectionName);  
       st1.setString(4,"heiilo");  
       st1.executeUpdate();
    }
 %>

</form>
  </body>
</html>

Swastik

Aditi agarwal

Ranch Hand

Posts: 225

posted 9 years ago

thanks for your code but there are some problems in this

1)

Syntax error, parameterized types are only available if source
level is 1.5

2)

cannot convert from object to string

i canot understand these errors please help me i think i am usingstruts 1.3 so thats why 1st error is coming

2nd can be solved

Aditi agarwal

Ranch Hand

Posts: 225

posted 9 years ago

i have solved 2nd problem nw 1st is the remaining one

Swastik Dey

Bartender

Posts: 2266

I like...

posted 9 years ago

Swastik

Aditi agarwal

Ranch Hand

Posts: 225

posted 9 years ago

atlast i found changes that i have to make thanks

let me check if code works or not

Swastik Dey

Bartender

Posts: 2266

I like...

posted 9 years ago

I was just rechecking the logic, we can probably do it without the iterator too.

Swastik

Aditi agarwal

Ranch Hand

Posts: 225

posted 9 years ago

i cant say anything about code now is it right or not but there two things more

1) i need to insert one more column where i have writen heillo there is one more column retrieved from database ho wto do that please help me

2) it is not inserting into the table my query is right but still it is not inserting

any clue why so is happening

Aditi agarwal

Ranch Hand

Posts: 225

posted 9 years ago

how can that be done because i cannot understand this logic this is a little bit tough for me

thank you

Swastik Dey

Bartender

Posts: 2266

I like...

posted 9 years ago

<%@ page language="java" pageEncoding="ISO-8859-1"%>
<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean"%> 
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html"%>
 <%@ page import="java.io.*" %>
 <%@ page import="java.sql.*" %>
 <%@ page import="ams.database.*" %>
 <%@ page import="javax.servlet.http.*" %>
 <%@ page import="javax.servlet.*"%>
 <%@ page import="java.util.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <html:base />
    <title>map.jsp</title>
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	
  </head>
  <body style=" background-color:#FFFFCC;">
    <form name="form">
<font size="4" color="blue">The Selected Division is :-</font><br/><br/>
 <%!
   String divcode="";
   String secCode="";
   HashMap <String,String> secCodeAndName=new HashMap<String,String>();
 %>
 <% 
 String name1="combo";
    String div="";
  
 divcode=request.getParameter(name1); 
  out.println(divcode);  
 div = divcode;
 database db = new database();
 int a1=0;
 Connection conn =db.getConnection();
 ResultSet rs=null; 
 ResultSet rst=null; 
 ResultSet rs1=null;
 Statement s=null; 
 PreparedStatement st1=null; 
 Statement st=null;
 st=conn.createStatement(); 
 s=conn.createStatement(); 
 rs=st.executeQuery("select divcode from ams_division where divname='"+div.trim()+"'");
 if(rs.next()){
    divcode=rs.getString(1);
 }
 %>
<br></br><font size="4" color="blue">The Sections of Above Selected Division are :-</font><br/><br/>
 
 <%
   String name="section"; 
   String sec="";
   st1 = conn.prepareStatement("INSERT INTO divsec(div_code,sec_code,sec_name,login) VALUES (?, ?, ?, ?)"); 
    String[] seccode=request.getParameterValues(name); 
    for(int i=0;i<seccode.length;i++) 
    { 
    out.println(seccode[i]);
    //sec=sec+seccode[i];
    sec=seccode[i];    
    rst=s.executeQuery("SELECT sec_code from sec_code where sec_name='"+sec+"'");
    
    if(rst.next()){
    	secCode=rst.getString(1);
    	st1.setInt(1, Integer.parseInt(divcode));  
	st1.setShort(2,Short.parseShort(secCode));  
	st1.setString(3,sec);  
	st1.setString(4,"heiilo");  
         st1.executeUpdate();
    	//secCodeAndName.put(secCode,sec);	
    }
    }    
 %>
		
  </form>
  </body>
</html>

rst=s.executeQuery("SELECT sec_code from sec_code where sec_name='"+sec+"'");
Just make sure the field name sec_code is correct, because I don't have any idea about your table design.

Swastik

Swastik Dey

Bartender

Posts: 2266

I like...

posted 9 years ago

Just change this line

to

Swastik

Aditi agarwal

Ranch Hand

Posts: 225

posted 9 years ago

thanks for the updated code swastik but problem still exists

i have checked my table too

its not insering data into table

2) how to insert onemore clumn after retrieving it form seccode
please help me

thanks for your help till now

Swastik Dey

Bartender

Posts: 2266

I like...

posted 9 years ago

out.println("Number of records inserted="+updateCount);

What does it print in the above line?

Swastik

Aditi agarwal

Ranch Hand

Posts: 225

posted 9 years ago

no swastik its not printing anything i think please consider your this code without iterator once again

<%@ page language="java" pageEncoding="ISO-8859-1"%>   
<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean"%>    
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html"%>   
 <%@ page import="java.io.*" %>   
 <%@ page import="java.sql.*" %>   
 <%@ page import="ams.database.*" %>   
 <%@ page import="javax.servlet.http.*" %>   
 <%@ page import="javax.servlet.*"%>   
 <%@ page import="java.util.*"%>   
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">   
<html>   
  <head>   
    <html:base />   
    <title>map.jsp</title>   
    <meta http-equiv="pragma" content="no-cache">   
    <meta http-equiv="cache-control" content="no-cache">   
    <meta http-equiv="expires" content="0">       
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">   
    <meta http-equiv="description" content="This is my page">   
       
  </head>   
  <body style=" background-color:#FFFFCC;">   
    <form name="form">   
<font size="4" color="blue">The Selected Division is :-</font><br/><br/>   
 <%!   
   String divcode="";   
   String secCode="";   
   HashMap <String,String> secCodeAndName=new HashMap<String,String>();   
 %>   
 <%    
 String name1="combo";   
    String div="";   
     
 divcode=request.getParameter(name1);    
  out.println(divcode);     
 div = divcode;   
 database db = new database();   
 int a1=0;   
 Connection conn =db.getConnection();   
 ResultSet rs=null;    
 ResultSet rst=null;    
 ResultSet rs1=null;   
 Statement s=null;    
 PreparedStatement st1=null;    
 Statement st=null;   
 st=conn.createStatement();    
 s=conn.createStatement();    
 rs=st.executeQuery("select divcode from ams_division where divname='"+div.trim()+"'");   
 if(rs.next()){   
    divcode=rs.getString(1);   
 }   
 %>   
<br></br><font size="4" color="blue">The Sections of Above Selected Division are :-</font><br/><br/>   
    
 <%   
   String name="section";    
   String sec="";   
   st1 = conn.prepareStatement("INSERT INTO divsec(div_code,sec_code,sec_name,login) VALUES (?, ?, ?, ?)");    
    String[] seccode=request.getParameterValues(name);    
    for(int i=0;i<seccode.length;i++)    
    {    
    out.println(seccode[i]);   
    //sec=sec+seccode[i];   
    sec=seccode[i];       
    rst=s.executeQuery("SELECT sec_code from sec_code where sec_name='"+sec+"'");   
       
    if(rst.next()){   
        secCode=rst.getString(1);   
        st1.setInt(1, Integer.parseInt(divcode));     
    st1.setShort(2,Short.parseShort(secCode));     
    st1.setString(3,sec);     
    st1.setString(4,[b]rs.getString(4)[/b]);     
        int updateCount= st1.executeUpdate();   
out.println("Number of records inserted="+updateCount);  
        //secCodeAndName.put(secCode,sec);     
    }   
    }       
 %>   
           
  </form>   
  </body>   
</html>

please tell me how to add this one more column highlighted in bold

thank you

Aditi agarwal

Ranch Hand

Posts: 225

posted 9 years ago

i found that program is not entering if(rst.next)

Swastik Dey

Bartender

Posts: 2266

I like...

posted 9 years ago

rst=s.executeQuery("SELECT sec_code from sec_code where sec_name='"+sec+"'");

Are you sure about the field name and table name in the above query?

Swastik

Aditi agarwal

Ranch Hand

Posts: 225

posted 9 years ago

yup swastik i amm definitely sure about them they all are correct

Swastik Dey

Bartender

Posts: 2266

I like...

posted 9 years ago

I asked only because your query had select *. Not entering into that rst.next(), means its somehow failing to execute the query, or it's failing to find any matching record. Now the only way seems for resolving the issue is to surround the entire scripelet code in try, catch. Print the exception and see what it says. Also put one else condition for that if(rs.next()) and put some message to see where the control is going.

Swastik

Aditi agarwal

Ranch Hand

Posts: 225

posted 9 years ago

now i have even changed the name of table but still its not working have a look at new code please

<%@ page language="java" pageEncoding="ISO-8859-1"%>   
<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean"%>    
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html"%>   
 <%@ page import="java.io.*" %>   
 <%@ page import="java.sql.*" %>   
 <%@ page import="ams.database.*" %>   
 <%@ page import="javax.servlet.http.*" %>   
 <%@ page import="javax.servlet.*"%>   
 <%@ page import="java.util.*"%>   
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">   
<html>   
  <head>   
    <html:base />   
    <title>map.jsp</title>   
    <meta http-equiv="pragma" content="no-cache">   
    <meta http-equiv="cache-control" content="no-cache">   
    <meta http-equiv="expires" content="0">       
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">   
    <meta http-equiv="description" content="This is my page">   
       
  </head>   
  <body style=" background-color:#FFFFCC;">   
    <form name="form">   
<font size="4" color="blue">The Selected Division is :-</font><br/><br/>   
 <%!   
   String divcode="";   
   String secCode="";   
HashMap secCodeAndName=new HashMap();   
  
 %>   
 <%    
 String name1="combo";   
    String div="";   
     
 divcode=request.getParameter(name1);    
  out.println(divcode);     
 div = divcode;   
 database db = new database();   
 int a1=0;   
 Connection conn =db.getConnection();   
 ResultSet rs=null;    
 ResultSet rst=null;    
 ResultSet rs1=null;   
 Statement s=null;    
 PreparedStatement st1=null;    
 Statement st=null;   
 st=conn.createStatement();    
 s=conn.createStatement();    
 rs=st.executeQuery("select divcode from ams_division where divname='"+div.trim()+"'");   
 if(rs.next()){   
    divcode=rs.getString(1);   
 }   
 %>   
<br></br><font size="4" color="blue">The Sections of Above Selected Division are :-</font><br/><br/>   
    
 <%   
   String name="section";    
   String sec="";   
   st1 = conn.prepareStatement("INSERT INTO divsec(div_code,sec_code,sec_name,login) VALUES (?, ?, ?, ?)");    
    String[] seccode=request.getParameterValues(name);    
    for(int i=0;i<seccode.length;i++)    
    {    
    out.println(seccode[i]);   
    sec=seccode[i];       
    rst=s.executeQuery("SELECT * from ams_section where sec_name='"+sec+"'");   
      if(rst.next()){   
       secCode=rst.getString(1);
         out.println("8");
        st1.setInt(1, Integer.parseInt(divcode));     
    st1.setShort(2,Short.parseShort(secCode));     
    st1.setString(3,sec);     
    st1.setString(4,rst.getString(3));     
       int updateCount= st1.executeUpdate();   
out.println("Number of records inserted="+updateCount); 
        //secCodeAndName.put(secCode,sec);     
    }   
    }       
 %>   
           
  </form>   
  </body>   
</html>

thank you once again

Aditi agarwal

Ranch Hand

Posts: 225

posted 9 years ago

i have used both else & try & catch

now its printing else condition

means not entering the if condition

thank you

Aditi agarwal

Ranch Hand

Posts: 225

posted 9 years ago

hey swastik i have tried everyu possible combination of try & catch but ist not going into catch means no exception

every tym it goes into else part

Swastik Dey

Bartender

Posts: 2266

I like...

posted 9 years ago

In page1 the checkbox value is a probably a combination of the section code and section name.

But in page2 you are comparing with the section name

Now consider the value displayed in page1 is 1Section1

But while comparing in page2
the query becomes something like sec_name='<table><tr><td>1</td><td>Section1</td></tr>', isn't it wrong?

Swastik

Swastik Dey

Bartender

Posts: 2266

I like...

posted 9 years ago

You just print sec and see what you get

Swastik

Aditi agarwal

Ranch Hand

Posts: 225

posted 9 years ago

hey swastik can you tell me any wy so that i can retrieve sec_code from previous page i.e one.jsp but only those sec_code which are checked

i think the problem is might be due to it cannot match sec_name as it is string

"sec" printing correct values what it should print

thank you

Aditi agarwal

Ranch Hand

Posts: 225

posted 9 years ago

i have changed this code what you have said but still its giving error

i have done it now

now its should give right answer but still not proper reply

Swastik Dey

Bartender

Posts: 2266

I like...

posted 9 years ago

It won't because the value still has that <table><tr> things, and when you retrieve it using getParameter, it gets the complete <table><tr>tags in the variable, and only because of that you are viewing the rendered content in a tabular format.

Swastik

Swastik Dey

Bartender

Posts: 2266

I like...

posted 9 years ago

Considering your last made change in page1, try this once again in page2

<%     
    String name="section";      
    String sec="";     
    st1 = conn.prepareStatement("INSERT INTO divsec(div_code,sec_code,sec_name,login) VALUES (?, ?, ?, ?)");      
     String[] seccode=request.getParameterValues(name);      
     for(int i=0;i<seccode.length;i++)      
     {      
     out.println(seccode[i]);     
     sec=seccode[i];         
     int startPos=sec.indexOf("<td>");
     int lastPos=sec.indexOf("</td>");
     String sectionName=sec.substring(startPos+4,lastPos);
     rst=s.executeQuery("SELECT * from ams_section where sec_name='"+sectionName+"'");     
       if(rst.next()){     
        secCode=rst.getString(1);  
          out.println("8");  
         st1.setInt(1, Integer.parseInt(divcode));       
     st1.setShort(2,Short.parseShort(secCode));       
     st1.setString(3,sec);       
     st1.setString(4,rst.getString(3));       
        int updateCount= st1.executeUpdate();     
 out.println("Number of records inserted="+updateCount);   
         //secCodeAndName.put(secCode,sec);       
     }     
     }         
  %>

Swastik

Aditi agarwal

Ranch Hand

Posts: 225

posted 9 years ago

thank you so much Swastik
this is working perfectly
i just removed table tag & running so gud

thank you so so much

It will give me the powers of the gods. Not bad for a tiny ad:

the value of filler advertising in 2020

https://coderanch.com/t/730886/filler-advertising