Javaoop

1.JDBC工作模板

try {

      Class.forName(JDBC驱动类);

}

… …

try {

      Connection con=DriverManager.getConnection(URL,数据库用户名,密码);

     

      Statement stmt = con.createStatement();

      ResultSetrs =stmt.executeQuery("SELECTa, b, c FROM Table1");

 

      while (rs.next()){

             int x =rs.getInt("a");

             String s = rs.getString("b");

             float f = rs.getFloat("c");

      }

      rs.close();

      stmt.close();  

      con.close();

}

… …

2.