private int cariNoPesananTerakhir(){
        int result = 0;
        try {
            Class.forName ("com.mysql.jdbc.Driver");
            String urldb="jdbc:mysql://localhost:3306/restaurant";
            String user=main.dbUser;
            String password=main.dbPassword;
            Connection koneksi=java.sql.DriverManager.getConnection(urldb,user,password);
            String strSQL = "SELECT MAX(no_pesanan) AS max "
                            + "FROM `pesanan` WHERE `lunas` = 0";

            Statement st = koneksi.createStatement();
            ResultSet rs = st.executeQuery(strSQL);
            
            while (rs.next()){
                result = rs.getInt("max");
            }
            
            rs.close();
            st.close();
            koneksi.close();
        }catch(ClassNotFoundException cnfe){
            System.out.println("kesalahan saat"+"me-load driver jdbc \n"+cnfe.getMessage());
        }catch(SQLException sqle){
            System.out.println("keslahan saat koneksi atau "+"kesalahan query sql \n"+sqle.getMessage());
        }
        return result;
    }