Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa Java-Beginners java plus database

Have Programming Question? Ask it here!
 
 
 


Anita Thapa
java plus database
3 Answer(s)      5 years and 10 months ago
Posted in : Java Beginners



Advertisement
View Answers

November 17, 2008 at 11:52 PM


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
)


November 17, 2008 at 11:52 PM


"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"));




}
}


November 17, 2008 at 11:56 PM


For more information on JDBC MySql visit to :

http://roseindia.net/jdbc/

Thanks


Related Tutorials/Questions & Answers:
java plus database - Java Beginners
java plus database  kathmandu Sports Club In order to have more.... Module diagram 4. Java-program   Hi friend, Code to solve the problem : database table "city" CREATE TABLE `city
Java bigdecimal plus example
Java bigdecimal plus example       Example below demonstrates working of bigdecimal class plus... method return type is plus of this.object or simply +this.object. Scale
Advertisements
SQL Plus
the relational database(DML,DCL,DDL). SQL*PLUS commands are used to format query...SQL Plus  What is SQL Plus?   Hi, Here is the answer, SQL*PLUS is a command line tool where as SQL and PL/SQL language interface
Java bigdecimal plus method example
Java bigdecimal plus method example   ...); Java_bigdecimal_plus_example.java...; import java.math.RoundingMode; public class Java_bigdecimal_plus
deletion in b plus tree
deletion in b plus tree  please help me out!! i need a code for deletion on b-plus tree in JAVA. its urgent please help
Importing data into sql plus from a text file...
Importing data into sql plus from a text file...  How to import a text file into oracle 10g enterprise edition directly to create tables and data
Importing data into sql plus from a text file...
Importing data into sql plus from a text file...  How to import a text file into oracle 10g enterprise edition directly to create tables and data
java database
java database  help me with this...i never learn build java database... to design and implement objects needed for a program that maintains a database.../teacher information, search it, alter it, etc. The database is maintained as a list
Database,Java
Database,Java  help me for the following things if one customer... me the how to write the query in MySQL database and i want coding for this one in Java.because i am using Java as the front end.   1)page.jsp: <
java and database
java and database  sir i want to prepare a sign in form and i want to check that user name is exist or not in database if it is exist in database then return it is allready exist otherwise it is registered in data base thank u
JAVA DATABASE CONNECTION WITH JTABLE
JAVA DATABASE CONNECTION WITH JTABLE  HOw To Load Database Contents From Access Database to JTable without using Vector
Map java Object to database.
Map java Object to database.  How do you map Java Objects with Database tables
Database programming - Java Beginners
Database programming  How to do a Database programing with Balanced Multiway Tree(B+ Tree,not Binary Tree) in java
java and database - Java Beginners
java and database  code to read a csv file  Hi Friend, We have used POI Library to read the csv file in java: import java.io.*; import org.apache.poi.hpsf.*; import org.apache.poi.hssf.usermodel.*; import
java database connection - JDBC
java database connection  sir i want to join my project with MS access database. i am making my project in netbeans.please tell me the coding to do... the data into the MS Access database and retrieve the data from the database table
java database connection
java database connection  package com.tsi.constants; public class Constant { public static final String DRIVER = "oracle.jdbc.driver.OracleDriver"; public static final String DBURL = "jdbc:oracle:thin
java database connection
java database connection  package com.tsi.constants; public class Constant { public static final String DRIVER = "oracle.jdbc.driver.OracleDriver"; public static final String DBURL = "jdbc:oracle:thin
unable to connect database in java
unable to connect database in java  Hello Everyone! i was trying to connect database with my application by using java but i am unable to connect... i was using this code.... try { Driver d=(Driver)Class.forName
java database connection - Struts
java database connection  how to connect a database in struts program?  First Add two jar file1> commons-dbcp-1.2.x.jar2> mysql...; value="jdbc:mysql:///database_name?autoReconnect=true"
java database error - JDBC
java database error  hi all i am writing one swing application where i want to insert data into database(MS-Access) but dont know how to do... the following code to insert the data into MS-Access database: import java.sql.
Java database connectivity
Java database connectivity  Hi sir I need a code to create an application where user enter name in text box and that should be stored in database. Plz help me out its very urgent.   import java.sql.*; import java.awt.
unable to connect database in java
unable to connect database in java  Hello Everyone! i was trying to connect database with my application by using java but i am unable to connect... created. 6) Restart your compiler and compile your java code. For Inserting Data
innerclass and database - Java Beginners
innerclass and database  program using innerclass to implement numerical bisection operation to call a procedure to store and update data in a database
Database - Java Beginners
Database  How to do database connection when using weblogic server? Any specific condition or difference
code for database deadlock sicuation in java
code for database deadlock sicuation in java  how to prepare code for database deadlock situation in java(JDBC
Connection to database - Java Beginners
on a Project on Jsp We hve some JSP Pages & trying to connect to our Database . We are using SQL server 2000 ? We are not able to connect our database Tables.../connect_jsp_with_mysql.shtml Because, we didn't use sql server 2000 database
java servlets with database interaction
java servlets with database interaction  hai friends i am doing a web application in that i have a registration page, after successfully registered... Servlet with database and insert data import java.io.*; import
Connecting to MYSQL Database in Java
Connecting to MYSQL Database in Java  I've tried executing the code... to the database"); conn.close(); System.out.println("Disconnected from database"); } catch (Exception e) { System.out.println("Error
database connection by using java bean
database connection by using java bean  i need a code for bean class to connect to mysql database. subsequently to use dis bean class whereever i need 2 connect 2 database
Sum database colum in java
Sum database colum in java  please i have two columns-col1 and col2, col1 contain item and col2 contain the quantity of the item columns... the database to sum the Items and display output so that it will be like
java database pblm - Java Beginners
java database pblm  Hi, I have 5 records in database with the same ID. I want to delete third record. what should i do.plzz help me. thank u... record from the database. the following code may be useful for u. ResultSet rs
Java Connection to Oracle database
Java Connection to Oracle database  HI I am ubable to connnect jdbc to Oracle database.i had gone to control panel >>Administrative tool>>>Data source,in that forDNS name i typed Oracle and in TNS i culdn't
database connectivity in java - JDBC
database connectivity in java  import java.io.*; import java.awt.*; import javax.swing.*; import java.awt.event.*; import java.sql.*; class Project implements ActionListener { JFrame f; JPanel p1,p2,p3; JTabbedPane
Import Data to SQL database in Java
Import Data to SQL database in Java  Hi, I'm a beginner and I'm wondering how to Import Data to SQL database in Java? Thanks (Platform: Eclipse/SQL
Map Java Objects with Database tables
Map Java Objects with Database tables  How to map Java Objects with Database tables?   First write Java domain objects ie. beans with setter and getter methods. Then map java class to table and database columns to Java
Subtract a value in the database from java
Subtract a value in the database from java   Hi, i want to know how to subtract a value on a database. im using JDBC connection from access and i want to decrement the value of table "quantity" of 1 each time it passes a loop my
ajax database in opentaps - Java Beginners
ajax database in opentaps  Hi, Here I am facing problem in implementing ajax in opentaps.I want to create a drop down menu using ajax in opentaps.And I want to access the values from database using ajax in java(opentaps).So
Accessing database with JDBC via Java
Accessing database with JDBC via Java  How to access a database with JDBC via Java application?   Accessing database with JDBC through Java JDBC Example to access Database import java.sql.*; public class JdbcConnect
java gui database - Java Beginners
java gui database  I have eight files. Each file has exactly same number(say 100) of entries. Each corresponding entry of all files correspond to one... the data on command line but I do not know how to display the same using java
Problems connecting to a database. Java/SQLite
Problems connecting to a database. Java/SQLite  `print("try { con = DriverManager.getConnection("jdbc:sqlite:db/Freepark.sqlite"); } catch... on an SQL database but i am having problems connecting to it, I think the problem
Java Barcode Program with Oracle database
Java Barcode Program with Oracle database  Hi Everyone, I need help... no and serial no of the item being scanned to Oracle 10g database. I dont have any idea abt this...Please can anyone give me some idea. Do I need to buy Java
database connection in javascript - Java Beginners
database connection in javascript  hi, How can i connect the database and insert the data's by using javascript. thank u in advance. ragards, sakthi
Database
Database  How to represent data from database in a tree?   Please visit the following link: Retrieve data from database in tree using Java Swing
DATABASE
DATABASE  How can i get combo box values from database?? or how can i get values in the drop down menu of the html which is similar to dat of combo box in java - from database
database
database  I wanted to know if it is possible to establish database connection on a remote pc with mysql using java swings from netbeans and then create a database on the remote pc.... Kindly help me
database
links: Connect JSP with database Mysql Connect Java with database Mysql...database  tell me use about database and give me a small program.   It is secure and can easily be accessed, managed, and updated. Moreover
database
links: Connect JSP with database Mysql Connect Java with database Mysql...database  tell me use about database and give me a small program.   It is secure and can easily be accessed, managed, and updated. Moreover
database
links: Connect JSP with database Mysql Connect Java with database Mysql...database  tell me use about database and give me a small program.   It is secure and can easily be accessed, managed, and updated. Moreover
Database
Database  from java code i have to retrieve some data from a database, which is present in a different timezone. Scenario :- My database... in database timezone is 9PM 15APR2012. I want to retrieve something from database
Link To Database with JComboBox - Java Beginners
Link To Database with JComboBox  sir As ur Source Code i have Load course names from Access Database in to JComboBox but now I want to do ,when i... SwingFrame(); } public SwingFrame(){ JFrame f = new JFrame("Frame in Java Swing
Advertisements
 

 

 

DMCA.com