abheeshek reddy

spring Date update and auto populate

hi all,

i am trying to insert date in Oracle DB using Spring MVC.

JSP Code

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@taglib uri="http://www.springframework.org/tags/form" prefix="form"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<script type="text/javascript" src="js/datetimepicker.js"></script>
<title>Shift Tracker</title>
</head>
<body>
<tr>
<%@ include file="./top.jsp"%>
</tr>
<h2>Add Shift Data</h2>
<form:form method="POST" action="/employee/shiftSave.html">
<table>
<tr>
<td><form:label path="shiftId">S.No:</form:label></td>
<td><form:input path="shiftId" value="${shiftInfo.shiftId}"
readonly="true" /></td>
</tr>
<tr>
<td><form:select path="shiftType">
<form:option value="S3" label="S3" />
<form:option value="Official Holiday" label="Official Holiday" />
<form:option value="CompOff" label="CompOff" />
<form:option value="Regular" label="Regular" />
<form:option value="Weekly Off" label="Weekly Off" />
<form:option value="S2" label="S2" />
<form:option value="S1" label="S1" />
<form:option value="PTO" label="PTO" />
</form:select></td>
</tr>
<tr>
<td><form:select path="day">
<form:option value="Tuesday" label="Tuesday" />
<form:option value="Sunday" label="Sunday" />
<form:option value="Monday" label="Monday" />
<form:option value="Wednesday" label="Wednesday" />
<form:option value="Thursday" label="Thursday" />
<form:option value="Saturday" label="Saturday" />
<form:option value="Friday" label="Friday" />
<form:option value="select" label="select" />
</form:select></td>
</tr>
<td><form:label path="shiftDate">Created Date</form:label></td>
<td><form:input path="shiftDate" id="demo2" type="text"
size="20" /><a
><img
  border="0"
></a></td>
<tr>
<td ><input type="submit" value="Submit" /></td>
</tr>
</table>
</form:form>

Shift Bean

Controller

@RequestMapping(value = "/shiftSave", method = RequestMethod.POST)
public ModelAndView saveShiftInfo(@ModelAttribute("command") ShiftDetailBean shiftinfoBean,
BindingResult result) {
ShiftDetails shiftInfo = prepareShiftModel(shiftinfoBean);
shiftInfoService.addShiftInfo(shiftInfo);
System.out.println("==Shift Shift Info ==");
return new ModelAndView("redirect:/addShift.html");
}
private ShiftDetails prepareShiftModel(ShiftDetailBean shiftinfoBean){
ShiftDetails shiftInfo = new ShiftDetails();
System.out.println("==value of shift id 123 =="+shiftinfoBean.getShiftId());
shiftInfo.setShiftId(shiftinfoBean.getShiftId());
System.out.println("==value of getEmpName  123=="+shiftinfoBean.getEmpName());
shiftInfo.setEmpName(shiftinfoBean.getEmpName());
System.out.println("==value of getDay 123 =="+shiftinfoBean.getDay());
shiftInfo.setDay(shiftinfoBean.getDay());
System.out.println("==value of getShiftType 123 =="+shiftinfoBean.getShiftType());
Date date = new Date();
shiftInfo.setShiftType(shiftinfoBean.getShiftType());
System.out.println("==value of getShiftDate 123 =="+shiftinfoBean.getShiftDate());
shiftInfo.setShiftDate(date);
shiftInfo.setLastUpdateDate(date);
shiftinfoBean.setShiftId(null);
return shiftInfo;
}

In Console it is printing null ? how fix and how can i auto populate the date in UI.

5 years ago

Spring MVC for employee shift

hi all,

I have two requirements

1. parsing Excel file and insert excel data in to DB (oracle).
2. Transverse DB table structure to UI.

I am doing a small Project to maintain employee shift tracker, which we are maintaining in excel. below is the sample excel data, T1 represents time (6:00 am-4:00 pm) T2(12:00 pm-9:00pm) T3(9:00 pm-6:00 am)

Date	emp1	emp2	emp3	emp4	emp5	emp6
01/July/2016	T2	T1	T3	T1	T3	T2
02/July/2016	T1	T2	T3	T2	T1	T3
03/July/2016	T3	T1	T2	T3	T2	T1
04/July/2016	T1	T3	T1	T1	T3	T2

Below is table script designed by DBA -- Is table design correct to get above view?

Any link or suggestion to upload excel data in to above table using spring MVC

I googled for Spring MVC and found one sample to edit employee details, however not able to design Shift Jsp. Below is the code i am planning to use.

Below is Bean

below is DTO class

package com.employee.model;
   import java.io.Serializable;
   import javax.persistence.Column;
   import javax.persistence.Entity;
   import javax.persistence.GeneratedValue;
   import javax.persistence.GenerationType;
   import javax.persistence.Id;
   import javax.persistence.Table;
   @Entity
   @Table(name="Employee")
   public class Employee implements Serializable{
    private static final long serialVersionUID = -723583058586873479L;
   
    @Id
    @GeneratedValue(strategy=GenerationType.AUTO)
    @Column(name = "empid")
    private Integer empId;
   
    @Column(name="empname")
    private String empName;
   
    @Column(name="empaddress")
    private String empAddress;
   
    @Column(name="salary")
    private Long salary;
   
    @Column(name="empAge")
    private Integer empAge;
    public Integer getEmpId() {
     return empId;
    }
    public void setEmpId(Integer empId) {
     this.empId = empId;
    }
    public String getEmpName() {
     return empName;
    }
    public void setEmpName(String empName) {
     this.empName = empName;
    }
    public String getEmpAddress() {
     return empAddress;
    }
    public void setEmpAddress(String empAddress) {
     this.empAddress = empAddress;
    }
    public Long getSalary() {
     return salary;
    }
    public void setSalary(Long salary) {
     this.salary = salary;
    }
    public Integer getEmpAge() {
     return empAge;
    }
    public void setEmpAge(Integer empAge) {
     this.empAge = empAge;
    }
   }

Below is add employee Jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
   pageEncoding="ISO-8859-1"%>
<%@taglib uri="http://www.springframework.org/tags/form" prefix="form"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
 <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
 <title>Spring MVC Form Handling</title>
</head>
<body>
 <h2>Add Employee Data</h2>
 <form:form method="POST" action="/sdnext/save.html">
     <table>
      <tr>
          <td><form:label path="id">Employee ID:</form:label></td>
          <td><form:input path="id" value="${employee.id}" readonly="true"/></td>
      </tr>
      <tr>
          <td><form:label path="name">Employee Name:</form:label></td>
          <td><form:input path="name" value="${employee.name}"/></td>
      </tr>
      <tr>
          <td><form:label path="age">Employee Age:</form:label></td>
          <td><form:input path="age" value="${employee.age}"/></td>
      </tr>
      <tr>
          <td><form:label path="salary">Employee Salary:</form:label></td>
          <td><form:input path="salary" value="${employee.salary}"/></td>
      </tr>
     
      <tr>
          <td><form:label path="address">Employee Address:</form:label></td>
                   <td><form:input path="address" value="${employee.address}"/></td>
      </tr>
         <tr>
        <td ><input type="submit" value="Submit"/></td>
       </tr>
  </table>
 </form:form>
 
 <c:if test="${!empty employees}">
 <h2>List Employees</h2>
<table  border="1">
 <tr>
  <th>Employee ID</th>
  <th>Employee Name</th>
  <th>Employee Age</th>
  <th>Employee Salary</th>
  <th>Employee Address</th>
          <th>Actions on Row</th>
 </tr>
 <c:forEach items="${employees}" var="employee">
  <tr>
   <td><c:out value="${employee.id}"/></td>
   <td><c:out value="${employee.name}"/></td>
   <td><c:out value="${employee.age}"/></td>
   <td><c:out value="${employee.salary}"/></td>
   <td><c:out value="${employee.address}"/></td>
   <td ><a >Edit</a> | <a >Delete</a></td>
  </tr>
 </c:forEach>
</table>
</c:if>
</body>
</html>

Bean and DTO are the key classes to get and put list of objects, hence requesting help on how i should modify the code to display.

thanks
Abhee

5 years ago

Jsp UI utility to execute oracle db query

hi team,

I am looking for a utility framework or sample code which can be used to execute oracle queries from browser. (Insert queries).

thanks
Abhee

5 years ago

Null Pointer Exceptoin

Dave Tolls wrote:defect.get("Release")
That's the bit you want to be checking if its null...not the getAsString() value.
If there isn't a "Release" value then there's nothing there to call getAsString on.

That's good catch, thanks Dave.

5 years ago

Dave Tolls wrote:The format is only for parsing a String to a Date.
Date objects do not have a format.

As for not having the seconds in the DB, how are you reading values out of the db?

What database is it?

--Oracle is the database.

What is the column type?

-- column is Date type

5 years ago

Null Pointer Exceptoin

hi team,

i am trying to pull the data from Rally tool and some of the fields has nulls and i wrote below code to handle Exception and trying to insert default values.

I am getting null pointer exception, if i use below code.

5 years ago

Dave Tolls wrote:Can you post the full exception and stack trace?

Why are you parsing, formatting, and then parsing again?

thanks for your reply. May be i thinking too much and wrote some stupid code. After your comment, i modified the code as below and able to insert the data in date format.
i was trying to update the DB in yyyy/MM/dd hh:mm:ss. however with below code data is inserting in yyyy/MM/dd format. How can i pull time as well.

5 years ago

Dave Tolls wrote:Have you tried using SimpleDateFormat?
That's the class for turning a date string into a Date object.

thanks for prompt response.

Here is the piece of code i wrote. However while converting to sql date it is throwing casting exception.

5 years ago

hi all,

Please help on converting String to sql Date. i searched in java docs and couldn't find any relevant.

String s = "2016-11-30T06:24:45:760z"

thanks
Abhee

5 years ago

script to remove lower version jars in a directory

abheeshek reddy wrote:hi Guys,

I have a script to remove lower version jars files in a directory.

#!/bin/bash
#Script to remove lower version jar files.

for PREFIX in `ls *.jar|sed 's/-[0-9\.\0-9\.a-zA-Z]*\.jar//g'|uniq -d`; do
for FILE in `ls -r ${PREFIX}*|sed '1d'`; do
echo " $FILE"
rm $FILE
done
done

It has a bug and i need your help to figure and fix the bug.

I have below list of Duplicate jar files in a directory.

xyz-1.1.jar
xyz-1.1.1.jar
abc-1.6.jar
abc-1.3.jar
abc-xyz-pqr-1.9.6.jar
abc-xyz-pqr-1.9.2.jar
xyz-tom.jar
xyz-tom-20120423.jar
xyz-tom-20120410.jar
abc-toolkit-1.6-runtime-5.2.0.jar
abc-toolkit-1.6-runtime-5.0.0.jar

The bug is with xyz pattern jar files.
BUG: 1) Script is removing xyz-1.1.1.jar file instead of xyz-1.1.jar
2) Script is removing xyz-tom-20120423.jar and xyz-tom-20120410.jar files.

Thanks
Abhee

8 years ago

GNU/Linux

script to remove lower version jars in a directory

hi Guys,

I have a script to remove lower version jars files in a directory.

#!/bin/bash
#in a directory full of jar files, it is common to have multiple
#versions of the same jars. If versions are named with only periods
#and alphanumerics, then this groups the jars by the name, deletes
#all the lesser versions

#get a list of jars like x-1.0.0.RELEASE.jar, get only the jar name
#without version or .jar and get only non unique lines (ie., duplicate
#jars are found)
for PREFIX in `ls *.jar|sed 's/-[0-9\.a-zA-Z]*\.jar//g'|uniq -d`; do
echo $PREFIX
#now do a reverse sorted listing with the jar name and remove the
#top line so that non latest versions are returned
for FILE in `ls -r ${PREFIX}*|sed '1d'`; do
echo " $FILE"
rm -f $FILE
done
done

It has a bug and need your help to figure and fix the bug.

Scenario: Assuming i have two jars file in a directory with names xyz-1.1.jar and xyz-1.1.1.jar
This script is deleting xyz-1.1.1.jar (higher version) instead of lower version.

Thanks
Abhee

8 years ago

GNU/Linux

Jboss 7 deployment issue

hi all,

i am trying to deploy a ear file in Jboss7 and i am able to view below warning messages and error message in console.

WARN [org.jboss.as.server.deployment] (MSC service thread 1-4) Class Path entry xercesImpl-2.2.1.jar in "/C:/Windows/System32/content/some.ear/some.war/WEB-INF/lib/fop.jar" does not point to a valid jar for a Class-Path reference.

ERROR [stderr] (http--127.0.0.1-9001-1) 09/26/12 13:52:44.958 IST DEBUG (Thread[http--127.0.0.1-9001-1,5,main]) [VersionManager] Using lib directory file listing for fetching classpath

i have gone through some forums and i couldn't get in to right direction. I read in one of the forum that Jboss 7 doesn't classloading is it true?

below is the entry for my class loading file

<classloading xmlns="urn:jboss:classloading:1.0" name="some.war" domain="jboss" export-all="NON_EMPTY" import-all="false" parent-first="true"> </classloading>

thanks
abheeshek

9 years ago

JBoss/WildFly

NoClassDefFoundError

Jesper de Jong wrote:

abheeshek reddy wrote:The path has been set to my C:\Program Files\Java\jdk1.6.0_31\bin directory.

What the PATH is set to, is irrelevant for this question.

Ravi Vanamala wrote:Along with the PATH, try setting the JAVA_HOME=C:\Program Files\Java\jdk1.6.0_31 in environment "System Variables"

That's not going to solve anything either - the Java compiler and launcher do not use the JAVA_HOME environment variable at all.

NoClassDefFoundError means that your CLASSPATH is not correct, so that Java can't find a class it's looking for.

First, compile your source file with the command: javac SingletonDemo.java

If that succeeds without errors, check that you have a file named SingletonDemo.class in the current directory.

Then run it. Use the -cp option to specify the classpath; make sure the current directory "." is in the classpath:

java -cp . SingletonDemo

Thanks all it worked ... i resolved the problem by setting the current directory in classpath.

9 years ago

NoClassDefFoundError

John Jai wrote:1. Please check if the .class file is present in the classpath
2. Hope you first compiled using javac before executing java command.

Thanks John for prompt response,
Usual practice is we won't set individual .class files in classpath. However, previously i used to set only path variable in system variables. if required i used set rt.jar file in class path.

thanks

9 years ago