JAVA JDBC示例

try {
     // 加载MySql的驱动类
     Class.forName("com.mysql.jdbc.Driver");
    } catch (ClassNotFoundException e) {
     System.out.println("找不到驱动程序类 ，加载驱动失败！");
     e.printStackTrace();
     return;
    }

    // 连接MySql数据库，用户名和密码都是root
    String url = "jdbc:mysql://192.168.0.216:3306/rzzxmaindb?useUnicode=true&characterEncoding=utf8";
    String username = "root";
    String password = "root";

    Connection conn = null;
    Statement stmt = null;
    ResultSet rs = null;

    List<InsideuserInfo> list = new ArrayList();
    try {
     conn = DriverManager.getConnection(url, username, password);
     stmt = conn.createStatement();
     rs = stmt.executeQuery("SELECT * FROM t_insideuser");

     while (rs.next()) {
      InsideuserInfo info = new InsideuserInfo();
      info.setUsername(rs.getString("username"));
      info.setUsertel(rs.getString("usertel"));

      list.add(info);
     }

    } catch (SQLException se) {
     System.out.println("数据库连接失败！");
     se.printStackTrace();
    }
    if (rs != null) { // 关闭记录集
     try {
      rs.close();
     } catch (SQLException e) {
      e.printStackTrace();
     }
    }
    if (stmt != null) { // 关闭声明
     try {
      stmt.close();
     } catch (SQLException e) {
      e.printStackTrace();
     }
    }
    if (conn != null) { // 关闭连接对象
     try {
      conn.close();
     } catch (SQLException e) {
      e.printStackTrace();
     }
    }

    // ///
    url = "jdbc:mysql://192.168.0.216:3306/accesscontroldb?useUnicode=true&characterEncoding=utf8";
    username = "root";
    password = "root";

    conn = null;
    stmt = null;
    rs = null;

    try {
     conn = DriverManager.getConnection(url, username, password);
     stmt = conn.createStatement();
     int n = 0;
     for (int i = 0; i < list.size(); i++) {
      InsideuserInfo info = list.get(i);
      System.out.println(info.getUsername());
      String fid = "0835DB4591DE41A4AB1EFC454F42C" + i;

      int rows = stmt
        .executeUpdate("INSERT INTO accesscontroldb.sys_user (fID, VERSION, fUserCode, fUserName, fGender, fIDCard, fTelephone, fDeptId, fState) VALUES ('"
          + fid
          + "', 0, '"
          + info.getUsertel()
          + "', '"
          + info.getUsername()
          + "', 'M', '"
          + info.getUsertel()
          + "', '"
          + info.getUsertel()
          + "', '92E41919D4134FC78A411F00C2EB1E9E', 1);");
      if (rows > 0) {
       n++;
      }
     }

     System.out.println("插入数据：" + n);

    } catch (SQLException se) {
     System.out.println("数据库连接失败！");
     se.printStackTrace();
    }
    if (rs != null) { // 关闭记录集
     try {
      rs.close();
     } catch (SQLException e) {
      e.printStackTrace();
     }
    }
    if (stmt != null) { // 关闭声明
     try {
      stmt.close();
     } catch (SQLException e) {
      e.printStackTrace();
     }
    }
    if (conn != null) { // 关闭连接对象
     try {
      conn.close();
     } catch (SQLException e) {
      e.printStackTrace();
     }
    }