Three types of JDBC Statement 

1. Statement 

Code: Statement st  = conn.createStatement();

2. PreparedStatement 

Code : PreparedStatement pst = con.prepareStatement("SELECT * FROM my_table WHERE id = ?");

pst.setInt(1, 345);

3. CallableStatement

Code: CallableStatement cst = conn.prepareCall(" {call update_customer(?, ?) } ");

cst.setString(1, "hohn");

cst.setString(2, "Doe");



Scrollable ResultSet 

Statement st = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

ResultSet rs = st.executeQuery("Select * From my_table);

;

Comments

Post a Comment

Popular posts from this blog

Python else if condition  n = int ( input () . strip ()) check = { True : "Not Weird" , False : "Weird" } print ( check [ n % 2 == 0 and ( n in range ( 2 , 6 ) or n > 20 ) ])
Read more

About RAM

Image
 RAM. About RAM  RAM stand's for Random Access Memory. RAM is type of Memory device which holds programs or instructions which is going to be executed. So we  say that RAM is a primary memory which stores currently running programs . Some features of RAM are as Follows:: --RAM is a volatile memory  --It is expensive memory device.  --We read and write data instructions in RAM. --High speed memory Types of RAM are ::: 1. Static RAM (SRAM)  2. Dynamic RAM (DRAM) Pic of RAM given below.... Pic: RAM  from:google.com
Read more

Class and object in c++

 Program in Class and Object: #include   < cmath > #include   < cstdio > #include   < vector > #include   < iostream > #include   < algorithm > #include   < cassert > using   namespace   std ; // Write your Student class here class   Student   {      private :      int   score [ 5 ];           public :      void   input ()      {        for ( int   i = 0 ; i < 5 ;++ i )        {            cin >> score [ i ];        }         }      int   calculateTotalScore ()      {          int ...
Read more