jdbc connect mysql

private void MySQLCon()

{

Connection con = null;

Statement stmt = null;

ResultSet rs = null;

String url,user,password;

try

{

Class.forName("com.mysql.jdbc.Driver");

}

catch(ClassNotFoundException e)

{

e.printStackTrace();

}

try

{

url = "jdbc:mysql://10.167.28.99:3306/pbsnmdb?user=root&password=1234";

user = "root";

password = "1234";

con = DriverManager.getConnection(url,user,password);

}

catch(SQLException e)

{

e.printStackTrace();

}

try

{

stmt = con.createStatement();

String sql = "select count(*) count from dbversion";

rs=stmt.executeQuery(sql);

while(rs.next())

{

System.out.println("dbversion data count = " + rs.getInt("count"));

}

}

catch(SQLException e)

{

e.printStackTrace();

}

try

{

if(rs!=null)

{

rs.close();

rs = null;

}

if(stmt!=null)

{

stmt.close();

stmt = null;

}

if(con != null)

{

con.close();

con = null;

}

}

catch(Exception e)

{

e.printStackTrace();

}

}