Thread: problem - insert negative value to mysql database.

Hi Friends,
In my project, i want to update excel values to the database....but my database did not get negative values...please any one help me...how to insert negative values to database.............

>>>>Thanks and Regards

Vasanth Jayaraman

Thanks for your Response....

this is my excel sheet img


my code

 for(int i=1; i<=sheet.getLastRowNum(); i++){  
	                row = sheet.getRow(i);  
				//	int id=0;
	                int time = (int) row.getCell(0).getNumericCellValue();  
					int xaxis = (int) row.getCell(1).getNumericCellValue(); 
					int yaxis = (int) row.getCell(2).getNumericCellValue(); 
					int zaxis = (int) row.getCell(3).getNumericCellValue(); 
	             //   String name = row.getCell(1).getStringCellValue();  
	             //   String salary = row.getCell(2).getStringCellValue();  
	             //   String sql = "INSERT INTO datas VALUES('"+id+"','"+name+"','"+salary+"')";  
				 String sql = "INSERT INTO datas VALUES('"+time+"','"+xaxis+"','"+yaxis+"','"+zaxis+"')";  
	                pstm = (PreparedStatement) con.prepareStatement(sql);  
	                pstm.execute();

and my output like