import java.sql.*;

   public class convert
   {
       public static void main (String[] args)
       {
           Connection conn = null;

           try
           {
               String userName = "root";
               String password = "123";
               String url = "jdbc:mysql://localhost/test";
               Class.forName ("com.mysql.jdbc.Driver").newInstance ();
               conn = DriverManager.getConnection (url, userName, password);
               System.out.println ("Database connection establiished");
               String query = "Select  * From ri";
               Statement stmt = conn.createStatement();
               ResultSet rs = stmt.executeQuery(query);
               while (rs.next()) {
            	  String di = rs.getString(1);
            	  int result = di.compareTo("78");
            	  //System.out.print(result);
            	  if(result==0){ di="tm";}
            	  if(result<0)
            	  {
            	  	di = "th";

            	  }
            	  else
            	  {
            	  	di ="tl";
            	  }
            	  //System.out.println(di);
            	  String query1 = "update ri set temp=" +"\"" + di+"\"";
            	// String query1 = "update ri set temp=" + di;
            	 Statement stmt1 = conn.createStatement();
            	  stmt1.executeQuery(query1);


               } //end while
           }
           catch (Exception e)
           {
               System.err.println ("Cannot connect to database server");
           }
           finally
           {
               if (conn != null)
               {
                   try
                   {
                       conn.close ();
                       System.out.println ("Database connection terminated");
                   }
                   catch (Exception e) { /* ignore close errors */ }
               }
           }
       }
   }