Hibernate Update Query

<div dir&equals;"ltr" style&equals;"text-align&colon; justify&semi;" trbidi&equals;"on">In this tutorial we will show how to update a row with new information by retrieving data from the underlying database using the hibernate&period; Lets first write a java class to update a row to the database&period;<br &sol;>&NewLine;<b>Create a java class&colon;<&sol;b><&sol;p>&NewLine;<p>here we update the value of the field name <b>userName <&sol;b>with corresponding column name is <b>USER&lowbar;NAME<&sol;b> in the database table <b>USRE&lowbar;TABLE<&sol;b>&period;<&sol;p>&NewLine;<div align&equals;'center' id&equals;"ads-id"><&sol;div>&NewLine;<div class&equals;"separator" style&equals;"clear&colon; both&semi; text-align&colon; center&semi;"><img border&equals;"0" src&equals;"https&colon;&sol;&sol;dineshonjava&period;com&sol;wp-content&sol;uploads&sol;2017&sol;04&sol;table3&period;jpg"&sol;><&sol;div>&NewLine;<p>In the above table we want to update the value of the<b> USER&lowbar;NAME<&sol;b> column of the<b> USER&lowbar;TABLE<&sol;b> table associated <b>user <&sol;b>model object which <b>userId &equals; 2<&sol;b><br &sol;>&NewLine;current value of the <b>userName <&sol;b>is<b> &&num;8216&semi;Anamika Rajput&&num;8217&semi;<&sol;b> update to <b>userName&equals;&&num;8217&semi;Sweety&&num;8217&semi;&period;<&sol;b><br &sol;>&NewLine;Look the following class file&period;<br &sol;>&NewLine;<b>HibernateTestDemo&period;java<&sol;b><&sol;p>&NewLine;<div style&equals;"background-color&colon; &num;ff99cc&semi; border-width&colon; thin&semi; border&colon; solid&semi;">package com&period;sdnext&period;hibernate&period;tutorial&semi;<&sol;p>&NewLine;<p>import org&period;hibernate&period;Session&semi;<br &sol;>&NewLine;import org&period;hibernate&period;SessionFactory&semi;<br &sol;>&NewLine;import org&period;hibernate&period;cfg&period;AnnotationConfiguration&semi;<&sol;p>&NewLine;<p>import com&period;sdnext&period;hibernate&period;tutorial&period;dto&period;UserDetails&semi;<&sol;p>&NewLine;<p>public class HibernateTestDemo &lbrace;<br &sol;>&NewLine;&nbsp&semi;&nbsp&semi;&nbsp&semi; &sol;&ast;&ast;<br &sol;>&NewLine;&nbsp&semi;&nbsp&semi;&nbsp&semi; &nbsp&semi;&ast; &commat;param args<br &sol;>&NewLine;&nbsp&semi;&nbsp&semi;&nbsp&semi; &nbsp&semi;&ast;&sol;<br &sol;>&NewLine;&nbsp&semi;&nbsp&semi;&nbsp&semi; public static void main&lpar;String&lbrack;&rsqb; args&rpar; <br &sol;>&NewLine;&nbsp&semi;&nbsp&semi;&nbsp&semi; &lbrace;<br &sol;>&NewLine;&nbsp&semi;&nbsp&semi;&nbsp&semi; &nbsp&semi;&nbsp&semi;&nbsp&semi; UserDetails user &equals; null&semi;<br &sol;>&NewLine;&nbsp&semi;&nbsp&semi;&nbsp&semi; <br &sol;>&NewLine;&nbsp&semi;SessionFactory sessionFactory &equals; new AnnotationConfiguration&lpar;&rpar;&period;configure&lpar;&rpar;&period;buildSessionFactory&lpar;&rpar;&semi;<br &sol;>&NewLine;&nbsp&semi;&nbsp&semi;&nbsp&semi; &nbsp&semi;&nbsp&semi;&nbsp&semi; Session session &equals; sessionFactory&period;openSession&lpar;&rpar;&semi;<br &sol;>&NewLine;&nbsp&semi;&nbsp&semi;&nbsp&semi; &nbsp&semi;&nbsp&semi;&nbsp&semi; session&period;beginTransaction&lpar;&rpar;&semi;<br &sol;>&NewLine;&nbsp&semi;&nbsp&semi;&nbsp&semi; &nbsp&semi;&nbsp&semi;&nbsp&semi; <br &sol;>&NewLine;&nbsp&semi;&nbsp&semi;&nbsp&semi; &nbsp&semi;&nbsp&semi;&nbsp&semi; user &equals; &lpar;UserDetails&rpar; session&period;get&lpar;UserDetails&period;class&comma; 2&rpar;&semi; &sol;&sol;Retrieving object which we want to update<br &sol;>&NewLine;&nbsp&semi;&nbsp&semi;&nbsp&semi; &nbsp&semi;&nbsp&semi;&nbsp&semi; user&period;setUserName&lpar;&&num;8220&semi;Sweety&&num;8221&semi;&rpar;&semi; &sol;&sol;Set the updated userName to the model field<br &sol;>&NewLine;&nbsp&semi;&nbsp&semi;&nbsp&semi; &nbsp&semi;&nbsp&semi;&nbsp&semi; session&period;update&lpar;user&rpar;&semi; &sol;&sol;Update to the database table<br &sol;>&NewLine;&nbsp&semi;&nbsp&semi;&nbsp&semi; &nbsp&semi;&nbsp&semi;&nbsp&semi; session&period;getTransaction&lpar;&rpar;&period;commit&lpar;&rpar;&semi;<&sol;p>&NewLine;<p>&nbsp&semi;&nbsp&semi;&nbsp&semi; &nbsp&semi;&nbsp&semi;&nbsp&semi; System&period;out&period;println&lpar;&&num;8220&semi;Updated User -&gt&semi;&&num;8221&semi;&plus;user&rpar;&semi;<br &sol;>&NewLine;&nbsp&semi;&nbsp&semi;&nbsp&semi; <br &sol;>&NewLine;&nbsp&semi; &nbsp&semi; &nbsp&semi; session&period;close&lpar;&rpar;&semi;<br &sol;>&NewLine;&nbsp&semi;&nbsp&semi;&nbsp&semi; &rcub;<br &sol;>&NewLine;&rcub;<&sol;p>&NewLine;<p>Output&colon;<br &sol;>&NewLine;log4j&colon;WARN No appenders could be found for logger &lpar;org&period;hibernate&period;cfg&period;annotations&period;Version&rpar;&period;<br &sol;>&NewLine;log4j&colon;WARN Please initialize the log4j system properly&period;<br &sol;>&NewLine;Hibernate&colon; select userdetail0&lowbar;&period;USER&lowbar;ID as USER1&lowbar;0&lowbar;0&lowbar;&comma; userdetail0&lowbar;&period;USER&lowbar;NAME as USER2&lowbar;0&lowbar;0&lowbar; from USER&lowbar;TABLE userdetail0&lowbar; where userdetail0&lowbar;&period;USER&lowbar;ID&equals;&quest;<br &sol;>&NewLine;Hibernate&colon; update USER&lowbar;TABLE set USER&lowbar;NAME&equals;&quest; where USER&lowbar;ID&equals;&quest;<br &sol;>&NewLine;<b>&lbrack;Updated User -&gt&semi; User Name&colon; Sweety User Id&colon; 2&rsqb;<&sol;b> <&sol;div>&NewLine;<div class&equals;"separator" style&equals;"clear&colon; both&semi; text-align&colon; center&semi;"><img border&equals;"0" height&equals;"76" src&equals;"https&colon;&sol;&sol;dineshonjava&period;com&sol;wp-content&sol;uploads&sol;2017&sol;04&sol;output3-1024x122&period;jpg" width&equals;"640" &sol;><&sol;div>&NewLine;<p>Now we get the following updated table&&num;8230&semi;<&sol;p>&NewLine;<div class&equals;"separator" style&equals;"clear&colon; both&semi; text-align&colon; center&semi;"><img border&equals;"0" src&equals;"https&colon;&sol;&sol;dineshonjava&period;com&sol;wp-content&sol;uploads&sol;2017&sol;04&sol;table4&period;jpg"&sol;><&sol;div>&NewLine;<blockquote class&equals;"tr&lowbar;bq">&NewLine;<blockquote class&equals;"tr&lowbar;bq"><p>We are looking the value of the <b>USER&lowbar;NAME<&sol;b> column updated from &&num;8216&semi;<b>Anamika Rajput<&sol;b>&&num;8216&semi; to &&num;8216&semi;<b>Sweety<&sol;b>&&num;8216&semi; in the <b>USER&lowbar;TABLE<&sol;b> table&period;<&sol;p><&sol;blockquote>&NewLine;<&sol;blockquote>&NewLine;<p>&NewLine;<b>Now in the <a href&equals;"https&colon;&sol;&sol;dineshonjava&period;com&sol;p&sol;hibernate-delete-query&period;html">Next Chapter <&sol;a>we will see how to <a href&equals;"https&colon;&sol;&sol;dineshonjava&period;com&sol;p&sol;hibernate-delete-query&period;html">delete a row in the hibernate<&sol;a>&period;<&sol;b><br &sol;>&NewLine;<b><br &sol;>&NewLine;<&sol;b> <b><br &sol;>&NewLine;<&sol;b> &nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi; &nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;&nbsp&semi;<b>&nbsp&semi;&nbsp&semi; &lt&semi;&lt&semi;<a href&equals;"https&colon;&sol;&sol;dineshonjava&period;com&sol;p&sol;retrieving-objects-using-sessionget&period;html">Previous Chapter 10<&sol;a>&lt&semi;&lt&semi; &nbsp&semi;&nbsp&semi; &gt&semi;&gt&semi;N<a href&equals;"https&colon;&sol;&sol;dineshonjava&period;com&sol;p&sol;hibernate-delete-query&period;html">ext Chapter12<&sol;a><&sol;b><&sol;p>&NewLine;<&sol;div>&NewLine;

View Comments