import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import oracle.jdbc.pool.OracleDataSource;

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/**
 *
 * @author Administrator
 */
public class JavaConverter {
    /**
     * @param args
     */
    
    //JavaConverter.convert(txt,"ISO-8859-1","TIS-620");
    
    public static String convertEN2TH(String txt){
       return JavaConverter.convert(txt,"ISO-8859-1","TIS-620");
    }
        
    public static String convert(String txt,String inputCharSet,String outputCharSet){
        try{
            return new String(txt.getBytes(inputCharSet),outputCharSet);
        }catch(Exception e)
        {
            return txt;
        }
    }
    
    public static void main(String[] args)
    {
    //  throws SQLException

        //initiazlie the connection

        Connection con=null;

        try //try connection to database
        {
            //load driver
            Class.forName("oracle.jdbc.OracleDriver");
            System.out.println("Oracle JDBC driver loaded ok.");
            
            OracleDataSource ods = new OracleDataSource();
            ods.setURL("jdbc:oracle:thin:@192.168.10.160:1521:orclcenter");
            ods.setUser("scomsv");
            ods.setPassword("scomsv");
                
            con=ods.getConnection();
            System.out.println("Connect with @oracle:1521:orclcenter");

            //declaring statement
            Statement stmt = con.createStatement();
            Statement stmt_ = con.createStatement();

            String updateSQL="UPDATE product set price=55 where price=20";
            //stmt.executeUpdate(updateSQL);

            //save the select statement in a string
            String selectSQL="SELECT sliptype_code,sliptype_desc FROM cmucfsliptype@scopsm";

            //create a result set
            ResultSet rows = stmt.executeQuery(selectSQL);

            //stmt.executeQuery(selectStat);


            int count=0;
            while (rows.next()) {
                count+=1;
                String sliptype_code = rows.getString("sliptype_code");
                String sliptype_desc = rows.getString("sliptype_desc");
                sliptype_desc =JavaConverter.convertEN2TH(sliptype_desc);
                System.out.print(",Row #:"+count);
                System.out.print(",Product#: "+sliptype_code);
                System.out.println(",Product Name: "+sliptype_desc);
              
                updateSQL="UPDATE cmucfsliptype set sliptype_desc='"+sliptype_desc+"' where sliptype_code='"+sliptype_code+"'";
                stmt_.executeUpdate(updateSQL);
            
                }

            con.close();

        }
                catch (Exception e)
                {
                    System.err.println("Exception:"+e.getMessage());
                }


        }
}