SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Mar 2011
    Posts
    10
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How to Autogenerate of ID from database and show on JSP page?

    problem in web application : I have a database names tasks in SQL server 2005 having tasks id as primary key, I am using JSP and struts,SQL server 2005 for database connectivity,Now I can update my database but i want to autogenerate tasks id in numbers on JSP page when I click on Create_Task.jsp page.How can i do so?My project storing user entered task id,task name ,date etc properly in the database,but what and how should i make it (in taskAction.java) that it auto generate tasks_id in jsp page when i click on Create_task.jsp and other data user can enter himself.I am using Jdeveloper.Codes:
    create.jsp :-
    Code:
    Code:
        <%@ page language="Java" %>  
        <%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html"%><%@ page contentType="text/html;charset=windows-1252"%>
        <%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>
        
        <html:form action ="taskAction.do">
          <head>
            <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
            <title>untitled</title>
          </head>
          <body>
            <form >
              <P>&nbsp;</P>
              <BLOCKQUOTE>
                <BLOCKQUOTE>
                  <BLOCKQUOTE>
                    <BLOCKQUOTE>
                      <P>
                        <SPAN style="background-color:rgb(204,204,204); background-color:rgb(204,204,204);"><SPAN style="background-color:rgb(255,255,255);"><FONT color="#006666"><STRONG><U><h1>
                          <SPAN style="background-color:rgb(255,255,255); background-color:rgb(204,204,204);">TASK MANAGER</SPAN>
                        </h1></U></STRONG>&nbsp;</FONT><SPAN style="background-color:rgb(204,255,255); background-color:rgb(204,204,255);"><FONT color="#003300">&nbsp;</FONT></SPAN> </SPAN></SPAN></P>
                    </BLOCKQUOTE>
                  </BLOCKQUOTE>
                </BLOCKQUOTE>
              </BLOCKQUOTE>
              <P>
                <SPAN style="background-color:rgb(204,255,255); background-color:rgb(204,204,255);"><FONT color="#003300">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Task Id &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                    <html:text property="taskid"/>
                  </FONT>
                </SPAN>
              </P>
              <P>
                <SPAN style="background-color:rgb(204,255,255); background-color:rgb(204,204,255);"><FONT color="#003300">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Task Name &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                    <html:text property="taskname"/>
                  </FONT>
                </SPAN>
              </P>
              <P>
                <SPAN style="background-color:rgb(204,255,255); background-color:rgb(204,204,255);"><FONT color="#003300">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Date &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                    <html:text property="dateOfBirth"/>
                  </FONT>
                </SPAN>
              </P>
              <P> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
              </P>
              <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
              <input type="submit" value="Submit"/></P>
            </form>
          </body>
        </html:form>
    taskAction.java :-
    Code:
    Code:
        //import TaskBO;
        import org.apache.struts.action.Action;
        import javax.servlet.http.HttpServletRequest;
        import javax.servlet.http.HttpServletResponse;
        import org.apache.struts.action.*;
        
        
        
        public class taskAction extends Action 
        {
         public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request,
                                      HttpServletResponse response) 
          {
            ActionForward forward;
            taskform tForm = (taskform) form; 
            Taskdata taskdata = populateTaskdata(tForm);
            TaskBO taskBO = new TaskBO();
            if (taskBO.createtask(taskdata)) 
            {
              forward = mapping.findForward("success");
            }
            else 
            {
              forward = mapping.findForward("failure");
            }
            return forward;
          
          }
            private Taskdata populateTaskdata(taskform form) 
          {
            Taskdata td = new Taskdata();
            td.setTaskid(form.getTaskid());
             td.setTaskname(form.getTaskname());
              td.setDateOfBirth(form.getDateOfBirth());
        
            return td;
          }
        }
    taskform.java :-
    Code:
    Code:
        import org.apache.struts.action.ActionForm;
        
        public class taskform extends ActionForm 
        {
        
          private int taskid;
          private String taskname;
          private String dateOfBirth;
          private String update;
          private String delete;
          
          public taskform()
          {
            taskid = 0;
            taskname = "";
            dateOfBirth = "";
          }
        
        
        
          public void setTaskid(int taskid)
          {
            this.taskid = taskid;
          }
          public int getTaskid()
          {
            return taskid;
          }
        
          
          public void setTaskname(String taskname)
          {
            this.taskname = taskname;
          }
          
            public String getTaskname()
          {
            return taskname;
          }
        
          public void setDateOfBirth(String dateOfBirth)
          {
            this.dateOfBirth = dateOfBirth;
          }
        
        
          public String getDateOfBirth()
          {
            return dateOfBirth;
          }
        
        
          public void setUpdate(String update)
          {
            this.update = update;
          }
        
        
          public String getUpdate()
          {
            return update;
          }
        
        
          public void setDelete(String delete)
          {
            this.delete = delete;
          }
        
        
          public String getDelete()
          {
            return delete;
          }
        }

  2. #2
    SitePoint Zealot
    Join Date
    Apr 2005
    Location
    London
    Posts
    163
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ID generation is usually from the database. Is that what you want?


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •