mysqlchar.java

来自「主要对各种数据库性能进行测试」· Java 代码 · 共 60 行

package sqlite;

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.sql.*;  

public class MysqlChar { 
	String sGet,driver ; 
    void test(){   
        try {  
        	Connection conn = null; 
    	    Statement stmt = null; 
    	    ResultSet rs = null;  
    		driver = "jdbc:mysql://192.168.104.88/information_schema?useUnicode=true&characterEncoding="+sGet;
    	 	Class.forName("com.mysql.jdbc.Driver");  
    	    conn = DriverManager.getConnection(driver,"vcom","vcom"); 
    	    stmt = conn.createStatement();
    	   
    	    stmt.executeUpdate(" set names gbk ");
    	    
    	    String sql="select * from SESSION_VARIABLES where variable_name  like 'char%'";  
 	        rs = stmt.executeQuery(sql); 
 	        while (rs.next()){ 
 	        	System.out.println(rs.getString(1)+"----"+rs.getString(2));
 	        }  
 	        if (rs!=null){  
 	            rs.close(); 
 	            rs = null; 
 	        }   
 	        
 	        
    	    
        }catch(SQLException se){ 
        	System.out.println("error:"+se.getMessage());  
        }catch(Exception e){
        	
        }finally { 
        	 
        }
	}
	   
	public static void main(String[] args) { 
		 
		while(true){ 
			String sin = "";
			System.out.println("请录入jdbc连mysql的字符集，点回车键结束,录入exit或quit则退出程序");
			BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
			try{
				sin = br.readLine();
			}catch(Exception ex){
				System.out.println(ex.getMessage());
			}
			MysqlChar mc = new MysqlChar();
			if(sin.equalsIgnoreCase("exit")||sin.equalsIgnoreCase("quit")) return ;
			mc.sGet = sin; 
			mc.test();  
	    } 
	}
}