從list到struts和spring

package com.sterning.commons;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.sterning.books.model.Student;
public class PageDAO {
private Connection conn ;
private PreparedStatement pstmt ;
private ResultSet rs ;
private static final String DRIVER = "com.mysql.jdbc.Driver" ;
private static final String URL = "jdbc:mysql://localhost:3306/ssh2" ;
private static final String USERNAME = "root" ;
private static final String PASSWORD = "mysqling" ;

private Student student ;

//資料庫連線
public synchronized Connection getConnection () {
try {
Class.forName (DRIVER) ;
conn = DriverManager.getConnection (URL,USERNAME,PASSWORD) ;
} catch (ClassNotFoundException e) {
e.printStackTrace () ;
return null ;
} catch (SQLException e) {
e.printStackTrace () ;
return null ;
}
return conn ;
}

//分頁查詢
public List queryByPage (int pageSize, int pageNow) {
List list = new ArrayList () ;
try {
if (this.getConnection()!=null && pageSize>0 && pageNow>0) {
pstmt = this.getConnection().prepareStatement(
"select * from student order by stu_id limit "+(pageNow*pageSize-pageSize)+","+pageSize
);
rs = pstmt.executeQuery () ;
System.out.println("it is ok now,hehe");
// float ff =pageNow*pageSize-pageSize;
int ii = 0;
while (rs.next()) {
ii = ii +1;
// System.out.println("it is empty" + ff);
student = new Student () ;
student.setStu_id (rs.getInt(1)) ;
System.out.println(student.getStu_id());
student.setStuName (rs.getString(2)) ;
student.setAddress (rs.getString(3)) ;
student.setStuPhone (rs.getString(4)) ;
list.add (student) ;
}
System.out.println("ii:"+ii);
}
} catch(SQLException e) {
e.printStackTrace() ;
}
return list ;
}
}
***************************************************************************
package com.sterning.books.model;

public class Student {
private int stu_id ;
private String stuName ;
private String address ;
private String stuPhone ;

public Student () {
}

public int getStu_id () {
return stu_id ;
}

public void setStu_id (int stu_id) {
this.stu_id = stu_id ;
}

public String getStuName () {
return stuName ;
}

public void setStuName (String stuName) {
this.stuName = stuName ;
}

public String getAddress () {
return address ;
}

public void setAddress (String address) {
this.address = address ;
}

public String getStuPhone () {
return stuPhone ;
}

public void setStuPhone (String stuPhone) {
this.stuPhone = stuPhone ;
}
}

*********************************************

<!-- Add packages here --&gt


/index.jsp
/error.jsp



/show.jsp
/studenterror.jsp

************************************

show*****

Product Name	Price	Dianhua	Date of production

********************************************

">進入學員系統

[@more@]hehe