Biblioteca Java - Rev 3
Subversion Repositories:
Êþº¾ . lab/scd/db/jdbc10/TestTranzactii java/lang/Object conn Ljava/sql/Connection; stat Ljava/sql/Statement; <init> ()VExceptions java/lang/Exception Codecom.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; 1 2 0 3 5 LineNumberTable LocalVariableTable this "Llab/scd/db/jdbc10/TestTranzactii; testTranzactie (Z)V = setAutoCommit ? < 0 @ +INSERT INTO STOC VALUES ('produs A' , 2500) B java/sql/Statement D executeUpdate (Ljava/lang/String;)I F G E H java/sql/SQLException J Eroare update. L ,K N +INSERT INTO STOC VALUES ('produs B' , 7900) P commit R0 S printStackTrace UK V rollback X0 Y simulateError Z ex Ljava/sql/SQLException; e afiseazaTabel SELECT * FROM STOC; a executeQuery ((Ljava/lang/String;)Ljava/sql/ResultSet; c d E e PROD g java/sql/ResultSet i getString &(Ljava/lang/String;)Ljava/lang/String; k l j m PRET o getInt q G j r java/lang/StringBuffer t Produs: vu N append ,(Ljava/lang/String;)Ljava/lang/StringBuffer; y zu { Pret: } (I)Ljava/lang/StringBuffer; y u toString ()Ljava/lang/String; u next ()Z j rs Ljava/sql/ResultSet; pname Ljava/lang/String; ppret I main ([Ljava/lang/String;)V; < `V args [Ljava/lang/String; t Ljava/lang/Exception;SourceFile TestTranzactii.java !k #*· ¸ W¸ L² &(¶ .*+¹ 4 µ 6± 7" ! 8 # 9 : ; < Ó S*´ >¹ A *´ 6C¹ I W » KYM· O¿*´ 6Q¹ I W*´ >¹ T § M,¶ W*´ >¹ Z § N-¶ W± < < K A M M K 7 . &( + , $ . 0 1 < 3 = 5 A 7 M 8 R < 8 * S 9 : S [ \ = ] ^ N _ ^ `K ª J*´ 6b¹ f L§ 4+h¹ n M+p¹ s >² &» uYw· x,¶ |~¶ | ¶ ¶ ¶ .+¹ ÿɱ 7 ? A B C ! D @ A I G 8 * J 9 : > ( ! t » Y· L+¶ +¶ § L+¶ ± 7 L N P R S U 8 : _