JDBC select update

++++++++++++++++++++++++++++ SELECT +++++++++++++++++++++++
package JDBC.example;
import java.sql.*;


public class JDBCExample {
    
    public static void main(String args[])
    {
        String drever = "orcle.jdbc.driver.OracleDriver";
        String url = "jdbc:oracle:thin:@192.168.1.101:1521:ora9";
        String username = "scott";
        String password = "tiger";
        
        String sql = "select * from users ";
        
    try {
        Class.forName(driver);
        //new oracle.jdbc.driver.OracleDriver(); 与 Class.forName("orcle.jdbc.driver.OracleDriver");作用一样
        connection conn = DriverManager.getConnection(url,username,password);
        
        //Statement stat = conn.createStatement();
        PreparedStatement pstmt = conn.prepareStatement(sql);
        
        ResultSet  rs = pstmt.executeQuery();
        While(rs.next()){
            System.out.prinln("name:" + rs.getString("username") +"/tpassport:" + rs.getString("passport"));
        }
        
        rs.close();
        pstmt.close();
        conn.close();
        
    } catch (ClassNotFoundException e){
      e.printStackTrace();
    } catch (SQLException e){
       e.printStackTrace();
    }
        
    
    }

    }
}

++++++++++++++++++++++++++  UPDATE  ++++++++++++++++++
package JDBC.example;
import java.sql.*;


public class JDBCExample {
   
    public static void main(String args[])
    {
        String drever = "orcle.jdbc.driver.OracleDriver";
        String url = "jdbc:oracle:thin:@192.168.1.101:1521:ora9";
        String username = "scott";
        String password = "tiger";
       
        String sql = "insert into users (username, password) value(?,?)";
         
    try {
        Class.forName(driver);
        //new oracle.jdbc.driver.OracleDriver(); 与 Class.forName("orcle.jdbc.driver.OracleDriver");作用一样
        connection conn = DriverManager.getConnection(url,username,password);
       
        //Statement stat = conn.createStatement();
        PreparedStatement pstmt = conn.prepareStatement(sql);
        pstmt.setString(1,"cat");
        pstmt.setString("dog");
        pstmt.executeUpdate();
       
        pstmt.close();
        conn.close();
       
    } catch (ClassNotFoundException e){
      e.printStackTrace();
    } catch (SQLException e){
       e.printStackTrace();
    }
       
   
    }

    }
}