package test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;

public class TestDB {
    
    private static Connection connection;
    static{
        try{
            Class.forName("com.mysql.jdbc.Driver") ; 
            //?useUnicode=true&characterEncoding=utf8
            connection = DriverManager.getConnection("jdbc:mysql://xxxx.db.com:3306/database", "xxxxx", "xxxxxx6");    
        }catch(Exception ex){
            ex.printStackTrace();
        }
        
    }

    public static void main(String[] args)throws Exception {
        
        // connection.createStatement().execute("set names latin1");

        /*connection.createStatement().execute("SET character_set_results=latin1;");
         connection.createStatement().execute("set character_set_connection=latin1;");
         connection.createStatement().execute("set character_set_client=latin1;");
         */
        
         Statement stm = connection.createStatement();
         
         ResultSet rs1 = stm.executeQuery("show VARIABLES like '%char%'");
         while(rs1.next()){
             System.out.println(rs1.getString("Variable_name")+"\t"+rs1.getString("Value"));
         }
         
        
         //PreparedStatement pstmt = connection.prepareStatement("select nick from t_login where uid = 9714") ;  
         
         //select owner as info from t_info_5 where uid = 5859
         PreparedStatement pstmt = connection.prepareStatement("select owner as nick from xxxx_table where uid = 225 ") ;  
         ResultSet rs = pstmt.executeQuery();
         while(rs.next()){
             
             String val = rs.getString("nick");
             System.out.println(val);
             System.out.println("========================");
             String val1 = new String(val.getBytes("latin1"),"utf8");
             System.out.println(val1);
             String val2  = new String(val.getBytes("latin1"),"gbk");
             System.out.println(val2);
             String val3  = new String(val.getBytes("utf8"),"gbk");
             System.out.println(val3);
             String val4  = new String(val.getBytes("utf8"),"latin1");
             System.out.println(val4);
             String val5  = new String(val.getBytes("gbk"),"latin1");
             System.out.println(val5);
             String val6  = new String(val.getBytes("gbk"),"utf8");
             System.out.println(val6);

         }
         connection.close();
        

    }

}