Java jdbc链接MySQL

个人备忘----------------------------------------------

 

import java.sql.*; 

public class Server { 
 
    public static void main(String[] args){ 
     connMysql();
    }
 
 
    public static void connMysql(){ 

           String driver = "com.mysql.jdbc.Driver"; 
           String url = "jdbc:mysql://x.x.x.x:3306/x";
 
           String user = "xxx"; 
           String password = "xxx"; 

           try { 

             Class.forName(driver); 
             Connection conn = DriverManager.getConnection(url, user, password); 
 
             if(!conn.isClosed()){ 
                 System.out.println("Succeeded connecting to the Database!"); 
             }
 
             Statement statement = conn.createStatement();
             String sql = "select platform_id,level from user_1";
             ResultSet rs = statement.executeQuery(sql);
  
             System.out.println("-----------------");
             System.out.println("pid" + "\t" + " level");
             System.out.println("-----------------");
  
//              String name = null;
  
             while(rs.next()) {   
//                  name = rs.getString("nick_name");
//                 //获取中文转换
//                  name = new String(name.getBytes("ISO-8859-1"),"GB2312"); 
        
               String pid = rs.getString("platform_id");
               try{
                 if(pid != "None" && !pid.contains("robot")){
                       System.out.println(pid + "\t" + rs.getString("level"));  
                    }    
                }catch(Exception e){
                   System.out.println("error!");
                }             
              }
  
             rs.close();
             conn.close(); 

           } catch(ClassNotFoundException e) { 
             System.out.println("Sorry,can`t find the Driver!"); 
             e.printStackTrace(); 
           } catch(SQLException e) { 
              e.printStackTrace(); 
           } catch(Exception e) { 
              e.printStackTrace(); 
           } 
    } 
}