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:
<%@ 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 :-
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:
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;
}
}