Biblioteca Java - Rev 3

Subversion Repositories:

(root)/JavaSE/ExempleJdbc/src/lab/scd/db/jdb20/BatchUpdate.class

Blame - Last modification - View Log -

Êþº¾.]
lab/scd/db/jdb20/BatchUpdate

java/lang/Object
<init>
()V
Code

LineNumberTable
LocalVariableTable
this
Llab/scd/db/jdb20/BatchUpdate;
main
([Ljava/lang/String;)V
com.mysql.jdbc.Driver
java/lang/Class
forName
%(Ljava/lang/String;)Ljava/lang/Class;

5jdbc:mysql://localhost/testdb?user=root&password=root
java/sql/DriverManager

getConnection
)(Ljava/lang/String;)Ljava/sql/Connection;

java/lang/System 
out
Ljava/io/PrintStream;"#   !$
$Conexiune la baza de date realizata.&
java/io/PrintStream(
println
(Ljava/lang/String;)V*+
),
java/sql/Connection.

setAutoCommit
(Z)V01/2
createStatement
()Ljava/sql/Statement;45/6
*INSERT INTO STOC VALUES('Amaretto1', 9898)8
java/sql/Statement:
addBatch<+;=
)INSERT INTO STOC VALUES('Hazelnut1', 900)?
-INSERT INTO STOC VALUES('Amaretto_decaf', 77)A
'INSERT INTO STOC VALUES('Bygtoac1', 69)C
executeBatch
()[IEF;G
java/lang/ExceptionI
printStackTraceK
JL
rollbackN/O
args
[Ljava/lang/String;
con
Ljava/sql/Connection;
stmt
Ljava/sql/Statement;
updateCounts
[I

e
Ljava/lang/Exception;

SourceFile
BatchUpdate.java!

/

*·     ±



   

`¸W¸L²%'¶-+¹3+¹7
M,9¹>,@¹>,B¹>,D¹>,¹H
N§M,¶M+¹P
§L+¶M±LLJZZJ
B #'")*+2-:/B2L4M6Q9Z<[>_@>`QRNST
"*UVIWXM
YZ[YZ

[\