Java

Re: How to find sum of values in JTable column in Java NetBeans

23-Nov-13 2:16

Cyber12 wrote:
but not working properly!

Well I have Googled that, but didn't find anything; maybe you could try explaining what it means.

Java

sum+= Integer.parseInt(jTable1.getValueAt(i, 5).toString());

Why are you converting a value to a string just so you can parse it back to a value?

Veni, vidi, abiit domum

Cyber129-Dec-13 21:27

Re: How to find sum of values in JTable column in Java NetBeans

9-Dec-13 21:27

Because the syntax didn't allow me to write without converting to string! Can fix it removing the .toString(); if it is possible!!!
Or I need an other alternative code if possible? Thanks!

Richard MacCutchan9-Dec-13 22:22

Re: How to find sum of values in JTable column in Java NetBeans

9-Dec-13 22:22

Well you neeed to figure it out based on what object type is held in that cell.

Veni, vidi, abiit domum

Cyber1212-Dec-13 2:24

Re: How to find sum of values in JTable column in Java NetBeans

12-Dec-13 2:24

The type of object held in that cell(column) is integer or double.
Thanks!!!

Richard MacCutchan12-Dec-13 2:43

Re: How to find sum of values in JTable column in Java NetBeans

12-Dec-13 2:43

So all you need to do is add them all together, right? You really need to think a bit more about exactly what you are trying to do here, and explain it in proper detail. Telling us that a column can hold an integer or real number is not particualrly useful, as it tells us nothing about what your actual problem is.

Veni, vidi, abiit domum

Cyber1213-Dec-13 0:48

Re: How to find sum of values in JTable column in Java NetBeans

13-Dec-13 0:48

I have Tested the code to add up all double values in one column! And The Error is: java.lang.NullPointerException, Pointing to the the line of code: sum+=Double.parseDouble(tblviewTaxDetails.getValueAt(i,5).toString());
Please help modifying it!!! Thanks!!

Richard MacCutchan13-Dec-13 1:46

Re: How to find sum of values in JTable column in Java NetBeans

13-Dec-13 1:46

Cyber12 wrote:
The Error is: java.lang.NullPointerException

Which means that you are tring to refer to an item by an invalid reference. You should try to break the offending statement into its constituent parts and then use your debugger to find out why you have a NULL pointer in there. In the above case something like:

Java

Double dblValue = tblviewTaxDetails.getValueAt(i,5); // if error here then what is value of i?
sum += dblValue;

Understanding what NullPointerExceptions are, what can cause them and how to avoid them, will make your life considerably easier.

Veni, vidi, abiit domum

Cyber1213-Dec-13 2:56

13-Dec-13 2:56

Thanks!!! Problem Solved!!! It was because of the number of rows in the JTable!!!! It must be equal to the number of values to be summed up!!! My JTable initially had 100 rows, I tried it adjusting the number of rows equal to the number of records displayed in the JTable! It's now working properly! Thanks!

java character array

Member 996561421-Nov-13 9:04

Member 9965614

21-Nov-13 9:04

What will be the default value of indexes when i create

Java

char[] ch = new char[50];

Richard MacCutchan21-Nov-13 22:06

21-Nov-13 22:06

What indexes are you talking about?

Veni, vidi, abiit domum

Member 996561422-Nov-13 7:41

Member 9965614

22-Nov-13 7:41

such as index ch[5] ... i just want to know is null="" ???

Richard MacCutchan22-Nov-13 20:55

22-Nov-13 20:55

What happens when you try it, or use your debugger to check?

Veni, vidi, abiit domum

how to write Juint testcases for spring application using annotations

Thomas ktg21-Nov-13 23:10

Thomas ktg

21-Nov-13 23:10

Read here this would give you more about the Array and it types.
http://docs.oracle.com/javase/tutorial/java/nutsandbolts/arrays.html[^]

srikotesh20-Nov-13 22:14

srikotesh

20-Nov-13 22:14

i have to write junit testcases using annotation for spring application can anyone suggest link or tutorial to me.

Re: how to write Juint testcases for spring application using annotations

Richard MacCutchan20-Nov-13 22:41

https://www.google.com/search?q=junit+testcases[^].

20-Nov-13 22:41

Veni, vidi, abiit domum

Re: how to write Juint testcases for spring application using annotations

srikotesh21-Nov-13 22:52

srikotesh

21-Nov-13 22:52

that search even me also did.but i didnt get propely how to do with annotations

Re: how to write Juint testcases for spring application using annotations

Richard MacCutchan21-Nov-13 22:55

How to make Integer number increment by 1 in a JTextField?

21-Nov-13 22:55

Did you bother to try https://www.google.com/search?q=junit+testcases#q=junit+test+cases+using+annotations[^]?

Veni, vidi, abiit domum

chdboy20-Nov-13 18:40

Re: How to make Integer number increment by 1 in a JTextField?

20-Nov-13 18:40

I have a form in which I have made File no field which hold the Integer value like 1-2-3-4 and so on.

I want that ,when I save a form which has file no 1 ,and then after when I want to save the next record it should remember the last file no and increment by 1.
I have not coded yet anything because I don't know if it is possible?

Richard MacCutchan20-Nov-13 22:38

Re: How to make Integer number increment by 1 in a JTextField?

20-Nov-13 22:38

chdboy wrote:
I don't know if it is possible?

It definitely is possible. You just need to use a variable to hold the value, and use that to display in the field. Every time you save a file, increment the value and refresh the displayed field.

Veni, vidi, abiit domum

chdboy21-Nov-13 4:14

Re: How to make Integer number increment by 1 in a JTextField?

21-Nov-13 4:14

thanks for the Idea I'm working on it.

EDIT:
I managed to do what I wanted BUT...
It only happens till the application is open and I'm saving data one after one...as soon as I close to application and opens in again I have see the last file no and enter the next file no manually.
with this code

Java

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();

Addition to that I'm getting error on line

Java

int rowsAffected = statement.executeUpdate();

ERROR:

Java

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)

But as I see in my Management Studio that the data has been saved.but still getting this error ..why?

modified 22-Nov-13 1:08am.

chdboy23-Nov-13 12:21

Re: How to make Integer number increment by 1 in a JTextField?

23-Nov-13 12:21

I'm able to display the value after data is saved, but it is showing me wrong value with this code.

Java

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

If 1 and 2 file no already exists after entering 3rd number manually and then save it ,it is showing me 2 not 4.?

Richard MacCutchan23-Nov-13 21:34

Re: How to make Integer number increment by 1 in a JTextField?

23-Nov-13 21:34

That code looks fine as it stands, but you are not saving the updated count anywhere.

Veni, vidi, abiit domum

chdboy25-Nov-13 17:21

Re: How to make Integer number increment by 1 in a JTextField?

25-Nov-13 17:21

Do I have to save it in the database and then retrieve it?

Java

int increment = ++fileno1;

I have to save increment in the database?

Richard MacCutchan25-Nov-13 22:38