Hi guys.
I have a problem with connecting to Access database like inserting values in a table etc.
My Registration.jsp:
<%@ page language="java" %>
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>
<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>
<html>
<head><title>Registration</title></head>
<body>
<h3>Register</h3>
<html:errors/>
<html:form action="submit.do">
First Name: <html:text property="firstName"/><br>
Last Name: <html:text property="lastName"/><br>
Address: <html:textarea property="address"/><br>
Phone no: <html:text property="pnumber"/><br>
D.O.B: <html:text property="dob"/><br>
Sex: <html:radio property="sex" value="M"/>Male
<html:radio property="sex" value="F"/>Female<br>
<html:submit/>
</html:form>
<logic
resent name="lastName" scope="request">
Hello
<logic:equal name="submitForm" property="age" value="a">
young
</logic:equal>
<logic:equal name="submitForm" property="age" value="c">
old
</logic:equal>
<bean:write name="lastName" scope="request"/>
</logic
resent>
</body>
</html>
My Action Class : RegisterAction.java
import javax.servlet.http.HttpServletRequest;
import javax.servlet.*;
import javax.servlet.GenericServlet;
import javax.servlet.ServletContext;
import javax.servlet.ServletConfig;
import javax.servlet.http.*;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
import java.io.*;
import javax.servlet.http.*;
import org.apache.struts.action.*;
public class RegisterAction extends Action {
// private
String Mobile;
static Connection theConn;
public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException{
String lastName,firstName, upno,uname,uaddress,upwd,dob, mob;
RegisterForm f=(RegisterForm)form;
firstName=f.getFirstName();
request.setAttribute("firstName", firstName.toUpperCase());
lastName=f.getLastName();
request.setAttribute("lastName", lastName.toUpperCase());
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc
dbc:Church";
// return mapping.findForward("success");
try
{
Class.forName(driver);
Connection connection = DriverManager.getConnection(url);
// theConn = MyConnection.getConnection();
String ssql="insert into userinfo values(?,?)";
PreparedStatement pistmt=connection.prepareStatement(ssql);
pistmt.setString(1,firstName);
pistmt.setString(2,lastName);
ResultSet rs= pistmt.executeQuery();
// pistmt.executeUpdate();
connection.close();
return mapping.findForward("success");
} catch(Exception e)
{
//out.println(e);
return mapping.findForward("error");
}
/** Creates a new instance of Registeruser*/
// return mapping.findForward("success");
}
}
Struts Config.xml:
<?xml version="1.0" encoding="ISO-8859-1" ?>
<!DOCTYPE struts-config PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 1.2//EN"
"http://jakarta.apache.org/struts/dtds/struts-config_1_2.dtd">
<struts-config>
<data-sources>
<data-source>
<set-property property="driverClass"
value="sun.jdbc.odbc.JdbcOdbcDriver"
<set-property property="url"
value="jdbc
dbc:Church" />
</data-source>
</data-sources>
<form-beans>
<form-bean name="registerForm"
type="reg.RegisterForm"/>
</form-beans>
<global-exceptions>
</global-exceptions>
<global-forwards>
<forward name="welcome" path="/Welcome.do"/>
</global-forwards>
<action-mappings>
<action path="/submit"
type="reg.RegisterAction"
name="registerForm"
input="/Registration.jsp"
scope="request"
validate="true">
<forward name="success" path="/Success.html"/>
<forward name="error" path="/Error.html"/>
</action>
</action-mappings>
<controller processorClass="org.apache.struts.tiles.TilesRequestProcessor"/>
<message-resources parameter="com/myapp/struts/ApplicationResource"/>
<plug-in className="org.apache.struts.tiles.TilesPlugin" >
<set-property property="definitions-config" value="/WEB-INF/tiles-defs.xml" />
<set-property property="moduleAware" value="true" />
</plug-in>
<plug-in className="org.apache.struts.validator.ValidatorPlugIn">
<set-property
property="pathnames"
value="/WEB-INF/validator-rules.xml,/WEB-INF/validation.xml"/>
</plug-in>
</struts-config>
Note:
When the data-sources tag is added in the struts config.xml file, an error comes and if I remove it, atleast it goes to Error.html page. No data is entered in the "userinfo" table in the "Church" database.
Is my data-source tag is alrite or any changes have to be made?
Please help me so that I could successfully enter data in the Access database table.
Thanks a lot.
