dwrcommon.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.util.ArrayList;
import java.util.List;

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

public class DwrCommon {
	private Connection conn;
	private Statement stm;	
	private ResultSet rs;	
	private DBConnection db=DBConnection.getInstance();
	public int isMemberName(String memberName)throws MemberException{
		String sql = "select count(MemberID) from T_Member where MemberName='"+memberName+"'";		
		int count=0;
		try{
			conn=db.getConnection();
        	stm = conn.createStatement();
        	rs=stm.executeQuery(sql);
        	while(rs.next()){ 
        	    count=rs.getInt(1);	  
        	}
        	return count;        	
		}catch(SQLException e){
        	throw new MemberException("getMemberName error:"+e.getMessage());
        }finally{
        	db.closeConnection(conn, stm, rs);        	
        }
	}
	
	public List<GoodsType> getGoodsType(String parentID)throws MemberException{
		String sql = "select * from T_GoodsType where  parentID='"+parentID+"'";		
		List<GoodsType> list =new ArrayList<GoodsType>();
		try{
			conn=db.getConnection();
        	stm = conn.createStatement();
        	rs=stm.executeQuery(sql);
        	while(rs.next()){ 
        		GoodsType type=new GoodsType();
        		type.setTypeCode(rs.getString("TypeCode"));
        		type.setTypeName(rs.getString("TypeName"));
        		list.add(type);
        	}
        	return list;        	
		}catch(SQLException e){
        	throw new MemberException("getGoodsType error:"+e.getMessage());
        }finally{
        	db.closeConnection(conn, stm, rs);        	
        }
	}
	
	public GoodsType getTest(){
		GoodsType type=new GoodsType();
		type.setTypeCode("001");
		type.setTypeName("ok");
		return type;
	}
}