Click here to Skip to main content
15,908,674 members
Home / Discussions / Java
   

Java

 
QuestionJava Swing - Right Click and JPopupMenu in JTable Pin
djDash5-Jun-09 0:25
djDash5-Jun-09 0:25 
QuestionRe: Java Swing - Right Click and JPopupMenu in JTable Pin
Java John11-Jun-09 1:59
Java John11-Jun-09 1:59 
QuestionCreating a file and saving it on a networked computer [modified] Pin
ItIsFinished4-Jun-09 12:00
ItIsFinished4-Jun-09 12:00 
AnswerRe: Creating a file and saving it on a networked computer [modified] Pin
darkdragn5-Jun-09 2:45
darkdragn5-Jun-09 2:45 
GeneralRe: Creating a file and saving it on a networked computer Pin
ItIsFinished5-Jun-09 5:44
ItIsFinished5-Jun-09 5:44 
QuestionWriting a simple HTML report using Java Pin
raesa3-Jun-09 20:15
raesa3-Jun-09 20:15 
AnswerRe: Writing a simple HTML report using Java Pin
Ali Shakiba10-Jun-09 22:19
Ali Shakiba10-Jun-09 22:19 
Questionneed help geeting a nullpointerexeption [modified] Pin
ashish_bhatia3-Jun-09 1:07
ashish_bhatia3-Jun-09 1:07 
I need hellp moved this code from unix db2 tomcat server to unix mysql tomcat server. Modified the code as per below

This code gives a null pointer exception Please view at www.nerolac.com/dealer6_1.jsp. Please advice.
<pre>
&lt;%@ page language="java" import="java.sql.*"%&gt;
&lt;jsp:useBean id="conb" class="nerolacbean.ConnOdbc"/&gt;&lt;script&gt;
&lt;/script&gt;&lt;%
          String connectionURL = "jdbc:mysql://174.133.229.154:3306/nerolac?";
          Connection connection = null;          Statement statement = null;
          String sql_state,sql_city,flag,city,sql_details;          ResultSet rs_state;
          String id,stateid;          ResultSet rs = null;          ResultSet rs1 = null;
          ResultSet rs2 = null;          String address = null;%&gt;
&lt;SCRIPT ID=clientEventHandlersJS LANGUAGE=javascript&gt;          &lt;!--
function state_onchange(){     if (document.testa.state.selectedIndex!=0)     {
          if (document.testa.city==document.undefined)          {          }          else          {
               document.testa.city[document.testa.city.selectedIndex].value = " ";          }
          // document.testa.action="dealer6.jsp";
          //alert(document.getElementById("state").value);
          city = document.getElementById("city").value;
          state = document.getElementById("state").value;          if (city=0)          { city = "+"; }
                    location.replace("dealer6_1.jsp?&amp;state="+state+"&amp;city="+city);                         }
}          function city_onchange(){     city = document.getElementById("city").value;
     state = document.getElementById("state").value;
     location.replace("dealer6_1.jsp?&amp;state="+state+"&amp;city="+city);}         
//--&gt;&lt;/SCRIPT&gt;&lt;html&gt;&lt;body&gt;     &lt;%
          Class.forName("org.gjt.mm.mysql.Driver").newInstance();
          connection = DriverManager.getConnection(connectionURL,"","");
          statement = connection.createStatement();          try          {                              ResultSet rs_city=null;
               ResultSet rs_details=null;               String reqCity=""+request.getParameter("city");
               String reqState=""+request.getParameter("state");               String form_state="";
               sql_state = "select distinct state from dealernetwork order by state";                             
     %&gt;                         &amp;nbsp;    
     &lt;form name="testa" action="dealer6_1.jsp" method="get"&gt;
        &lt;table width="100%" border="0" cellspacing="0" cellpadding="0"&gt;
          &lt;tr&gt;             &lt;td&gt;&lt;img src="images/indiamap2.jpg"   /&gt;&lt;/td&gt;
             &lt;td valign="middle"&gt;&lt;table border="0" cellpadding="2" bordercolor="#000000" bordercolorlight="#000000"   bordercolordark="#000000"&gt;
                  &lt;tr&gt;
                    &lt;td height="23" align="center" bgcolor="#FFCCFF" class="txt07" &gt;&lt;b&gt; Select State&lt;/b&gt;&lt;/td&gt;
                    &lt;td height="23" align="center"   bgcolor="#FFCCFF" class="txt07"&gt;&lt;b&gt; Select City&lt;/b&gt; &lt;/td&gt;
                  &lt;/tr&gt;                  &lt;tr&gt;                    &lt;%
               if(!reqState.equalsIgnoreCase("null"))//If state is specified               {                    %&gt;
                    &lt;%                    form_state = reqState.toUpperCase();                    if(!form_state.equals(""))
                    {                         try                         {
                              sql_city = "select ID,city,STATEID from dealernetwork where state = '"+form_state+"' order by city";
                         out.println("sql_city "+sql_city);                              rs_city =conb.getResult(sql_city);
                    out.println("rs_city "+rs_city);                              flag = "true";                         }
                         catch(Exception e)                         {
                              System.out.println("IN EXCEPTION-----"+e.getMessage());                         }                    }               }
                    %&gt;
                    &lt;td   height="26" bordercolordark="#00FFFF" align="center"&gt;&amp;nbsp;
                      
                       &lt;select name="state" id="state"   onchange="return state_onchange()" class="txt07"&gt;
                         &lt;%               if(form_state.equals(""))                         {%&gt;
                         &lt;option selected="selected" value=""&gt; -- Select State --&lt;/option&gt;
                         &lt;%}else                         {%&gt;
                         &lt;option value=""&gt; -- Select State -- &lt;/option&gt;                         &lt;%}%&gt;
                         &lt;%               rs_state = conb.getResult(sql_state);              
               out.println("rs_state "+rs_state);                              while(rs_state.next())               {
                    if((reqState).equals(rs_state.getString("state")))                    {                         %&gt;
                         &lt;option value="&lt;%= rs_state.getString("state")%&gt;" selected="selected"&gt;&lt;%= rs_state.getString("state")%&gt;&lt;/option&gt;
                         &lt;%     }else                         {%&gt;
                         &lt;option value="&lt;%= rs_state.getString("state")%&gt;"&gt;&lt;%= rs_state.getString("state")%&gt;&lt;/option&gt;
                         &lt;%                    }               }                                        %&gt;                       &lt;/select&gt;&lt;/td&gt;
                    &lt;td   height="26" align="center"&gt;&lt;%
//if (!reqState.equalsIgnoreCase("null"))//{                       %&gt;
                       &lt;select name="city" onchange="return city_onchange()" class="txt07"&gt;
                         &lt;option value="" selected="selected" &gt;--Select City--&lt;/option&gt;
                         &lt;%                              String checkcity="";               boolean stateidStatus=true;
               String tempCity="";               if(!reqState.equalsIgnoreCase("null"))               {                   
                    while(rs_city.next())                    {                         id = rs_city.getString(1);
                         city = rs_city.getString(2);                                                  if(!tempCity.equalsIgnoreCase(city))
                         {                              tempCity = city;                              if(reqCity.equalsIgnoreCase(city))                              {
                         %&gt;
                         &lt;option selected="selected" value="&lt;%=reqCity%&gt;"&gt;&lt;%=reqCity%&gt;&lt;/option&gt;
                         &lt;%     }else                              {                         %&gt;
                         &lt;option value="&lt;%=city%&gt;"&gt;&lt;%=city%&gt;&lt;/option&gt;
                         &lt;%                              }                         }                    }               }                         %&gt;                       &lt;/select&gt;
                       &lt;% //}%&gt;&lt;/td&gt;                  &lt;/tr&gt;               &lt;/table&gt;               &lt;br /&gt;
               &lt;%                              if(!reqCity.equalsIgnoreCase("null"))               {                   
                    String upper =   reqCity.toUpperCase();
                    String lower =   reqCity.toLowerCase();                   
                    String firstCap =reqCity.toLowerCase();
                    String firstCap1 = (firstCap.substring(0,1)).toUpperCase();
                    String firstCap2 = firstCap.substring(1,firstCap.length());
                    String firstCap3=firstCap1+firstCap2;
                    sql_details = "select * from dealernetwork where city= '"+upper+"' or city='"+firstCap3+"' or city= '"+lower+"' and stateid IN (select distinct stateid from dealernetwork where state = '"+reqState+"' )";
//out.println("query "+sql_details);                                       
                    rs_details = conb.getResult(sql_details);               %&gt;                                             &lt;br&gt;               &lt;%
                    boolean dispHead=true;                    while(rs_details.next())                        {                        
                         if(dispHead)                         {                              dispHead = false;               %&gt;              
               &lt;span class="txt07"&gt;                 
                  Listing of addresses corresponding to the selected cities are as&lt;/span&gt;
                              &lt;br&gt;               &lt;% }%&gt;               &lt;br /&gt;
               &lt;table border="0" cellpadding="2" cellspacing="1" width="90%"&gt;
                  &lt;tr&gt;                    &lt;td width="18%" align="right" border
                    bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B5D2CA" class="txt07"&gt;&lt;b&gt;Name&lt;/b&gt;&lt;/td&gt;
                    &lt;td width="82%" align="left" bordercolorlight="#000000"
                    bordercolordark="#000000" bgcolor="#D2E3DE" class="txt07" border&gt;
                       &lt;%                         out.println(rs_details.getString(3).toUpperCase());                       %&gt;
                                           &lt;/td&gt;                  &lt;/tr&gt;                  &lt;tr&gt;                    &lt;%
                         address = ""+rs_details.getString(4);                         if(!(address.equals("null")))
                         {                              String s1 = address+" "+address.toLowerCase();
                              String f1 = (s1.substring(0,1)).toUpperCase();
                              String s2 = s1.substring(1,s1.length());
//                                 address=f1+s2;                              address = address.toUpperCase();
                         }
                         /*                                                if(!(rs_details.getString("address2").equals("null")))
                         {                         address = address +" "+ rs_details.getString("address2");
                         address =address.toLowerCase();                                                  }                        
                         if(!(rs_details.getString("address3").equals("null")))                         {
                         address = address +" "+ rs_details.getString("address3");
                         address =address.toLowerCase();                                                  }*/                    %&gt;
                    &lt;td width="18%" align="right" border
                    bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B5D2CA" class="txt07"&gt;&lt;b&gt;Address&lt;/b&gt;&lt;/td&gt;
                    &lt;td width="82%" align="left" bordercolorlight="#000000"
                    bordercolordark="#000000" bgcolor="#D2E3DE" class="txt07" border&gt;
                       &lt;%if(!address.equals(""))                       {%&gt;&lt;%=address%&gt;&lt;%}%&gt;
                    &lt;/td&gt;                  &lt;/tr&gt;                  &lt;tr&gt;
                    &lt;td width="18%" align="right" border
                    bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B5D2CA" class="txt07"&gt;&lt;b&gt;Phone&lt;/b&gt;&lt;/td&gt;
                    &lt;td width="82%" align="left" bordercolorlight="#000000"
                    bordercolordark="#000000" bgcolor="#D2E3DE" class="txt07" border&gt;
                       &lt;%                         String phone=""+rs_details.getString("phone");
                         if(!(phone.equals("null")))                       {%&gt;                       &lt;%=phone%&gt;&lt;%}else
                       {%&gt;N.A.&lt;%}%&gt;&lt;/td&gt;                  &lt;/tr&gt;
                  &lt;tr&gt;&lt;td&gt;&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;               &lt;/table&gt;              
               &lt;%                    }               }                         }          catch(Exception e)          {               out.println("Error"+e);          }
               %&gt;&lt;/td&gt;          &lt;/tr&gt;          &lt;tr&gt;
             &lt;td colspan="2" align="right"&gt;                                                                         &lt;/td&gt;          &lt;/tr&gt;
        &lt;/table&gt;&lt;/form&gt;

<pre/>
Regards
Ashish Bhatia

modified on Wednesday, June 3, 2009 8:05 AM

AnswerRe: need help geeting a nullpointerexeption Pin
Nagy Vilmos3-Jun-09 2:00
professionalNagy Vilmos3-Jun-09 2:00 
RantRe: need help geeting a nullpointerexeption [modified] Pin
ItIsFinished4-Jun-09 12:13
ItIsFinished4-Jun-09 12:13 
GeneralRe: need help geeting a nullpointerexeption Pin
Nagy Vilmos5-Jun-09 3:46
professionalNagy Vilmos5-Jun-09 3:46 
QuestionMobile Application Pin
cdpace2-Jun-09 23:40
cdpace2-Jun-09 23:40 
AnswerRe: Mobile Application Pin
Nagy Vilmos3-Jun-09 0:08
professionalNagy Vilmos3-Jun-09 0:08 
Questionretrieving selected item from jComboBox in jTable Pin
Denis J. González1-Jun-09 9:16
Denis J. González1-Jun-09 9:16 
AnswerRe: retrieving selected item from jComboBox in jTable Pin
darkdragn1-Jun-09 9:25
darkdragn1-Jun-09 9:25 
GeneralRe: retrieving selected item from jComboBox in jTable Pin
Denis J. González1-Jun-09 9:43
Denis J. González1-Jun-09 9:43 
QuestionMobile Programming Pin
Sourie30-May-09 19:28
Sourie30-May-09 19:28 
AnswerRe: Mobile Programming Pin
raheela12331-May-09 1:22
raheela12331-May-09 1:22 
Questionproblem in do-while loop Pin
kenna18030-May-09 4:58
kenna18030-May-09 4:58 
AnswerRe: problem in do-while loop Pin
raheela12331-May-09 1:15
raheela12331-May-09 1:15 
GeneralRe: problem in do-while loop Pin
kenna18031-May-09 7:04
kenna18031-May-09 7:04 
QuestionUsing NetBeans IDE Pin
Reagan Conservative29-May-09 11:03
Reagan Conservative29-May-09 11:03 
AnswerRe: Using NetBeans IDE Pin
fly90429-May-09 11:32
fly90429-May-09 11:32 
GeneralRe: Using NetBeans IDE Pin
Reagan Conservative29-May-09 11:36
Reagan Conservative29-May-09 11:36 
GeneralRe: Using NetBeans IDE Pin
fly90429-May-09 11:45
fly90429-May-09 11:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.