Sample Program:
Jsp:
<!DOCTYPE HTML PUBLIC "//W3C//DTD HTML 4.01 Transitional//EN">
<%@ taglib uri="/WEBINF/struts[Link]" prefix="html" %>
<%@ taglib uri="/WEBINF/struts[Link]" prefix="bean" %>
<%@ page language="java" contentType="text/html; charset=ISO88591"%>
<html:base/>
<html:html>
<HEAD>
<META httpequiv="ContentType" content="text/html; charset=ISO88591">
<META name="GENERATOR" content="IBM WebSphere Studio">
<TITLE>[Link]</TITLE>
<script language="JavaScript">
function doSubmit(op)
{
[Link][0].[Link]=op;
[Link][0].submit();
}
function success(rest){
if(rest=="pass"){
alert("Record successfully saved");
}
else if(rest=="fail"){
alert("Record not saved");
}
}
</script>
</HEAD>
<%if(!"null".equals([Link]().getAttribute("saved")) && !
"".equals([Link]().getAttribute("saved")))
{%>
<BODY
onload="javascript:success('<%=[Link]().getAttribute("saved"
)%>');">
<%}else{%>
<body>
<%}%>
<html:form action="SampleAction">
<input type="hidden" name="operation"/>
<table width="0" border="1" bordercolor="#336699" class="label2"
cellspacing="1" cellpadding="1" height="0" bgcolor="#FFFFFF">
<tr class="staticlabel2">
<td class="staticlabel2"> <strong><font size="1" face="Verdana, Arial,
Helvetica, sansserif">
First Name<html:text name="SampleForm" property="first"/>
</strong></font></td>
</tr>
<tr class="staticlabel2">
<td class="staticlabel2"> <strong><font size="1" face="Verdana, Arial,
Helvetica, sansserif">
Last Name<html:text name="SampleForm" property="second"/>
</strong></font></td>
</tr>
<tr>
<td>
<div align="center">
<input name="Save" type="button" value="Save"
onClick="javascript:doSubmit('save');">
<input name="Reset" type="button" value="Reset"
onClick="javascript:doSubmit('reset');">
</div>
</td>
</tr>
</table>
</html:form>
</BODY>
</html:html>
Action:
Package [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
public class UPSLSampleAction extends UPSLBaseAction{
public String performAction(ActionMapping mapping, ActionForm
form, HttpServletRequest request,
HttpServletResponse response) throws UPSLException
{
[Link]().setAttribute("saved","");
UPSLSampleForm sampform=(UPSLSampleForm)form;
if([Link]("operation")!=null)
{
if("save".equals([Link]("operation")))
{
UPSLSampleBean sampbean=ConvertToBean(sampform);
UPSLSampleMg sampmg=new UPSLSampleMg();
String retval=[Link](sampbean);
[Link]().setAttribute("saved",retval);
}
else
if("reset".equals([Link]("operation")))
{
[Link]("");
[Link]("");
}
}
return "sample";
}
private UPSLSampleBean ConvertToBean(UPSLSampleForm sampform)
{
UPSLSampleBean sampbean=new UPSLSampleBean();
[Link]([Link]());
[Link]([Link]());
return sampbean;
}
FormBean:
package [Link];
import [Link];
public class UPSLSampleForm extends ActionForm {
private String first=null;
private String second=null;
public String getFirst() {
return first;
}
public String getSecond() {
return second;
}
public void setFirst(String first) {
[Link] = first;
}
public void setSecond(String second) {
[Link] = second;
}
JavaBean:
package [Link];
public class UPSLSampleBean {
private String first=null;
private String second=null;
public String getFirst() {
return first;
}
public String getSecond() {
return second;
}
public void setFirst(String first) {
[Link] = first;
}
public void setSecond(String second) {
[Link] = second;
}
Manger:
package [Link];
import [Link];
import [Link];
import [Link];
import [Link];
public class UPSLSampleMg {
Connection con=null;
public UPSLSampleMg()
{
try
{
con=[Link]();
}catch(Exception e){}
}
public String savemg(UPSLSampleBean sampbean) {
UPSLSampleDb sampdb=new UPSLSampleDb(con);
String val=[Link](sampbean);
return val;
}
Db:
package [Link];
import [Link];
import [Link];
import [Link];
import [Link];
public class UPSLSampleDb {
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
public UPSLSampleDb(Connection con) {
[Link]=con;
}
public String savedb(UPSLSampleBean sampbean) {
String samfirst=null;
String samsecond=null;
String fir=[Link]();
String sec=[Link]();
String ret="pass";
try{
String insertQuery="insert into sam_master
values('"+fir+"','"+sec+"')";
stmt=[Link]();
[Link](insertQuery);
}catch(Exception e){
ret="fail";
}
return null;
}
}