problem in web application : I have a database names tasks in SQL server 2005 having tasks id as primay key, I am using JSP and struts 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 CreateTask.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 tasksid in jp page when i click on Create_task.jsp and other data user can enter himself.I am using Jdeveloper.Codes: create.jsp :-
<%@ 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> </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> </FONT><SPAN style="background-color:rgb(204,255,255); background-color:rgb(204,204,255);"><FONT color="#003300"> </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"> Task Id <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"> Task Name <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"> Date <html:text property="dateOfBirth"/> </FONT> </SPAN> </P> <P> </P> <P> <input type="submit" value="Submit"/></P> </form> </body> </html:form>
taskAction.java :-
//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 :-
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; } }
Ads