Java

chdboy wrote:

I don't know if it is possible?

String filenostr = filenotxtfield.getText();
			statement.setString(1,filenostr);
			int fileno=Integer.parseInt(filenostr);

fileno++;
		    
		   String convertno=String.valueOf(fileno);
		    filenotxtfield.setText(convertno);
		statement.executeUpdate();
		
		int rowsAffected = statement.executeUpdate();
		if(rowsAffected > 0) 
		{
			   JOptionPane.showMessageDialog(null, "Data Inserted successfully!");
			}
			else
			{
			    JOptionPane.showMessageDialog(null, "Data is not Inserted!", "Not successfully", JOptionPane.ERROR_MESSAGE);
			}
		statement.close();
		con.close();

int rowsAffected = statement.executeUpdate();

com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__Employer__6F09E6800F975522'. Cannot insert duplicate key in object 'dbo.Employer'.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314)

int fileno1=Integer.parseInt(Result.getString(2));
		int increment = ++fileno1;
		String convertno1=String.valueOf(increment);
		filenotxtfield.setText(convertno1);

int increment = ++fileno1;

int fileno1=Integer.parseInt(Result.getString(2));
	    int increment = ++fileno1;
	    int increment2 = ++increment;
	    filenotxtfield.setText(Integer.toString(increment2));

int fileno1=Integer.parseInt(Result.getString(2));
fileno1 = fileno1 + 1;
int increment = fileno1;
increment = increment + 1;
int increment2 = increment;
filenotxtfield.setText(Integer.toString(increment2));

int fileno1=Integer.parseInt(Result.getString(2));
fileno1 = fileno1 + 2;
filenotxtfield.setText(Integer.toString(fileno1));

public class Test {
 
    /**
     * @param args
     */
    public static void main(String[] args) {
        Integer a;
        Integer b;
        a = 10;
        b = 10;
        if (a == b)
            System.out.println("True");
    }
}

Richard MacCutchan wrote:

The following test program shows what happens:

Raptor81 wrote:

In my experience, seems that Java does reference comparison with two Integers

Raptor81 wrote:

and seems that it does value comparison with one Integer and one constant.

Integer a1 = 1000;
Integer a2 = 1000;
Integer a3 = a1;
Integer b1 = 10;  // Less than 128 so Integer is cached.
Integer b2 = 10;

System.out.println("1000 is " + (a1 == a2));
System.out.println("10 is " + (b1 == b2));

System.out.println("1000 != is " + (a1 != a3));