Biblioteca Java - Rev 3
Subversion Repositories:
Êþº¾ . %lab/scd/db/jdbc10/TestModificaTabelPS java/lang/Object <init> ()V CodeLineNumberTable LocalVariableTable this 'Llab/scd/db/jdbc10/TestModificaTabelPS; 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 * +) , *UPDATE STOC SET PROD = ?WHERE PROD LIKE ?; . java/sql/Connection 0 prepareStatement 0(Ljava/lang/String;)Ljava/sql/PreparedStatement; 2 3 1 4 PRODUS C 6 java/sql/PreparedStatement 8 setString (ILjava/lang/String;)V : ; 9 < prod modificat > executeUpdate ()I @ A 9 B SELECT * FROM STOC; D executeQuery ((Ljava/lang/String;)Ljava/sql/ResultSet; F G 9 H PROD J java/sql/ResultSet L getString &(Ljava/lang/String;)Ljava/lang/String; N O M P PRET R getInt (Ljava/lang/String;)I T U M V java/lang/StringBuffer X Produs: Z +Y \ append ,(Ljava/lang/String;)Ljava/lang/StringBuffer; ^ _Y ` Pret: b (I)Ljava/lang/StringBuffer; ^ dY e toString ()Ljava/lang/String; g hY i next ()Z k l M m java/lang/Exception o printStackTrace qp r args [Ljava/lang/String; conn Ljava/sql/Connection; updateString Ljava/lang/String; stat Ljava/sql/PreparedStatement; rs Ljava/sql/ResultSet; pname ppret I e Ljava/lang/Exception;SourceFile TestModificaTabelPS.java ! / *· ±G ¸ W¸ L² %'¶ -/M+,¹ 5 N-7¹ = -?¹ = -¹ C W-E¹ I :§ :K¹ Q :S¹ W 6² %» YY[· ]¶ ac¶ a¶ f¶ j¶ -¹ n ÿ§ L+¶ s± pF " % & * - / ( 0 1 2 8 5 B 7 E 8 P 9 [ : | 7 = > @ R t u } v w r x y j z { B G | } P , ~ y [ !