コード例 #1
0
ファイル: UserDao.java プロジェクト: jiadw007/database
  public boolean updateUser(User user) {
    // TODO Auto-generated method stub
    String sql =
        "update Customer set password='******',passwordsalt='"
            + user.getPasswordSalt()
            + "',email='"
            + user.getEmail()
            + "' where username='******'";
    String url = "jdbc:oracle:thin:@oracle.cise.ufl.edu:1521:orcl";
    System.out.println(sql);
    try {
      Class.forName("oracle.jdbc.driver.OracleDriver");
    } catch (java.lang.ClassNotFoundException e) {
      System.out.println(e.getMessage());
    }
    try {
      Connection con = DriverManager.getConnection(url, "dawei", "jolly900513");
      Statement stmt = con.createStatement();
      stmt.executeUpdate(sql);
      stmt.close();
      con.close();
      return true;
    } catch (SQLException ex) {
      System.out.println(ex.getMessage());
    }

    return false;
  }
コード例 #2
0
ファイル: UserDao.java プロジェクト: jiadw007/database
 public boolean insertUser(User user) {
   // TODO Auto-generated method stub
   String url = "jdbc:oracle:thin:@oracle.cise.ufl.edu:1521:orcl";
   String sql1 = "select max(ID) from Customer";
   String sql2 = "insert into Customer values(?,?,?,?,?,?,?,?)";
   String sql3 = "insert into CustomerAddr values(?,?)";
   String sql4 = "select max(ID) from Address";
   System.out.println(sql2);
   try {
     Class.forName("oracle.jdbc.driver.OracleDriver");
   } catch (java.lang.ClassNotFoundException e) {
     System.out.println(e.getMessage());
   }
   try {
     Connection con = DriverManager.getConnection(url, "dawei", "jolly900513");
     Statement stmt = con.createStatement();
     ResultSet rs = stmt.executeQuery(sql1);
     int ID = 0;
     int ID2 = 0;
     while (rs.next()) {
       ID = rs.getInt(1) + 1;
       System.out.println(ID);
     }
     ResultSet rs2 = stmt.executeQuery(sql4);
     while (rs2.next()) {
       ID2 = rs2.getInt(1);
       System.out.println(ID2);
     }
     PreparedStatement ps = con.prepareStatement(sql2);
     ps.setInt(1, ID);
     ps.setTimestamp(2, user.getCreateTime());
     ps.setString(3, user.getPasswordSalt());
     ps.setString(4, user.getPassword());
     ps.setString(5, user.getEmail());
     ps.setString(6, user.getUsername());
     ps.setInt(7, ID2);
     ps.setInt(8, ID2);
     ps.executeUpdate();
     ps = con.prepareStatement(sql3);
     System.out.println(sql3);
     ps.setInt(1, ID);
     ps.setInt(2, ID2);
     ps.executeUpdate();
     stmt.close();
     con.close();
     return true;
   } catch (SQLException ex) {
     System.out.println(ex.getMessage());
   }
   return false;
 }