Databases
StackOverflow2013
Postsdbo
POSerilization data in foramt its getting NullPointerException
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSerilization data in foramt its getting NullPointerException
    primarykey
    data
    text
    <p>I have written some code to display the data in some format in file </p> <pre><code>public List&lt;TimeSheetVO&gt; getEmployeedetails(Connection con2, java.sql.Date dbdate) { timesheetlist=new ArrayList&lt;TimeSheetVO&gt;(); try { String query = SQLutilConstants.GET_TIMESHEET; psmt=con2.prepareStatement(query); psmt.setDate(1,dbdate ); rs=psmt.executeQuery(); while(rs.next()) { TimeSheetVO timeSheetVO=new TimeSheetVO(); timeSheetVO.setEMP_ID(rs.getString("EMP_ID")); //timeSheetVO.setATTENDANCE_DATE(rs.getString("ATTENDANCE_DATE").replaceAll("[-+.^:,]", "")); String attendance= rs.getString("ATTENDANCE_DATE"); String[] splitattendance=attendance.split("-"); timeSheetVO.setATTENDANCE_DATE(splitattendance[2]+splitattendance[1]+splitattendance[0]); String intimetime= rs.getString("IN_TIME"); String[] splitintime=intimetime.split(":"); timeSheetVO.setIN_TIME(splitintime[0]+splitintime[1]); String outtime=rs.getString("OUT_TIME"); String[] splitouttime=outtime.split(":"); timeSheetVO.setOUT_TIME(splitouttime[0]+splitouttime[1]); System.out.println("timesheetVo"+timeSheetVO.getATTENDANCE_DATE()); timesheetlist.add(timeSheetVO); } } catch(Exception e) { e.printStackTrace(); } return timesheetlist; } </code></pre> <p>Here am using one more <strong>method</strong> and passing <strong>timesheetlist</strong> as <strong>timesheetlist2</strong>: But here displaying only one row remaining rows are not displayed for that corresponding <strong>Attendancedate</strong> getting <strong>NullPointerException</strong></p> <pre><code>public String getTimesheet(List&lt;TimeSheetVO&gt; timesheetlist2, java.sql.Date dbdate) { try { String fieloc=MessageConstants.timesheetpath; File file=new File(fieloc+dbdate+".txt"); FileWriter fw = new FileWriter(file.getAbsoluteFile()); BufferedWriter bw = new BufferedWriter(fw); for(TimeSheetVO time: timesheetlist2) { bw.write(time+" "); bw.newLine(); bw.flush(); path=file.getAbsolutePath(); } bw.close(); } catch(Exception e) { e.printStackTrace(); } return path; } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMitesh Pathak
    1. USuser2996174
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSerilization data in foramt its getting NullPointerException
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POSerilization data in foramt its getting NullPointerException
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    3. VO
      singulars
      1. POSerilization data in foramt its getting NullPointerException
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COFirst format your question for better responses
      singulars
      1. POSerilization data in foramt its getting NullPointerException
      1. USDeepak
    2. COCan you also provide the stacktrace here?
      singulars
      1. POSerilization data in foramt its getting NullPointerException
      1. USSudhanshu Umalkar
    3. COWhat's the format of the attendance date, are you sure its using '-' as a separator? Please print the values that you are getting from the database.
      singulars
      1. POSerilization data in foramt its getting NullPointerException
      1. USSudhanshu Umalkar
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload