Home
Discussion
Discuss: JSP forward
Tutorial Topics
Questions by Category
- Swing-AWT
- Date-Calendar
- JDBC
- Regex
- XML
- Security
- Java Server Faces Questions
- JSP Servlet
- EJB
- JavaMail
- JMS
- Java3D
- Log4J
- Spring
- Hibernate
- Maven
- IDE Questions
- Mobile Applications
- Ajax
- Framework
- Struts
- WebSevices
- Java Magazine
- JSP-Interview Questions
- Java Interview Questions
- Servlet Interview Questions
- Hibernate Interview Questions
- JUNIT
- Java Beginners
- Applet
- JNDI
- RMI
- LDAP
- RUP
- UML
- SQL
- Design concepts & design patterns
- Ant
- CVS
- Subversion
- Development process
- AOP
- IoC
- PHP
Services
Home Privacy Policy
© All Rights are Reserved for Rose India
- Website Development
- Web Designing
- Web Redesigning
- Web Development
- Logo Design
- Web Design Packages
- Domain Registration
- Web Promotion Services
- SEO Services
- Search Eng. Optimization
- Search Eng. Submission
- SEO Tips
- SEO Portfolio
- Web Promotion Plans
Home Privacy Policy
© All Rights are Reserved for Rose India
Servlet jsp informationashwini October 3, 2011 at 5:18 PM
In first frame it displays the rows of a table,it as radio button for each row,the fields in column it includes id,name,location.when i click radio button in one frame the contents should be displayed in another frame when fetched from database,it should display each field of row in the form of text box in second frame. please help me out
answerramprabhu February 8, 2012 at 9:20 AM
package project.controller; import java.io.IOException; import java.sql.SQLException; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import project.bean.*; import project.model.*; protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { System.out.println("hi"); ProjectBean bean=new ProjectBean(); if(request.getParameter("action").equals("create")) { bean.setStudentname(request.getParameter("studentname")); System.out.println(request.getParameter("studentname")); bean.setDate(request.getParameter("date")); bean.setMark(Integer.parseInt(request.getParameter("mark"))); //System.out.println(+bean.getMark()); ProjectModel model=new ProjectModel(); try { bean=model.daoCallingMethod(bean); System.out.println("rohini"); request.setAttribute("message","Account created successfully"); RequestDispatcher redirect = getServletContext().getRequestDispatcher("/jsp/UI_page.jsp"); redirect.forward(request, response); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } else if(request.getParameter("action").equals("read")) { System.out.println("hello"); String studentname=request.getParameter("studentname"); System.out.println(studentname); ReadModel read=new ReadModel(); try { //request.setAttribute(studentname, bean); bean=read.readDaoCalling(studentname); request.setAttribute("studentname", bean); RequestDispatcher redirect = getServletContext().getRequestDispatcher("/jsp/display.jsp"); redirect.forward(request, response); System.out.println(studentname); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } else if(request.getParameter("action").equals("delete")) { bean.setStudentname(request.getParameter("studentname")); DeleteModel delete=new DeleteModel(); try { delete.deleteDaoCalling(bean); request.setAttribute("message","Deleted successfully"); RequestDispatcher redirect = getServletContext().getRequestDispatcher("/jsp/deletedisplay.jsp"); redirect.forward(request, response); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } else if(request.getParameter("action").equals("update")) { String studentname=request.getParameter("studentname"); System.out.println(studentname); request.setAttribute("studentname", bean); RequestDispatcher redirect = getServletContext().getRequestDispatcher("/jsp/updatepage.jsp"); redirect.forward(request, response); } else if(request.getParameter("action").equals("up")) { bean.setStudentname(request.getParameter("studentname")); System.out.println(request.getParameter("studentname")); bean.setDate(request.getParameter("date")); bean.setMark(Integer.parseInt(request.getParameter("mark"))); UpdateModel updatemodel=new UpdateModel(); try { updatemodel.updateDaoCalling(bean); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } } package project.dao; import project.bean.*; import java.sql.*; public class DaoClass extends Connections { public ProjectBean daoMethod(ProjectBean bean) throws ClassNotFoundException, SQLException { Connection connection=getConnection(); Statement statement=connection.createStatement(); System.out.println("insert into studentproject values('"+bean.getStudentname()+"','"+bean.getDate()+"',"+bean.getMark()+")"); System.out.println("daoclass"); ResultSet rs=statement.executeQuery("insert into studentproject values('"+bean.getStudentname()+"','"+bean.getDate()+"',"+bean.getMark()+")"); return bean; } public ProjectBean readDaoMethod(String studentname) throws ClassNotFoundException, SQLException { Connection connection=getConnection(); Statement statement=connection.createStatement(); ProjectBean bean=new ProjectBean(); System.out.println("select * from studentproject where studentname='"+studentname+"'"); ResultSet rs1=statement.executeQuery("select * from studentproject where studentname='"+studentname+"'"); while(rs1.next()) { bean.setStudentname(rs1.getString("studentname")); bean.setDate(rs1.getString("Applydate")); bean.setMark(rs1.getInt("mark")); } return bean; } public int deleteDaoMethod(ProjectBean bean) throws ClassNotFoundException, SQLException { Connection connection=getConnection(); Statement statement=connection.createStatement(); ResultSet rs2=statement.executeQuery("delete from studentproject where studentname='"+bean.getStudentname()+"'"); return 1; } public void updateDaoMethod(ProjectBean bean) throws ClassNotFoundException, SQLException { Connection connection=getConnection(); Statement statement=connection.createStatement(); int result =statement.executeUpdate("update studentproject set studentname='"+bean.getStudentname()+"',applydate='"+bean.getDate()+"',mark="+bean.getMark()+""); if(result==1) { System.out.println("data updated"); } else { System.out.println("data not updated"); } } } package project.dao; import java.sql.*; /*class for connections*/ public class Connections { Connection con=null; /*method for open connection*/ public Connection getConnection() throws ClassNotFoundException, SQLException { /* * creating connection */ Class.forName("oracle.jdbc.OracleDriver"); String url= "jdbc:oracle:thin:@172.24.137.30:1521:ora10g"; con=DriverManager.getConnection(url,"e543820","REaqbsude"); return con; } /*method for close connection*/ public void closeConnection(Connection con) throws SQLException { /* * closing connection */ con.close(); } } CREATE MODEL: package project.model; import java.sql.SQLException; import project.bean.*; import project.dao.*; public class ProjectModel { public ProjectBean daoCallingMethod(ProjectBean bean) throws ClassNotFoundException, SQLException { DaoClass dao=new DaoClass(); bean=dao.daoMethod(bean); return bean; } } READ MODEL: package project.model; import java.sql.SQLException; import project.bean.*; import project.dao.DaoClass; public class ReadModel { public ProjectBean readDaoCalling(String studentname) throws ClassNotFoundException, SQLException { DaoClass dao=new DaoClass(); ProjectBean bean=new ProjectBean(); bean=dao.readDaoMethod(studentname); return bean; } } DELETE MODEL: package project.model; import java.sql.SQLException; import project.bean.ProjectBean; import project.dao.DaoClass; public class DeleteModel { public int deleteDaoCalling(ProjectBean bean) throws ClassNotFoundException, SQLException { DaoClass dao=new DaoClass(); int result=dao.deleteDaoMethod(bean); return result; } } package project.model; import java.sql.SQLException; import project.bean.*; import project.dao.DaoClass; public class UpdateModel { public void updateDaoCalling(ProjectBean bean) throws ClassNotFoundException, SQLException { DaoClass dao=new DaoClass(); dao.updateDaoMethod(bean); } }
Post your Comment