executejsp.java

一个简单的MVC模式例子

package testmvc;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Array;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import oracle.jdbc.OracleDriver;


public class Executejsp extends HttpServlet {

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException,IOException{

		response.setContentType("text/html;charset=GBK");
		 
		  
		   Method me=new Method();
		   
		   if(request.getParameter("select")!=null){
	
		  if("query".equals(request.getParameter("select"))){
		
		 String empno=request.getParameter("empno");
		EmpBean empbean2=null;
		try {
			empbean2 = me.queryData(empno);
			
			
			request.setAttribute("empBean", empbean2);
				request.getRequestDispatcher("showquery.jsp").forward(request, response);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
				
					 
	
		  }	 else if(request.getParameter("select").equals("delete")){
			  
			     try {
					me.deletedata(request.getParameter("empno"));
					request.setAttribute("empno", request.getParameter("empno"));
					request.getRequestDispatcher("showdelete.jsp").forward(request, response);
					
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			  
			  
			  
			  
			  
		  }  else  if(request.getParameter("select").equals("update")){
			     
			     String empno=request.getParameter("empno");
			     String ename=request.getParameter("ename");
			     String job=request.getParameter("job");
			     String mgr=request.getParameter("mgr");
		//	     String hiredate=request.getParameter("hiredate");
		//	     String sal=request.getParameter("sal");
		//	     String comm=request.getParameter("comm");
		//	     String deptno=request.getParameter("deptno");
			     try {
					me.updateData(empno, ename, job, mgr);
					request.getRequestDispatcher("showupdate.jsp").forward(request, response);
					
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			  
			  
			  
		  }
		  
		  else if(request.getParameter("select").equals("reset")){
			  String empno=request.getParameter("empno");
			  String job=request.getParameter("job");
			  String sal=request.getParameter("sal");
			  String comm=request.getParameter("comm");
			  
			  try {
				me.resetData(empno, job, sal, comm);
				request.getRequestDispatcher("showreset.jsp").forward(request, response);
				
				
				
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			  
			  
			  
			  
		  }
		   }
		  
		  else if(request.getParameter("flag").equals("1")){
			try{
				  new OracleDriver();
				  String url="jdbc:oracle:thin:@localhost:1521:tombo";
				  String sql="select *  from emp";
				  Connection con=DriverManager.getConnection(url, "scott", "tiger");
				  Statement st=con.createStatement();
				  ResultSet  rt=st.executeQuery(sql);
				  List list=new ArrayList();
				  
				  while(rt.next()){
					  EmpBean empbean=new EmpBean(); 
					  empbean.setEmpno(rt.getString("empno"));
					  empbean.setEname(rt.getString("ename"));
					  empbean.setJob(rt.getString("job"));
					  empbean.setSal(rt.getString("sal"));
					  
					  list.add(empbean);
					  
					   }
			  rt.close();
			st.close();	  
				  con.close();
				  
				  request.setAttribute("list", list);
				  request.getRequestDispatcher("showall.jsp").forward(request, response);
				  
				
				
			} catch(Exception e){
				e.printStackTrace();
				
			}
			  
			
			  
			  
			  
			  
		  }
		  
		  
	
	
}
			
			 
       public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException,IOException {

		   this.doGet(request, response);
		  
	}

}