membermanage.java

网上商城代码

package com.fendou.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Timestamp;

import com.fendou.exception.MemberException;
import com.fendou.platform.DBConnection;
import com.fendou.vo.Member;

public class MemberManage {
	private Connection conn;
	private PreparedStatement pstm;	
	private Statement stm;	
	private ResultSet rs;	
	private DBConnection db=DBConnection.getInstance();
	
	public void addMember(Member member)throws MemberException{
		String sql = "insert into T_Member(MemberName,MemberPassword,MemberEmail,"
			      + "MemberStatus,CreateDate,UpdateDate) values(?,?,?,?,?,?)";       
        try{
        	conn=db.getConnection();
        	pstm = conn.prepareStatement(sql);		
        	pstm.setString(1, member.getMemberName());
        	pstm.setString(2, member.getMemberPassword());
        	pstm.setString(3, member.getMemberEmail());
        	pstm.setString(4, member.getMemberStatus());        	
        	pstm.setTimestamp(5, new Timestamp(member.getCreateDate().getTime()));        	
        	pstm.setTimestamp(6, new Timestamp(member.getUpdateDate().getTime()));
			pstm.execute();
        }catch(SQLException e){
        	throw new MemberException("addMember error:"+e.getMessage());
        }finally{
        	db.closeConnection(conn, pstm, rs);        	
        }
	}
	
	
}