usebean.java

一个基于MVC模式的经典的分页设计

package com.nicho;

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

import oracle.jdbc.OracleDriver;

public class UseBean {
	
	  private String empno;
	  private String ename;
	  private String job;
	  private String sal;
	
	public String getEmpno() {
		return empno;
	}


	public void setEmpno(String empno) {
		this.empno = empno;
	}

	public String getEname() {
		return ename;
	}

	public void setEname(String ename) {
		this.ename = ename;
	}

	public String getJob() {
		return job;
	}

	public void setJob(String job) {
		this.job = job;
	}

	public String getSal() {
		return sal;
	}

	public void setSal(String sal) {
		this.sal = sal;
	}

	 public int getTotalrow() throws SQLException{
		
		
	    new OracleDriver();
         String url="jdbc:oracle:thin:@localhost:1521:tombo";
         String sql1= " select count(*)  as totalrow from  emp";
	     Connection con=DriverManager.getConnection(url, "scott", "tiger");
		 Statement st=con.createStatement();
		 ResultSet rt=st.executeQuery(sql1);
		 rt.next();
		 int totalrow=rt.getInt("totalrow");
		
		rt.close();
		st.close();
		con.close();
		
		return totalrow;
		
		
		
		
	}
	   
	

}