1. Create a website for an e-commerce company selling only the electronic goods. The website uses divisions and an external CSS file. Every page of the website is divided into four divisions namely – HEADING, FOOTER, MENU and CONTENT. (40 Marks) Solution: Mystyle.css
m o c om . t o t.c p s po g o s l g b . o l e t i te.b s u si o n g i gnou i
public class LoginAction implements Action { //method to process request public String processRequest() throws Exception { Logger logger=Logger.getRootLogger(); //read request data from ActionContext User user=new User(); user.setMailId( ActionContext.getParameter("userId")); user.setPassword( ActionContext.getParameter("password")); UserDao dao=new UserDao(); logger.info("ActionContext.getParameter(userId) "+ActionContext.getParameter("userId")); logger.info("ActionContext.getParameter(password) "+ActionContext.getParameter("password")); if(dao.findUser(user))
package com.bunkit.bca4.dao; import java.sql.*; import org.apache.log4j.Logger; public class UserDao extends AbstractDao { Logger logger=Logger.getRootLogger(); //Method to save the user public void save(User user) throws Exception { //Connection is obtained. Connection con=getConnection();//super class method //Statement object is created to execute the query. PreparedStatement stmt=con.prepareStatement( "insert into UserMaster (mailid,password)" + " values(?,?,?)"); //set the value of parameters.
b . te
i s u
o n ig
t o p
s g lo
stmt.setString(2,user.getMailId()); stmt.setString(3,user.getPassword()); //execute the query stmt.executeUpdate(); //close the connection con.close(); }
m o .c
//Method to update the user public void resetPassword(String p,String mid) throws Exception { //Connection is obtained. Connection con=getConnection();//super class method //Statement object is created to execute the query. PreparedStatement stmt=con.prepareStatement( "update usermaster set password=? where mailId=?"); //set the value of parameters. stmt.setString(1,p); stmt.setString(2,mid); //execute the query stmt.executeUpdate(); //close the connection logger.info("sucessfully reset your password "); con.close(); } //Method to delete the user public void delete(int userId) throws Exception { //Connection is obtained. Connection con=getConnection();//super class method //Statement object is created to execute the query.
Prepared by : IGNOU Study Helper
www.ignousite.blogspot.com Provided By : Sunil Poonia PreparedStatement stmt=con.prepareStatement( "delete from UserMaster where id=?"); //set the value of parameters. stmt.setInt(1, userId); //execute the query stmt.executeUpdate(); //close the connection con.close(); }
Page | 12
//Method to load a user using id public User getById(int userId) throws Exception { User user=null; //Connection is obtained. Connection con=getConnection();//super class method //Statement object is created to execute the query. PreparedStatement stmt=con.prepareStatement( "select * from UserMaster where userId=?"); //set the value of parameters. stmt.setInt(1, userId); //execute the query ResultSet rset=stmt.executeQuery(); //read the result of select query if(rset.next())//if user is found. { user=new User(); //store record data in object user.setId(rset.getInt(1)); user.setMailId(rset.getString(2)); user.setPassword(rset.getString(3));
m o .c
t o p
s g lo
b . te
i s u
} //close the connection con.close(); //return the user object return user; }
o n ig
//Method to find user using mailId and password public boolean findUser(User user) throws Exception { boolean flag=false; //Connection is obtained. Connection con=getConnection();//super class method //Statement object is created to execute the query. PreparedStatement stmt=con.prepareStatement( "select * from usermaster where mailId=? and password=?"); //set the value of parameters. stmt.setString(1, user.getMailId()); stmt.setString(2, user.getPassword()); //execute the query ResultSet rset=stmt.executeQuery(); //read the result of select query if(rset.next())//if user is found. { flag=true; //store record data in object user.setId(rset.getInt(1)); }
Prepared by : IGNOU Study Helper
www.ignousite.blogspot.com Provided By : Sunil Poonia
//close the connection con.close(); //return the user object return flag; } //find mail_id public User findMailId(String mailid) throws Exception { User user=new User(); //Connection is obtained. Connection con=getConnection();//super class method //Statement object is created to execute the query. logger.info(":::::user email id is "+mailid); PreparedStatement stmt=con.prepareStatement("select * from usermaster where mailId=?"); //set the value of parameters. stmt.setString(1, mailid); //execute the query ResultSet rset=stmt.executeQuery(); //read the result of select query if(rset.next())//if user is found. { //store record data in object user.setId(rset.getInt(1)); user.setMailId(rset.getString(2)); user.setPassword((rset.getString(3))); }
m o .c
t o p
//close the connection con.close(); //return the user object return user; } }
b . te
i s u
o n ig
s g lo
www.ignousite.blogspot.com IGNOU Study Helper
Prepared by : IGNOU Study Helper
Page | 13
m o c om . t o t.c p s po g o s l g b . o l e t i te.b s u si o n g i gnou i
