method.java

一个简单的MVC模式例子

package testmvc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import oracle.jdbc.driver.OracleDriver;

  public class Method {
	  
	  
  public 	String url="jdbc:oracle:thin:@localhost:1521:tombo";
	
  public 	Connection con=null;
  public 	PreparedStatement pst=null;
  public 	ResultSet  rt=null;
  
  
  
	public   EmpBean queryData( String empno) throws SQLException{
		        EmpBean empbean=new EmpBean();
		  
			new OracleDriver();
		    String sql="select *  from emp where empno=?";
	       con=DriverManager.getConnection(url, "scott", "tiger");
			pst=con.prepareStatement(sql);
			pst.setInt(1, Integer.parseInt(empno));
			
			              
                       			
			rt=pst.executeQuery();
		
			while(rt.next()){
				empbean.setComm(rt.getString("comm"));
				empbean.setDeptno(rt.getString("deptno"));
				empbean.setEmpno(rt.getString("empno"));
				empbean.setEname(rt.getString("ename"));
				empbean.setHiredate(rt.getString("hiredate"));
				empbean.setJob(rt.getString("job"));
				empbean.setMgr(rt.getString("mgr"));
				empbean.setSal(rt.getString("sal"));
				
			}
			 rt.close();
			  pst.close();
			  con.close();
			  return empbean;
			
		
}
	public void deletedata(String empno) throws SQLException{
		
		  new OracleDriver();
		  String sql="delete from emp where empno=?";
		   con=DriverManager.getConnection(url, "scott", "tiger");
			pst=con.prepareStatement(sql);
			pst.setInt(1, Integer.parseInt(empno));
			
			pst.executeUpdate();
			              
			 
			  pst.close();
			  con.close();       			
			
		
		
		}
	
	public void updateData(String empno,String ename,String job,String mgr) throws SQLException{
		
		  new OracleDriver();
		  String sql="insert into emp(empno,ename,job,mgr)  values(?,?,?,?)";
		   con=DriverManager.getConnection(url, "scott", "tiger");
			pst=con.prepareStatement(sql);
		    pst.setInt(1, Integer.parseInt(empno));
		    pst.setString(2, ename);
		    pst.setString(3, job);
		    pst.setInt(4, Integer.parseInt(mgr));
		 //   pst.setString(5, hiredate);
		 //   pst.setInt(5, Integer.parseInt(sal));
		  //  pst.setInt(6, Integer.parseInt(comm));
		 //   pst.setInt(7, Integer.parseInt(deptno));
		
		  pst.executeUpdate();
		
		  
		  pst.close();
		  con.close();
		
	}
	
	    public void resetData(String empno, String  job,String sal,String comm ) throws SQLException{
	    	
	    	new OracleDriver();
	    	
	    	String url="jdbc:oracle:thin:@localhost:1521:tombo";
	    	String sql="update emp set job=? ,sal=?,comm=? where empno="+empno;
	    	Connection con=DriverManager.getConnection(url, "scott","tiger");
	    	PreparedStatement pst=con.prepareStatement(sql);
	    	pst.setString(1, job);
	    	pst.setInt(2, Integer.parseInt(sal));
	    	pst.setInt(3, Integer.parseInt(comm));
	    	
	    	pst.executeUpdate();
	    	
	    	
	    	pst.close();
			  con.close();
	    	
	    	
	    	
	    	
	    }
	
}