JDBC-setSavepoint,releaseSavepoint例子

复制纯文本新窗口

<ol style="margin: 0px; padding-left: 26px; list-style: none; border: 0px; background-image: url(http://c.biancheng.net/cpp/templets/default/images/code_bg.png); text-indent: -6px; padding-top: 3px !important; padding-right: 8px !important; padding-bottom: 3px !important;"><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;"><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">//STEP 1. Import required packages</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;"><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #5374b0;">import</span> java<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span>sql<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.*;</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;"></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;"><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">public</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">class</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px;">JDBCExample</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">{</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">   <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">// JDBC driver name and database URL</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">   <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">static</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">final</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px;">String</span> JDBC_DRIVER <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">=</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"com.mysql.jdbc.Driver"</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">;</span> </li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">   <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">static</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">final</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px;">String</span> DB_URL <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">=</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"jdbc:mysql://localhost/EMP"</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">;</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;"></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">   <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">//  Database credentials</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">   <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">static</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">final</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px;">String</span> USER <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">=</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"username"</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">;</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">   <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">static</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">final</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px;">String</span> PASS <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">=</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"password"</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">;</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">  </li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;"><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">public</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">static</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #f7b92c;">void</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">main</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span>String<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">[]</span> args<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">)</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">{</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">   <span style="margin: 0px; padding: 0px; list-style: none; border: 0px;">Connection</span> conn <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">=</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">null</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">;</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">   <span style="margin: 0px; padding: 0px; list-style: none; border: 0px;">Statement</span> stmt <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">=</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">null</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">;</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">   <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">try</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">{</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">//STEP 2: Register JDBC driver</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      Class<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">forName</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"com.mysql.jdbc.Driver"</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;"></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">//STEP 3: Open a connection</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      System<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span>out<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">println</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"Connecting to database..."</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      conn <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">=</span> DriverManager<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">getConnection</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span>DB_URL<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">,</span>USER<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">,</span>PASS<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;"></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">//STEP 4: Set auto commit as false.</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      conn<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">setAutoCommit</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">false</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;"></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">//STEP 5: Execute a query to delete statment with</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">// required arguments for RS example.</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      System<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span>out<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">println</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"Creating statement..."</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      stmt <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">=</span> conn<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">createStatement</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">();</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;"></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">   <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">//STEP 6: Now list all the available records.</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px;">String</span> sql <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">=</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"SELECT id, first, last, age FROM Employees"</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">;</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px;">ResultSet</span> rs <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">=</span> stmt<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">executeQuery</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span>sql<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      System<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span>out<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">println</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"List result set for reference...."</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">printRs</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span>rs<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;"></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">// STEP 7: delete rows having ID grater than 104</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">// But save point before doing so.</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px;">Savepoint</span> savepoint1 <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">=</span> conn<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">setSavepoint</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"ROWS_DELETED_1"</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      System<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span>out<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">println</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"Deleting row...."</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px;">String</span> SQL <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">=</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"DELETE FROM Employees "</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">+</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">                   <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"WHERE ID = 110"</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">;</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      stmt<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">executeUpdate</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span>SQL<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span> </li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">// oops... we deleted too wrong employees!</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">//STEP 8: Rollback the changes afetr save point 2.</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      conn<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">rollback</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span>savepoint1<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;"></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">    <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">// STEP 9: delete rows having ID grater than 104</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">// But save point before doing so.</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px;">Savepoint</span> savepoint2 <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">=</span> conn<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">setSavepoint</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"ROWS_DELETED_2"</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      System<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span>out<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">println</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"Deleting row...."</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      SQL <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">=</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"DELETE FROM Employees "</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">+</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">                   <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"WHERE ID = 95"</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">;</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      stmt<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">executeUpdate</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span>SQL<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span> </li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;"></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">   <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">//STEP 10: Now list all the available records.</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      sql <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">=</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"SELECT id, first, last, age FROM Employees"</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">;</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      rs <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">=</span> stmt<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">executeQuery</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span>sql<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      System<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span>out<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">println</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"List result set for reference...."</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">printRs</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span>rs<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;"></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">//STEP 10: Clean-up environment</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      rs<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">close</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">();</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      stmt<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">close</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">();</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      conn<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">close</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">();</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">   <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">}</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">catch</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px;">SQLException</span> se<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">)</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">{</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">//Handle errors for JDBC</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      se<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">printStackTrace</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">();</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">// If there is an error then rollback the changes.</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      System<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span>out<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">println</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"Rolling back data here...."</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">   <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">try</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">{</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">   <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">if</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span>conn<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">!=</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">null</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">)</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">            conn<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">rollback</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">();</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">}</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">catch</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px;">SQLException</span> se2<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">)</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">{</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">         se2<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">printStackTrace</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">();</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">}</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">//end try</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;"></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">   <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">}</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">catch</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px;">Exception</span> e<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">)</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">{</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">//Handle errors for Class.forName</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      e<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">printStackTrace</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">();</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">   <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">}</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">finally</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">{</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">//finally block used to close resources</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">try</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">{</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">         <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">if</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span>stmt<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">!=</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">null</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">)</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">            stmt<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">close</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">();</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">}</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">catch</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px;">SQLException</span> se2<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">)</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">{</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">}</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">// nothing we can do</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">try</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">{</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">         <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">if</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span>conn<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">!=</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">null</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">)</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">            conn<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">close</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">();</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">}</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">catch</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px;">SQLException</span> se<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">)</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">{</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">         se<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">printStackTrace</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">();</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">}</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">//end finally try</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">   <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">}</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">//end try</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">   System<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span>out<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">println</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"Goodbye!"</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;"><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">}</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">//end main</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;"></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">   <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">public</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">static</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #f7b92c;">void</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">printRs</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px;">ResultSet</span> rs<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">)</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">throws</span> SQLException<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">{</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">//Ensure we start with first row</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      rs<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">beforeFirst</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">();</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">      <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #ff3030; font-weight: bold;">while</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span>rs<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">next</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">())</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">{</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">         <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">//Retrieve by column name</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">         <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #f7b92c;">int</span> id  <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">=</span> rs<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">getInt</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"id"</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">         <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #f7b92c;">int</span> age <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">=</span> rs<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">getInt</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"age"</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">         <span style="margin: 0px; padding: 0px; list-style: none; border: 0px;">String</span> first <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">=</span> rs<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">getString</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"first"</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">         <span style="margin: 0px; padding: 0px; list-style: none; border: 0px;">String</span> last <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">=</span> rs<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">getString</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"last"</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;"></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">         <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">//Display values</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">         System<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span>out<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">print</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">"ID: "</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">+</span> id<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">         System<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span>out<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">print</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">", Age: "</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">+</span> age<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">         System<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span>out<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">print</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">", First: "</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">+</span> first<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">         System<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span>out<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">println</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">(</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #1861a7;">", Last: "</span> <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">+</span> last<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">);</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">     <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">}</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">     System<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span>out<span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">.</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #d11ced;">println</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">();</span></li><li style="color: #555555; font-family: Tahoma, Verdana, sans-serif; font-size: 14px; font-weight: normal; line-height: 22px; margin: 0px; padding: 0px 0px 0px 8px; list-style: decimal; border: 0px;">   <span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #3030ee;">}</span><span style="margin: 0px; padding: 0px; list-style: none; border: 0px; color: #38ad24;">//end printRs()</span></li><li style="color: #555555; f                    </div>
                  
 
                    <div class=" "="">
                        <ul class="m-news-opt fix">
                            <li class="opt-item">
                                <a href="/sql_question-459153.html" target="_blank"><p>< 上一篇</p><p class="ellipsis">mysql(innodb)故障</p></a>
                            </li>
                            <li class="opt-item ta-r">
                                 <a href="/sql_question-459155.html" target="_blank"><p>下一篇 ></p><p class="ellipsis">xampp默认mysql密码设置，修改mysql的默认空密码</p></a>
                            </li>
                        </ul>
                    </li></ol>