有 Java 编程相关的问题?

你可以在下面搜索框中键入要查询的问题!

java如何从数据库中获取序列的下一个值,并使用oracle 10g在netbeans的JOptionPane中显示它?

private void button_saveandsubmitnowActionPerformed(java.awt.event.ActionEvent evt) {                                                        

           con = JavaConnectDB.ConnectDB();
    try{
       String sql="select MISSINGPERSON_SEQUENCE.nextval from DUAL";

       pst = (OraclePreparedStatement) con.prepareStatement(sql);     
       rs = (OracleResultSet) pst.executeQuery();

     JOptionPane.showMessageDialog(null, "\nCase number: "+rs.getString(1));

      rs = (OracleResultSet) pst.executeQuery();


        if(rs.next()){
           JOptionPane.showMessageDialog(null, "the details have been added successfully!!!");
           con.close();
           this.dispose();
        }
        else{
            JOptionPane.showMessageDialog(null, "enter all fields appropriately first!!!");
        }
        con.close();
    }catch(Exception e){
        JOptionPane.showMessageDialog(null, "An error occured. try again later !!!");
    }
}

image


共 (0) 个答案