java 入门篇<二>

java Bean 的使用：

package com.chap;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Collection;

import com.mysql.jdbc.Statement;

public class Member_Bean {
private String name;
private String pwd;
private String email;
private int len;
private ArrayList<String> arrayList =new ArrayList<String>();
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public ArrayList<String> list()
{
Connection con=null;
try
{
Class.forName("com.mysql.jdbc.Driver");
con =DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test","root","120440");
Statement statement = (Statement) con.createStatement();
String sql = "select * from member_info";
ResultSet rs = statement.executeQuery(sql);
rs.last();
int c = rs.getRow();
this.setLen(c);
int count=0;
rs.first();

do
{
Member_Bean m = new Member_Bean();
m.setName(rs.getString(1));
m.setPwd(rs.getString(2));
m.setEmail(rs.getString(3));
arrayList.add(rs.getString(2));
count=count+1;
}while(rs.next());

rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
try
{
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
return arrayList;
}
public int getLen() {
return len;
}
public void setLen(int len) {
this.len = len;
}
}

JSP 页面代码：

<%
ArrayList<String> list = calculator.list();

String name;
calculator.list();
int len=calculator.getLen();
for(int i=0;i<len;i++)
{
%>******
<%=list.get(i)%>

<% }
%>