userinfo.java

用J2EE开发的网站,可以应用到图书馆,图书超市

package ksnb;
//从数据库获得用户信息以显示到虚拟订单上的javabean
import java.sql.*;
import javax.servlet.http.HttpSession.*;
import javax.servlet.http.HttpSession;

public class userinfo {
    //只在订单上反映用户的这些信息
    static String name;
    static String sex;
    static String tel;
    static String address;
    static String email;
    static String postcode;

    Connection con;
    Statement st;
    ResultSet rs;
    conn cn;


    //先假设一个用户名zjd为条件，到时候可以用session用户登录名替换

    public userinfo(String username) {
       String sql="select Name,Sex,Tel,Address,Email,Postcode from shop_member_info where account='"+username+"'";
        try{
        cn=new conn();
        con=cn.getConncetion();
        st=con.createStatement();
        //先假设一条记录，不用循环（用户名本来就是不能重复的）
        rs=st.executeQuery(sql);
        while(rs.next())
        {
            name= rs.getString("Name");
            sex=rs.getString("Sex");
            address=rs.getString("Address");
            tel=rs.getString("Tel");
            email=rs.getString("Email");
            postcode=rs.getString("Postcode");
        }
        System.out.println("连接成功");
       }catch(Exception e){
           System.out.println(e.getMessage()+"数据库连接失败……");
       }
    }
    //获得用户信息

    public String getName()
    {
        return name;
    }


    public String getSex()
   {
       return sex;
   }


   public String getTel()
   {
       return tel;
   }

   public String getAddress()
  {
      return address;
  }

   public String getEmail()
   {
       return email;
   }
   public String getPostcode()
{
    return postcode;
}


   public void getClose() throws connException{
       try{
           cn.conClose();
           rs.close();
       }catch(Exception e){}
   }
}