hey jos
thnks for your reply.
but can u explain it to me more clearly.
now my aim is to display the data of the logged in user to him(not all users)
for this i have changed the DAO and action classes as below.
RegisterDAO.java
Quote:
package dao;
import bean.User;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import javax.sql.DataSource;
public class RegisterDAO {
public Connection getConnection(DataSource carsite) {
Connection con = null;
DataSource ds =carsite;
try {
con = ds.getConnection();
} catch (SQLException e) {
e.printStackTrace();
}
return con;
}
public void closeConnection(Connection con) {
try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
public static ArrayList<User> getRecord(Connection con, User user) {
ArrayList<User> list= new ArrayList<User>();
String qry = "select * from register where username=?";
ResultSet resultSet = null;
try {
PreparedStatement pstat = con.prepareStatement(qry);
pstat.setString(1, user.getUid());
resultSet = pstat.executeQuery();
while (resultSet.next()) {
user.setFname(resultSet.getString("fname"));
user.setMname(resultSet.getString("mname"));
user.setLname(resultSet.getString("lname"));
user.setDob (resultSet.getString("dob"));
user.setAdd (resultSet.getString("address"));
user.setCity (resultSet.getString("city"));
user.setState(resultSet.getString("state"));
user.setZip (resultSet.getString("zip"));
user.setCno (resultSet.getString("cno"));
user.setEmail(resultSet.getString("email"));
user.setUid (resultSet.getString("fname"));
user.setPsswd(resultSet.getString("fname"));
list.add(user);
}
} catch (SQLException e) {
e.printStackTrace();
} return list;
}
public static User setRecord(Connection con, User user) {
int updateQuery= 0;
String qry = "INSERT INTO register VALUES('" + user.getFname() + "','" + user.getMname()
+ "','" + user.getLname() + "' ,'" + user.getDob() + " ','" + user.getAdd()
+ "','" + user.getCity() + "','" + user.getState() + "' ,'" + user.getZip() + "','"
+ user.getCno() + "','" + user.getEmail() + "','" + user.getUid() + "','"
+ user.getPsswd() + "')";
try {
System.out.println(qry);
PreparedStatement pstat = con.prepareStatement(qry);
updateQuery = pstat.executeUpdate();
if (updateQuery != 0)
{
System.out.println("****************************** ************");
System.out.println("Entries are Successfully entered into database");
}
}
catch (SQLException e) {
e.printStackTrace();
}
return user;
}
}
RegisterAction.java
Quote:
package action;
import java.sql.Connection;
import java.util.ArrayList;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import bean.User;
import dao.RegisterDAO;
import form.RegisterForm;
public class RegisterAction extends Action {
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {
RegisterDAO registerDAO = new RegisterDAO();
User user = new User();
DataSource ds = getDataSource(request);
Connection con = ds.getConnection();
RegisterForm form1= (RegisterForm)form;
user.setFname(form1.getFname());
user.setMname(form1.getMname());
user.setLname(form1.getLname());
user.setDob(form1.getDob());
user.setAdd(form1.getAdd());
user.setAdd(form1.getCity());
user.setCity(form1.getCity());
user.setState(form1.getState());
user.setZip(form1.getZip());
user.setCno(form1.getCno());
user.setEmail(form1.getEmail());
user.setUid(form1.getUid());
user.setPsswd(form1.getPsswd());
user= RegisterDAO.setRecord(con,user);
ArrayList<User> list= RegisterDAO.getRecord(con,user);
request.setAttribute("userinfo", list);
con.setAutoCommit(true);
registerDAO.closeConnection(con);
return mapping.findForward("success");
}
}
viewreginfo.jsp
Quote:
<%@ taglib uri="/WEB-INF/tlds/struts-html.tld" prefix="html" %>
<%@ taglib uri="/WEB-INF/tlds/struts-bean.tld" prefix="bean" %>
<%@ taglib uri="/WEB-INF/tlds/struts-logic.tld" prefix="logic" %>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>The Stored User Information</title>
</head>
<body background="nexus.jpg" >
<div id="top">
<table border="0">
<tr>
<td width="250">
<img src="car.jpg"/> </td>
<td width="250"> <h1 align="center"><font face="courier new" color="white">thecarsite</font></h1> </td>
<td width="250"> <h2 align="right"><html:link forward="index">Home</html:link></h2></td>
</tr>
</table>
<hr width="100%">
</div>
The Account information for user
<div id="restpage" >
<logic:iterate id="result" name="form1" property="userinfo">
<bean:write name="result" />
</logic:iterate>
</div>
</body>
</html>
and am replyin late cuz it was a holiday yesterday(an imp hindu festival called Rakhi).
hoping for guidance
Gaurav
