userdetailedinfodao.java

网上购物源代码

/**
 * 
 */
package com.chinaaccpDao;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

import com.chinaaccpbean.UserInfoBean2;

/**
 * @author Administrator
 *
 */
public class UserDetailedInfoDao {

	public UserInfoBean2 GetUsrDetaInfo(String logname)
	{
		Connection con = null;
		UserInfoBean2 userinfo = null;
		try {
			con = ConnectionLee.GetCon();
			Statement st = con.createStatement();
			String sql = "select name,idnum,postcode,address,email,tel,pricture from UserInfo where logname='"+logname+"'";
			ResultSet rs = st.executeQuery(sql);
			if(rs.next())
			{
				userinfo = new UserInfoBean2();
				userinfo.setName(rs.getString(1));
				userinfo.setIdnum(rs.getString(2));
				userinfo.setPostcode(rs.getString(3));
				userinfo.setAddress(rs.getString(4));
				userinfo.setEmail(rs.getString(5));
				userinfo.setTel(rs.getString(6));
				
			}
			st.close();
			con.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return userinfo;
	}
	public String GetUpdatePricture(String path,String name)
	{
		String mess = null;
		Connection con = null;
		try {
			con = ConnectionLee.GetCon();
			Statement st = con.createStatement();
			String sql = "update userinfo set pricture='"+path+"' where logname='"+name+"'";
			int row = st.executeUpdate(sql);
			if(row>0)
			{
				mess = "上传成功";
			}
			else
				mess="上传失败";
		} catch (Exception e) {
			mess = e.getMessage();
		}
		return mess;
	}
	public String GetUpdateUserInfo(UserInfoBean2 user,String logname)
	{
		String upmess = null;
		Connection con = null;
		try {
			con = ConnectionLee.GetCon();
			Statement st = con.createStatement();
			String sql = "update userinfo set name='"+user.getName()+"',idnum='"+user.getIdnum()+"',postcode='"+user.getPostcode()+"',address='"+user.getAddress()+"',email='"+user.getEmail()+"',tel='"+user.getTel()+"' where logname='"+logname+"'";
			int row = st.executeUpdate(sql);
			if(row>0)
			{
				upmess="修改成功";
				return upmess;
			}
			else
			{
				upmess="失败";
				return upmess;
			}
		} catch (Exception e) {
			upmess=e.getMessage();
		}
		return upmess;
	}
	public String GetUpdatePass(String newpass,String logname)
	{
		String info = null;
		Connection con = null;
		try {
			con = ConnectionLee.GetCon();
			Statement st = con.createStatement();
			String sql = "update userinfo set password='"+newpass+"' where logname='"+logname+"'";
			int row = st.executeUpdate(sql);
			if(row>0)
			{
				info = "修改成功";
			}
		} catch (Exception e) {
			info = e.getMessage();
		}
		return info;
	}
}