/* * To change this template, choose Tools | Templates * and open the template in the editor. */package bean;import java.sql.*;import db.DBConnetion;import java.util.ArrayList;/** * * @author Administrator */public class UserBean {    private String name;    private String pwd;    private String userName;    private String email;    private String like;    private String address;    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 getUserName() {        return userName;    }    public void setUserName(String userName) {        this.userName = userName;    }    public String getEmail() {        return email;    }    public void setEmail(String email) {        this.email = email;    }    public String getLike() {        return like;    }    public void setLike(String like) {        this.like = like;    }    public String getAddress() {        return address;    }    public void setAddress(String address) {        this.address = address;    }    //查詢方法 返回一個ArrayList    public ArrayList getData(String sql){        ArrayList list = new ArrayList();        db.DBConnetion conn = new DBConnetion();        ResultSet rs = conn.selectQeary(sql);                try{            while(rs.next()){                UserBean bean = new UserBean();                bean.setName(rs.getString(1));                bean.setPwd(rs.getString(2));                bean.setUserName(rs.getString(3));                bean.setEmail(rs.getString(4));                bean.setLike(rs.getString(5));                bean.setAddress(rs.getString(6));                list.add(bean);            }        }catch(Exception ex){            ex.printStackTrace();        }finally{            conn.close();        }        return list;    }    //查詢方法 返回一個 String []    //查詢方法    public String[] selectQeary1(String sql) {        String[] arr = null;        DBConnetion conn1 = new DBConnetion();        java.sql.ResultSet rs = conn1.selectQeary(sql);        try {            while(rs.next()){                 arr = new String[]{                 rs.getString(1),                 rs.getString(2),                 rs.getString(3),                 rs.getString(4),                 rs.getString(5),                 rs.getString(6),            };            }        } catch (Exception ex) {           System.out.println(ex);        }        return arr;    }    }