/Java/How to validate information against the database in java

How to validate information against the database in java

public boolean regFamily(FamilyAccount myFam, Customer myCust) throws Exception {
    int fid = 0;
    try {

        String selectStatement2 = "SELECT * from familyok.user where nric = ?  and  familyid is NOT NULL ";
        PreparedStatement pStmt2 = con.prepareStatement(selectStatement2);
        pStmt2.setString(1, myCust.getNric());
        ResultSet rs2 = pStmt2.executeQuery();
        if (rs2.next()) {

            String insertStatement = "Insert into familyok.familyaccount (familyname, fnric1, fnric2, fnric3)";
            insertStatement = insertStatement + "values (?,?,?,?)";
            PreparedStatement prepStmt = con.prepareStatement(insertStatement);
            prepStmt.setString(1, myFam.getFamilyname());
            prepStmt.setString(2, myFam.getFnric1());
            prepStmt.setString(3, myFam.getFnric2());
            prepStmt.setString(4, myFam.getFnric3());
            int status = prepStmt.executeUpdate();
            if (status != 0) {

                String selectStatement = "SELECT fid FROM familyok.familyaccount WHERE fnric1=?";
                PreparedStatement pStmt = con.prepareStatement(selectStatement);
                pStmt.setString(1, myFam.getFnric1());
                ResultSet rs = pStmt.executeQuery();
                if (rs.next()) {
                    System.out.println(rs.getInt("fid") + "\t");
                    fid = rs.getInt("fid");

                    String updateStatement = "update familyok.user set familyid=?, familyname1=? where nric in (?,?,?)";
                    PreparedStatement preparedStmt = con.prepareStatement(updateStatement);
                    preparedStmt.setInt(1, fid);
                    preparedStmt.setString(2, myFam.getFamilyname());
                    preparedStmt.setString(3, myFam.getFnric1());
                    preparedStmt.setString(4, myFam.getFnric2());
                    preparedStmt.setString(5, myFam.getFnric3());

                    int status2 = preparedStmt.executeUpdate();
                    System.out.println("update=" + preparedStmt.toString());

                    if (status2 != 0) {
                        System.out.println("Family Account Created");
                        return true;
                    }
                }
            }

        }

        else

        {

            System.out.println("Can't Register");
            return false;

        }

    } catch (Exception ex) {
        throw new Exception("Error: " + ex.getMessage());
    }
    return false;

}

Source: stackoverflow.com

Similar codes

1 vote134 views1 answer
How to constraint layout parm programmatically in android
Java
0 vote121 views1 answer
Java secureRandom certain range
Java
1 vote119 views1 answer
Java add commas to numbers
Java
1 vote118 views1 answer
How to print multiple lines in java
Java
0 vote137 views1 answer
Hide tablayout tab android
Java
0 vote127 views1 answer
Short array in java
Java
2 votes124 views1 answer
Appcompatdelegate.setdefaultnightmode(appcompatdelegate.mode_night_yes) not working
Java
1 vote146 views1 answer
What is T in the date in java
Java
1 vote116 views1 answer
How to read file from assets folder in android
Java
0 vote120 views1 answer
Add mockito to java project
Java