java jdbc mysql 增删读改

                String driver="com.mysql.jdbc.Driver";
String url = "jdbc:mysql://192.168.1.113:3306/wankuoportal";
String userName = "root";
String password = "123456";
try {
Class.forName(driver);
try {
Connection conn = DriverManager.getConnection(url,userName,password);
if (!conn.isClosed()) {

System.out.println("已成功连接数据库");
//查找数据库中有哪些表
DatabaseMetaData meta = conn.getMetaData();
ResultSet rs = meta.getTables(null,null,null,new String[] {"TABLE"});
while(rs.next()) {
System.out.println(rs.getString(3));
}
rs.close();
//查看表中共有哪些字段
String sql = "select * from a_account";
PreparedStatement ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
ResultSetMetaData meta1 = rs.getMetaData();
int cl = meta1.getColumnCount();
System.out.println("表a_account 共有" + cl + "个字段");
for (int i = 1; i < cl + 1; i ++)
{
System.out.println("字段名： " + meta1.getColumnName(i) + "  " 
+ meta1.getColumnType(i) + "  " 
+ meta1.getColumnTypeName(i) 
+ "------");

}

    } else
{
System.out.println("数据库连接不成功");
}

  } catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}