inserting into database using jdbc Statement

JDBC insertion using Prepared Statement

/**
Darur Venugopal
Arun Mavuram
Sai manohar
Ranadheerchoudhary

Vinay Kallepu has executed this program and It worked well in their machines
some sql statements may have to be executed prior to this program in oracle
below:

drop table team;
create table team( 
name varchar2(30),
sino varchar2(5)
)

select * from team;

insert into team values( 'player0' ,'101' )
delete from team;
commit;

**/

package com.database.orcl.conn;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class JdbcInsertDemo {

public static void main(String[] args) {
		Connection conn = null;
		try {

Class.forName("oracle.jdbc.driver.OracleDriver");// loaded the
																// driver
			// Connect with a url string
			conn = DriverManager.getConnection(
					"jdbc:oracle:thin:@localhost:1521:xe", "hr", "hr");// connection
																		// established
			// Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;//1
			//
			// // Connect with a url string
			// conn = DriverManager.getConnection("jdbc:odbc:oracle","hr","hr");

String sqlQuery = "insert into team values(?,?)";
			
			Statement stmt = conn.createStatement();
			stmt.executeQuery("DELETE FROM TEAM ");
			for (int i = 0; i < 100; i++) {
				
				System.out.println("~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"+i+"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~");
				PreparedStatement preparedStmt = conn.prepareStatement(sqlQuery);
				
				preparedStmt.setString(1, "Arun"+(i+100));
				preparedStmt.setString(2, ""+(i+200));
				preparedStmt.executeUpdate();
				
				 
			}
			conn.commit();
			ResultSet resultSet = stmt.executeQuery("SELECT * FROM TEAM ");
			while (resultSet.next()) {
				System.out.println("-----------------------------------");
				System.out.println("Number: " + resultSet.getString(2));
				System.out.println("Name: " + resultSet.getString(1));
				System.out.println("-----------------------------------");
			}

} catch (SQLException e) {
			System.err.println("Exception: " + e.getMessage());
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			if (conn != null) {
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		}
	}

}

Please send comments to vgdarur.javafive@blogger.com