Inserting a checkbox value into database.

Vic Hood

Ranch Hand

Posts: 477

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi All,
Im writing a sample application involving JSP's that would insert and display from a dtabase, however im relatively new to programming and hence facing a lot of minor issues . I understand that my project would be better off using a servlet or a model class , but im trying a POC using just JSP.

Im trying to fetch a set of values from the screen and insert into the database , im able to insert values of text boxes sucessfully , however cant get the checkboxes to insert properly

and it keeps throwing an NPE . It would be great if anyone could help me where im going wrong.

Below is the code of my jsp.

<HTML>
 <HEAD> <TITLE>Domain database.</TITLE> </HEAD>
 <BODY>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
 <P> Update Database Content
 <FORM ACTION="addData.jsp" METHOD="POST">
   <TR>
  <TD> Code   <INPUT TYPE=TEXT NAME=code> </TD>
   <TD>Description <INPUT TYPE=TEXT NAME=description></TD>
  </TR>
  <BR/>
  <TR>
  <TD>Active<INPUT TYPE="CHECKBOX" NAME=active></TD>
  <TD>Editable<INPUT TYPE="CHECKBOX" NAME=edit></TD>
  <BR/>
  
  <INPUT TYPE=Submit VALUE="Add to Database">
 </FORM>

<HR>
 <P> Content of the database:
 <TABLE BORDER=1 CELLPADDING=0 CELLSPACING=0>
 <TR> <TD> Code  </TD>
      <TD> Description</TD>
      <TD> Active</TD>
      <TD> Edit</TD>
 </TR>
 <%!PreparedStatement stmt = null;
 	//Connection con = null;    %>
 <%	
 	try {
 				Class.forName("org.postgresql.Driver");
	 			java.sql.Connection connection  = java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/WSS1","postgres","postgres");
 				java.sql.Statement statement = connection.createStatement();
 					if(request.getParameter("code")!=null &&(!"".equals("code".trim()))){
		   			 if((request.getParameter("description")!=null &&(!"".equals("description".trim())))){
		   				/*if((request.getParameter("active")!=null &&(!"".equals("active".trim())))){   DOESN'T INSERT                                                                                                                                         EVEN       IF  THIS CHECK IS IN PLACE
		   					if((request.getParameter("edit")!=null &&(!"".equals("edit".trim())))){ */
		   						
                                    Enumeration parameters = request.getParameterNames();
  
 					 if(parameters.hasMoreElements()) {
 						System.out.println("Test Code Fragment- Insert");
				  String code  = request.getParameter("code");
				  System.out.println("Code of new tuple"+code);
    		      String description =request.getParameter("description");
    		      System.out.println("Description of new tuple"+description);
    		      String active=null;
    		      String edit=null;
    		      		if((request.getParameter("active").equals("1")))
	      				active="1";
    		     
	      						else
	      						active="0";
    		      		 System.out.println("Active Status of new tuple"+active);
	      				if((request.getParameter("edit").equals("Yes")))
	      				edit="1";
	      						else
	      						edit="0";
	      				System.out.println("Active Status of new tuple"+active);
    		      System.out.println("The code is"+code);
	              System.out.println("The description is"+description);
	              System.out.println("The edit status is"+edit);
	              System.out.println("The active status is"+active);		      
			      String query= "INSERT INTO DOMAIN (CODE,DESCRIPTION,ISACTIVE,ISEDITABLE) VALUES (?,?,?,?)" ;
				  System.out.println("The code is"+code);
	              System.out.println("The description"+description);
                  stmt = connection.prepareStatement(query);
	              stmt.setString(1, code);
	              stmt.setString(2, description);
	              stmt.setString(3, active);
	              stmt.setString(4, edit);
	              System.out.println("The code is"+code);
	              System.out.println("The description is"+description);
	              System.out.println("The edit status is"+edit);
	              System.out.println("The active status is"+active);
				// stmt.setString(3, domainBean.getDescription());
				//stmt.setBoolean(4, (domainBean.getEdit()));
				//stmt.setInt(5,domainBean.getDomainTypeOid());
				  stmt.executeUpdate();
   }
 		 }
 		 }  	
 					
					java.sql.ResultSet columns = statement.executeQuery("SELECT CODE,DESCRIPTION,ISACTIVE,ISEDITABLE FROM DOMAIN");
					System.out.println("The Select query executed successfully");
   					 while(columns.next()) {
     					String code  = columns.getString("CODE");
     					String description = columns.getString("DESCRIPTION");
     					String active=null;
     	    		    String edit=null;
     	    				    if((columns.getString("ISACTIVE").equals("1")))
   		      					active="Yes";
   		      						else
   		      						active="No";
   		      					if((columns.getString("ISEDITABLE").equals("1")))
   		      					edit="Yes";
   		      						else
   		      						edit="No";
     				    		      	
     %>
       <TR>  <TD> <%= code  %> </TD>
             <TD> <%= description %> </TD>
              <TD> <%= active %> </TD>
               <TD> <%= edit %> </TD>
       </TR>
 <% } 
		   			// }
 					//}
 					
 	}
    catch (Exception e) {
	   
	   //System.out.println(e.getMessage());
	   e.printStackTrace();
   }   System.out.println("Test Code Fragment2"); %>
 </TABLE>
 </BODY>
 </HTML>

tHANKS FOR HELPING!!

Learning and Learning!-- Java all the way!

Vic Hood

Ranch Hand

Posts: 477

I like...

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hey folks , it was a minor error , with handling of the checkbox , solved it myself.

Learning and Learning!-- Java all the way!

Oh. Hi guys! Look at this tiny ad:

Gift giving made easy with the permaculture playing cards

https://coderanch.com/t/777758/Gift-giving-easy-permaculture-playing