problem in inserting data

Hi every body

i am having problem in executing an insert query through JDBC

my table is

my code of execution is

private void insertToDb(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {

System.out.println("hi hello2");
        int empNumber=Integer.parseInt(request.getParameter("empNumber"));
        String firstName=request.getParameter("firstName");
        String lastName=request.getParameter("lastName");
        String password=request.getParameter("password");
        String selectedPrivileges=request.getParameter("selectedPrivileges");
        String role=request.getParameter("roleNewUser");
        int userStatus=1;
        java.util.Date date = new java.util.Date();
        java.sql.Date sqlDate = new java.sql.Date(date.getTime());
        boolean blnGotSomeRows;
        boolean check=true;
        String url;
        //System.out.println("hi hello3");
            //EmpJavaBean emp=new EmpJavaBean();
            Statement st=null;
            Connection connection=null;
            ResultSet rs=null;
            String query=null;
        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/presize","root","root");
            st=connection.createStatement();
            query="select  distinct EMP_ID from USER" ;            
            rs=st.executeQuery(query);            
            
            //checking if result Set contain any row or not
            if(!rs.next())
            {                
                System.out.println("result set emppty");
                url="/presize/jsp/insRsetEmpty.jsp";
                System.out.println(date);
                
            }
            else
            {
                System.out.println("result set not empty");
                //System.out.println(date);
                //System.out.println("ramendra");
                rs.beforeFirst();
                // checking if the information of particular id already exist
                while(rs.next())
                {
                    if(rs.getInt("EMP_ID")==empNumber)
                    {
                        check=false;
                        System.out.println("this id already exist");
                        break;
                    }                    
                }

if(check!=true)
                {
                    url="/presize/jsp/insEmpExist.jsp";
                }
                else
                {
                    query=" insert into USER(EMP_ID,FIRST_NAME,LAST_NAME,USER_STATUS,PASSWORD,CREATED_BY,CREATED_DATE,LAST_UPDATED_BY,LAST_UPDATED_DATE) " +
                            " values( "+empNumber+",'"+firstName+"','"+lastName+"',"+userStatus+", '"+password+"', "+empNumber+", '"+sqlDate+"', "+empNumber+", '"+sqlDate+"'  ";
                    st.executeUpdate(query);

url="/presize/jsp/insSuccessful.jsp";
                }
            }

}catch(Exception e)
        {
            System.out.println(" Error is " + e);
        }
    }

my error while executing is

:<b> Error is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
</b>

You don't close your SQL statement's values clause. Your SQL shouyld be like:

what you've got is:

Also, its much better practice to use a PreparedStatement rather than a Statement. It will make your life easier in the long run.