Insert-JDBC
inserting into database using jdbc Statement
JDBC insertion using Statement
/** 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.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(); for (int i = 0; i < 100; i++) { stmt.executeQuery(sqlQuery + "'player" + i + "' ,'" + (i + 100) + "' )"); conn.commit(); // System.out.println("inserting following record data into team \n'player"+ // i + "','"+(i+100)+"'" +"\n committed"); } 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 (Exception e) { System.err.println("Exception: " + e.getMessage()); } finally { if (conn != null) { try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } } } //output /** ----------------------------------- Number: 100 Name: player0 ----------------------------------- ----------------------------------- Number: 100 Name: player0 ----------------------------------- ----------------------------------- Number: 100 Name: player0 ----------------------------------- ----------------------------------- Number: 101 Name: player1 ----------------------------------- ----------------------------------- Number: 102 Name: player2 ----------------------------------- ----------------------------------- Number: 103 Name: player3 ----------------------------------- ----------------------------------- Number: 104 Name: player4 ----------------------------------- ----------------------------------- Number: 105 Name: player5 ----------------------------------- ----------------------------------- Number: 106 Name: player6 ----------------------------------- ----------------------------------- Number: 107 Name: player7 ----------------------------------- ----------------------------------- Number: 108 Name: player8 ----------------------------------- ----------------------------------- Number: 109 Name: player9 ----------------------------------- ----------------------------------- Number: 110 Name: player10 ----------------------------------- ----------------------------------- Number: 111 Name: player11 ----------------------------------- ----------------------------------- Number: 112 Name: player12 ----------------------------------- ----------------------------------- Number: 113 Name: player13 ----------------------------------- ----------------------------------- Number: 114 Name: player14 ----------------------------------- ----------------------------------- Number: 115 Name: player15 ----------------------------------- ----------------------------------- Number: 116 Name: player16 ----------------------------------- ----------------------------------- Number: 117 Name: player17 ----------------------------------- ----------------------------------- Number: 118 Name: player18 ----------------------------------- ----------------------------------- Number: 119 Name: player19 ----------------------------------- ----------------------------------- Number: 120 Name: player20 ----------------------------------- ----------------------------------- Number: 121 Name: player21 ----------------------------------- ----------------------------------- Number: 122 Name: player22 ----------------------------------- ----------------------------------- Number: 123 Name: player23 ----------------------------------- ----------------------------------- Number: 124 Name: player24 ----------------------------------- ----------------------------------- Number: 125 Name: player25 ----------------------------------- ----------------------------------- Number: 126 Name: player26 ----------------------------------- ----------------------------------- Number: 127 Name: player27 ----------------------------------- ----------------------------------- Number: 128 Name: player28 ----------------------------------- ----------------------------------- Number: 129 Name: player29 ----------------------------------- ----------------------------------- Number: 130 Name: player30 ----------------------------------- ----------------------------------- Number: 131 Name: player31 ----------------------------------- ----------------------------------- Number: 132 Name: player32 ----------------------------------- ----------------------------------- Number: 133 Name: player33 ----------------------------------- ----------------------------------- Number: 134 Name: player34 ----------------------------------- ----------------------------------- Number: 135 Name: player35 ----------------------------------- ----------------------------------- Number: 136 Name: player36 ----------------------------------- ----------------------------------- Number: 137 Name: player37 ----------------------------------- ----------------------------------- Number: 138 Name: player38 ----------------------------------- ----------------------------------- Number: 139 Name: player39 ----------------------------------- ----------------------------------- Number: 140 Name: player40 ----------------------------------- ----------------------------------- Number: 141 Name: player41 ----------------------------------- ----------------------------------- Number: 142 Name: player42 ----------------------------------- ----------------------------------- Number: 143 Name: player43 ----------------------------------- ----------------------------------- Number: 144 Name: player44 ----------------------------------- ----------------------------------- Number: 145 Name: player45 ----------------------------------- ----------------------------------- Number: 146 Name: player46 ----------------------------------- ----------------------------------- Number: 147 Name: player47 ----------------------------------- ----------------------------------- Number: 148 Name: player48 ----------------------------------- ----------------------------------- Number: 149 Name: player49 ----------------------------------- ----------------------------------- Number: 150 Name: player50 ----------------------------------- ----------------------------------- Number: 151 Name: player51 ----------------------------------- ----------------------------------- Number: 152 Name: player52 ----------------------------------- ----------------------------------- Number: 153 Name: player53 ----------------------------------- ----------------------------------- Number: 154 Name: player54 ----------------------------------- ----------------------------------- Number: 155 Name: player55 ----------------------------------- ----------------------------------- Number: 156 Name: player56 ----------------------------------- ----------------------------------- Number: 157 Name: player57 ----------------------------------- ----------------------------------- Number: 158 Name: player58 ----------------------------------- ----------------------------------- Number: 159 Name: player59 ----------------------------------- ----------------------------------- Number: 160 Name: player60 ----------------------------------- ----------------------------------- Number: 161 Name: player61 ----------------------------------- ----------------------------------- Number: 162 Name: player62 ----------------------------------- ----------------------------------- Number: 163 Name: player63 ----------------------------------- ----------------------------------- Number: 164 Name: player64 ----------------------------------- ----------------------------------- Number: 165 Name: player65 ----------------------------------- ----------------------------------- Number: 166 Name: player66 ----------------------------------- ----------------------------------- Number: 167 Name: player67 ----------------------------------- ----------------------------------- Number: 168 Name: player68 ----------------------------------- ----------------------------------- Number: 169 Name: player69 ----------------------------------- ----------------------------------- Number: 170 Name: player70 ----------------------------------- ----------------------------------- Number: 171 Name: player71 ----------------------------------- ----------------------------------- Number: 172 Name: player72 ----------------------------------- ----------------------------------- Number: 173 Name: player73 ----------------------------------- ----------------------------------- Number: 174 Name: player74 ----------------------------------- ----------------------------------- Number: 175 Name: player75 ----------------------------------- ----------------------------------- Number: 176 Name: player76 ----------------------------------- ----------------------------------- Number: 177 Name: player77 ----------------------------------- ----------------------------------- Number: 178 Name: player78 ----------------------------------- ----------------------------------- Number: 179 Name: player79 ----------------------------------- ----------------------------------- Number: 180 Name: player80 ----------------------------------- ----------------------------------- Number: 181 Name: player81 ----------------------------------- ----------------------------------- Number: 182 Name: player82 ----------------------------------- ----------------------------------- Number: 183 Name: player83 ----------------------------------- ----------------------------------- Number: 184 Name: player84 ----------------------------------- ----------------------------------- Number: 185 Name: player85 ----------------------------------- ----------------------------------- Number: 186 Name: player86 ----------------------------------- ----------------------------------- Number: 187 Name: player87 ----------------------------------- ----------------------------------- Number: 188 Name: player88 ----------------------------------- ----------------------------------- Number: 189 Name: player89 ----------------------------------- ----------------------------------- Number: 190 Name: player90 ----------------------------------- ----------------------------------- Number: 191 Name: player91 ----------------------------------- ----------------------------------- Number: 192 Name: player92 ----------------------------------- ----------------------------------- Number: 193 Name: player93 ----------------------------------- ----------------------------------- Number: 194 Name: player94 ----------------------------------- ----------------------------------- Number: 195 Name: player95 ----------------------------------- ----------------------------------- Number: 196 Name: player96 ----------------------------------- ----------------------------------- Number: 197 Name: player97 ----------------------------------- ----------------------------------- Number: 198 Name: player98 ----------------------------------- ----------------------------------- Number: 199 Name: player99 ----------------------------------- ----------------------------------- Number: 100 Name: player0 ----------------------------------- ----------------------------------- Number: 101 Name: player1 ----------------------------------- ----------------------------------- Number: 102 Name: player2 ----------------------------------- ----------------------------------- Number: 103 Name: player3 ----------------------------------- ----------------------------------- Number: 104 Name: player4 ----------------------------------- ----------------------------------- Number: 105 Name: player5 ----------------------------------- ----------------------------------- Number: 106 Name: player6 ----------------------------------- ----------------------------------- Number: 107 Name: player7 ----------------------------------- ----------------------------------- Number: 108 Name: player8 ----------------------------------- ----------------------------------- Number: 109 Name: player9 ----------------------------------- ----------------------------------- Number: 110 Name: player10 ----------------------------------- ----------------------------------- Number: 111 Name: player11 ----------------------------------- ----------------------------------- Number: 112 Name: player12 ----------------------------------- ----------------------------------- Number: 113 Name: player13 ----------------------------------- ----------------------------------- Number: 114 Name: player14 ----------------------------------- ----------------------------------- Number: 115 Name: player15 ----------------------------------- ----------------------------------- Number: 116 Name: player16 ----------------------------------- ----------------------------------- Number: 117 Name: player17 ----------------------------------- ----------------------------------- Number: 118 Name: player18 ----------------------------------- ----------------------------------- Number: 119 Name: player19 ----------------------------------- ----------------------------------- Number: 120 Name: player20 ----------------------------------- ----------------------------------- Number: 121 Name: player21 ----------------------------------- ----------------------------------- Number: 122 Name: player22 ----------------------------------- ----------------------------------- Number: 123 Name: player23 ----------------------------------- ----------------------------------- Number: 124 Name: player24 ----------------------------------- ----------------------------------- Number: 125 Name: player25 ----------------------------------- ----------------------------------- Number: 126 Name: player26 ----------------------------------- ----------------------------------- Number: 127 Name: player27 ----------------------------------- ----------------------------------- Number: 128 Name: player28 ----------------------------------- ----------------------------------- Number: 129 Name: player29 ----------------------------------- ----------------------------------- Number: 130 Name: player30 ----------------------------------- ----------------------------------- Number: 131 Name: player31 ----------------------------------- ----------------------------------- Number: 132 Name: player32 ----------------------------------- ----------------------------------- Number: 133 Name: player33 ----------------------------------- ----------------------------------- Number: 134 Name: player34 ----------------------------------- ----------------------------------- Number: 135 Name: player35 ----------------------------------- ----------------------------------- Number: 136 Name: player36 ----------------------------------- ----------------------------------- Number: 137 Name: player37 ----------------------------------- ----------------------------------- Number: 138 Name: player38 ----------------------------------- ----------------------------------- Number: 139 Name: player39 ----------------------------------- ----------------------------------- Number: 140 Name: player40 ----------------------------------- ----------------------------------- Number: 141 Name: player41 ----------------------------------- ----------------------------------- Number: 142 Name: player42 ----------------------------------- ----------------------------------- Number: 143 Name: player43 ----------------------------------- ----------------------------------- Number: 144 Name: player44 ----------------------------------- ----------------------------------- Number: 145 Name: player45 ----------------------------------- ----------------------------------- Number: 146 Name: player46 ----------------------------------- ----------------------------------- Number: 147 Name: player47 ----------------------------------- ----------------------------------- Number: 148 Name: player48 ----------------------------------- ----------------------------------- Number: 149 Name: player49 ----------------------------------- ----------------------------------- Number: 150 Name: player50 ----------------------------------- ----------------------------------- Number: 151 Name: player51 ----------------------------------- ----------------------------------- Number: 152 Name: player52 ----------------------------------- ----------------------------------- Number: 153 Name: player53 ----------------------------------- ----------------------------------- Number: 154 Name: player54 ----------------------------------- ----------------------------------- Number: 155 Name: player55 ----------------------------------- ----------------------------------- Number: 156 Name: player56 ----------------------------------- ----------------------------------- Number: 157 Name: player57 ----------------------------------- ----------------------------------- Number: 158 Name: player58 ----------------------------------- ----------------------------------- Number: 159 Name: player59 ----------------------------------- ----------------------------------- Number: 160 Name: player60 ----------------------------------- ----------------------------------- Number: 161 Name: player61 ----------------------------------- ----------------------------------- Number: 162 Name: player62 ----------------------------------- ----------------------------------- Number: 163 Name: player63 ----------------------------------- ----------------------------------- Number: 164 Name: player64 ----------------------------------- ----------------------------------- Number: 165 Name: player65 ----------------------------------- ----------------------------------- Number: 166 Name: player66 ----------------------------------- ----------------------------------- Number: 167 Name: player67 ----------------------------------- ----------------------------------- Number: 168 Name: player68 ----------------------------------- ----------------------------------- Number: 169 Name: player69 ----------------------------------- ----------------------------------- Number: 170 Name: player70 ----------------------------------- ----------------------------------- Number: 171 Name: player71 ----------------------------------- ----------------------------------- Number: 172 Name: player72 ----------------------------------- ----------------------------------- Number: 173 Name: player73 ----------------------------------- ----------------------------------- Number: 174 Name: player74 ----------------------------------- ----------------------------------- Number: 175 Name: player75 ----------------------------------- ----------------------------------- Number: 176 Name: player76 ----------------------------------- ----------------------------------- Number: 177 Name: player77 ----------------------------------- ----------------------------------- Number: 178 Name: player78 ----------------------------------- ----------------------------------- Number: 179 Name: player79 ----------------------------------- ----------------------------------- Number: 180 Name: player80 ----------------------------------- ----------------------------------- Number: 181 Name: player81 ----------------------------------- ----------------------------------- Number: 182 Name: player82 ----------------------------------- ----------------------------------- Number: 183 Name: player83 ----------------------------------- ----------------------------------- Number: 184 Name: player84 ----------------------------------- ----------------------------------- Number: 185 Name: player85 ----------------------------------- ----------------------------------- Number: 186 Name: player86 ----------------------------------- ----------------------------------- Number: 187 Name: player87 ----------------------------------- ----------------------------------- Number: 188 Name: player88 ----------------------------------- ----------------------------------- Number: 189 Name: player89 ----------------------------------- ----------------------------------- Number: 190 Name: player90 ----------------------------------- ----------------------------------- Number: 191 Name: player91 ----------------------------------- ----------------------------------- Number: 192 Name: player92 ----------------------------------- ----------------------------------- Number: 193 Name: player93 ----------------------------------- ----------------------------------- Number: 194 Name: player94 ----------------------------------- ----------------------------------- Number: 195 Name: player95 ----------------------------------- ----------------------------------- Number: 196 Name: player96 ----------------------------------- ----------------------------------- Number: 197 Name: player97 ----------------------------------- ----------------------------------- Number: 198 Name: player98 ----------------------------------- ----------------------------------- Number: 199 Name: player99 ----------------------------------- **/
Please send comments to
vgdarur.javafive@blogger.com
Copyright © 2008 - iForeRunner.com
http://www.iforerunner.com/