java plus database

Hi friend,

Code to solve the problem :

database table "city"

CREATE TABLE `city` (
`id` bigint(20) default NULL,
`city` varchar(150) default NULL,
`zip` bigint(20) default NULL,
`sport_id` bigint(20) default NULL,
`sport_name` varchar(150) default NULL
)

"city.java"

import java.io.*;
import java.util.*;
import java.sql.*;

class city
{
public static void main(String[] args) throws Exception
{
InputStreamReader isr = new InputStreamReader(System.in);
BufferedReader bufReader = new BufferedReader(isr);

ArrayList al = new ArrayList();

System.out.println("MySQL Connect Example.");
Connection conn = null;
String url = "jdbc:mysql://localhost:3306/";;
String dbName = "city";
String driver = "com.mysql.jdbc.Driver";
String userName = "root";
String password = "root";


String option="";

do
{
System.out.println("Enter Options");
System.out.println("a. Enter a number");
System.out.println("b. Stop the program");

option = bufReader.readLine();
if(option.equals("a"))
{
System.out.println("Enter new Number");

Integer number = Integer.parseInt(bufReader.readLine());
//System.out.println("number : " + number);

try {
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url+dbName,userName,password);
System.out.println("Connected to the database");

String query = "SELECT count(*) FROM city where id="+number;
int i=0;

do
{
Statement st = conn.createStatement();
//System.out.println("query "+ query);
ResultSet res = st.executeQuery("SELECT count(*) FROM city where id="+number);
while (res.next()) {
i = res.getInt(1);
if(i>0)
{
System.out.println(i+" number already exists");
System.out.println("Enter again new Number");

number = Integer.parseInt(bufReader.readLine());
}
else
{
System.out.println("Enter Zipcode");

Integer zipcode = Integer.parseInt(bufReader.readLine());
//System.out.println("zipcode : " + zipcode);

try
{
Statement st1 = conn.createStatement();
//System.out.println("query "+ query);
ResultSet res1 = st.executeQuery("SELECT * FROM city where zip="+zipcode);
while (res1.next()) {
System.out.println("City : " + res1.getString(2));
System.out.println("Sport id : " + res1.getString(4));
System.out.println("Sport Name : " + res1.getString(5));
}
res1.close();
}
catch(Exception e)
{
}

}

}

//res.close();
}while(i!=0);






conn.close();

System.out.println("Disconnected from database");
} catch (Exception e) {
//e.printStackTrace();
}

}



if(option.equals("b"))
{
System.exit(0);


}
}
while(!option.equals("b"));




}
}

For more information on JDBC MySql visit to :

http://roseindia.net/jdbc/

Thanks