java连接数据库--JDBC

//驱动程序名
String driver =("com.mysql.jdbc.Driver");// "com.MySQL.jdbc.Driver";

//URL指向要访问的数据库名scutcs
String url = "jdbc:MySQL://127.0.0.1:3306/apk";

//MySQL配置时的用户名
String user = "root";

//MySQL配置时的密码
String password = "603809";


int version;
boolean bNew = false;
int max = 0;

try {
//加载驱动程序
Class.forName(driver);

//连续MySQL 数据库
Connection conn = DriverManager.getConnection(url, user, password);
if(!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");

//statement用来执行SQL语句
Statement statement = conn.createStatement();

//要执行的SQL语句
String sql = "select version from apk";

//结果集
ResultSet rs = statement.executeQuery(sql);

while(rs.next()) {

//选择version这列数据
version =Integer.parseInt( rs.getString("version"));

if( max < version){

max = version ;
}
}

//释放占用资源
rs.close();
conn.close();

if(max == 2)
bNew = true;

if(bNew)
System.out.println("最新 -->version " + max);
else
System.out.println("更新-->version " + max);

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

catch(SQLException e) {
e.printStackTrace();
}

catch(Exception e) {
e.printStackTrace();
}
}