QuestionAsk Questions?
Sujitha
Hi here is my code. If i run this code I am getting exception as java.lang.NllPointerException. I think its because of at the line Arrays.sort(route_number1). Please suggest some solution for this.
<html>
<body>
<%@ page import="java.io.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.util.Arrays"%>
<%@ page import="java.text.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<%@ page language="java"%>
<%@ page session="true"%>
<%
Connection connection=null;
PreparedStatement prepared_statement=null;
ResultSet result_set=null;
String route_number[]=new String[1000];
String route_number1[]=new String[1000];
route_number1[0]=" ";
int counter=0,count=0;
try
{
String url="jdbc:mysql://localhost:3306/bus";
Class.forName("com.mysql.jdbc.Driver");
connection=DriverManager.getConnection(url,"mysql","mysql");
response.setContentType("text/html");
prepared_statement=connection.prepareStatement("select * from bus_tab");
result_set=prepared_statement.executeQuery();
while(result_set.next())
{
route_number[counter]=result_set.getString("route_number");
counter++;
}
int k=0;
/* The following for loop is to identify the duplicate values in the source and replace it as null*/
for(int i=0;i<counter;i++)
{
for(int j=i+1;j<counter;j++)
{
if(route_number[i].equals(route_number[j]))
{
route_number[j]=" ";
}
}
}
/*The following for loop is to remove the null from the source array*/
for(int i=0;i<counter;i++)
{
if(!(route_number[i].equals(" ")))
{
route_number1[k]=route_number[i];
k++;
}
}
Arrays.sort(route_number1);
%>
<form action="../bus/route_search.jsp">
<table width="297" height="123" border="0">
<tr>
<th height="63"><p class="style5">Route-wise Information</p>
</th>
</tr>
<tr>
<td width="100" bgcolor="fc8895">Route No:</td>
<td width="96" bgcolor="fc8895"><select name="route_number">
<%
for(count=0;count<k;count++)
{
%>
<option><%out.println(route_number1[count]);%></option>
<%
}
%>
</select></td>
</tr>
<tr bgcolor="#FC8895">
<td>
<input type="submit" name="Submit" value="Search">
</td>
<td>
<input type="reset" name="Reset" value="Reset">
</td>
</tr>
</table>
<p> </p>
</form>
<%
}
catch(Exception e)
{
out.println("Exception: "+e);
}
finally
{
connection.close();
prepared_statement.close();
result_set.close();
}
%>
</body>
</html>
View Answers
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
