个人备忘----------------------------------------------
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();
}
}
}