Biblioteca Java - Rev 3

Subversion Repositories:

(root)/JavaSE/ExempleJdbc/src/lab/scd/db/jdbc10/TestModificaTabel.class

Blame - Last modification - View Log -

Êþº¾.|
#lab/scd/db/jdbc10/TestModificaTabel

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

LineNumberTable
LocalVariableTable
this
%Llab/scd/db/jdbc10/TestModificaTabel;
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.
createStatement
()Ljava/sql/Statement;01/2
BUPDATE STOC SET PROD = 'prod modificat'WHERE PROD LIKE 'PRODUS A';4
java/sql/Statement6

executeUpdate
(Ljava/lang/String;)I897:
SELECT * FROM STOC;<
executeQuery
((Ljava/lang/String;)Ljava/sql/ResultSet;>?7@
PRODB
java/sql/ResultSetD
   getString
&(Ljava/lang/String;)Ljava/lang/String;FGEH
PRETJ
getIntL9EM
java/lang/StringBufferO
Produs:Q+
PS
append
,(Ljava/lang/String;)Ljava/lang/StringBuffer;UV
PW
 Pret:Y
(I)Ljava/lang/StringBuffer;U[
P\
toString
()Ljava/lang/String;^_
P`
next
()ZbcEd
java/lang/Exceptionf
printStackTraceh
gi
args
[Ljava/lang/String;
conn
Ljava/sql/Connection;
stat
Ljava/sql/Statement;
updateString
Ljava/lang/String;
rs
Ljava/sql/ResultSet;
pname
ppret

I

e
Ljava/lang/Exception;

SourceFile
TestModificaTabel.java!

/

*·       ±



   

-}¸W¸L²%'¶-+¹3
M5N,-¹;W,=¹A:§:C¹I:K¹N6²%»PYR·T¶XZ¶X¶]¶a¶-¹e
šÿ§L+¶j±
wwg
> #%*&-0/30>1I2j/w5x6|9R}klkmn
\opYqr0Gst>,urI!vwxxy

z{