userbean.java

jiava中简单的基础的jsp增删改查适合处学者

/*
 * 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;
    }
    
}