mysql jdbc

package dao.separapage;

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 bean.separapage.Department;

public class SeparaDAO {
 
// 建立连接对象

 public static String url="jdbc:mysql://localhost:3306/test?user=root&password=root";

 public static Connection conn;

// 建立SQL陈述式对象（Statement Object）

 public static Statement stmt;
 public static List getConn(int pageNum,int pageSize) throws SQLException{
  try {
   Class.forName("com.mysql.jdbc.Driver");

   Class.forName("com.mysql.jdbc.Driver").newInstance();
   conn = DriverManager.getConnection(url);
   stmt = conn.createStatement();
//   执行SQL语句

//   executeQuery()

   String query = "select * from separa_page_t limit "+(pageNum-1)*pageSize+","+pageSize;

   ResultSet rs=stmt.executeQuery(query);
   List l = new ArrayList();
   while(rs.next()){
    Department d = new Department();
    d.setCity(rs.getString("city"));
    d.setDepartment(rs.getString("department"));
    l.add(d);
   }
   return l;
  } catch (ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (InstantiationException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (IllegalAccessException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }finally{
   if(stmt!=null){
    stmt.close();
   }
   if(conn!=null){
    stmt.close();
   }
   
  }
  return null;

 }
 public static void main(String[] args) {
//  SeparaDAO.getConn(2,20);
 }
}