addressimpt.java

自己制作的联通CRM,支持客户分类,管理,升级,积分管理等等..

package com.jn0801.clientmanage;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.jn0801.tools.DBConnection;

public class Addressimpt {
	
	/**
	 * 
	 * 查询地区
	 * 
	 * @param praid
	 * @return List
	 */
public List<AddressBean> listaddress(int praid) {
		
		List<AddressBean> list = new ArrayList<AddressBean>();
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		
		
		String sql = "select * from adress where 1=1 ";
		if(praid!=-1)
			sql = sql + " and praid = " + praid ;
	
		try {
			conn  = DBConnection.getConnection();
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
			
			while(rs.next()){
				AddressBean address = new AddressBean();
				address.setAid(rs.getInt("aid"));
				address.setAname(rs.getString("aname"));
				address.setPraid(rs.getInt("praid"));
				list.add(address);
				
			}

		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			try {
				if(rs!=null)
					rs.close();
				if(stmt!=null)
					stmt.close();
				if(conn!=null)
					conn.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
			
			
		}
		return list;
	}

/**
 * 
 * 查询地区
 * 
 * @param aid
 * @return List
 */
public List<AddressBean> listaddress1(int aid) {
	
	List<AddressBean> list = new ArrayList<AddressBean>();
	Connection conn = null;
	Statement stmt = null;
	ResultSet rs = null;
	
	
	String sql = "select * from adress where 1=1 ";
	if(aid!=-1)
		sql = sql + " and aid = " + aid ;

	try {
		conn  = DBConnection.getConnection();
		stmt = conn.createStatement();
		rs = stmt.executeQuery(sql);
		
		while(rs.next()){
			AddressBean address = new AddressBean();
			address.setAid(rs.getInt("aid"));
			address.setAname(rs.getString("aname"));
			address.setPraid(rs.getInt("praid"));
			list.add(address);
			
		}

	} catch (Exception e) {
		e.printStackTrace();
	}finally{
		try {
			if(rs!=null)
				rs.close();
			if(stmt!=null)
				stmt.close();
			if(conn!=null)
				conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		
		
	}
	return list;
}

/**
 * 
 * 查询地区
 * 
 * @param aname
 * @return List
 */
public List<AddressBean> listaddress2(String aname) {
	
	List<AddressBean> list = new ArrayList<AddressBean>();
	Connection conn = null;
	Statement stmt = null;
	ResultSet rs = null;
	
	String sql1 = "select aid from adress where 1=1 ";
	if(aname!=null)
		sql1 = sql1 + " and aname = '" + aname+"'" ;
	conn  = DBConnection.getConnection();
	int praid=0;
	try {
		stmt = conn.createStatement();
		rs = stmt.executeQuery(sql1);
		
		if(rs.next())
		{
			praid=rs.getInt(1);
		}
	} catch (SQLException e1) {
		// TODO 自动生成 catch 块
		e1.printStackTrace();
	}
	
	String sql = "select * from adress where 1=1 ";
	if(praid!=-1)
		sql = sql + " and praid = " + praid;

	try {
		conn  = DBConnection.getConnection();
		stmt = conn.createStatement();
		rs = stmt.executeQuery(sql);
		
		while(rs.next()){
			AddressBean address = new AddressBean();
			address.setAid(rs.getInt("aid"));
			address.setAname(rs.getString("aname"));
			address.setPraid(rs.getInt("praid"));
			list.add(address);
			
		}

	} catch (Exception e) {
		e.printStackTrace();
	}finally{
		try {
			if(rs!=null)
				rs.close();
			if(stmt!=null)
				stmt.close();
			if(conn!=null)
				conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		
		
	}
	return list;
}


public List<AddressBean> listaddress2() {
	
	List<AddressBean> list = new ArrayList<AddressBean>();
	Connection conn = null;
	Statement stmt = null;
	ResultSet rs = null;
	
	
	String sql = "select * from adress where praid!=0";

	try {
		conn  = DBConnection.getConnection();
		stmt = conn.createStatement();
		rs = stmt.executeQuery(sql);
		
		while(rs.next()){
			AddressBean address = new AddressBean();
			address.setAid(rs.getInt("aid"));
			address.setAname(rs.getString("aname"));
			address.setPraid(rs.getInt("praid"));
			list.add(address);
			
		}

	} catch (Exception e) {
		e.printStackTrace();
	}finally{
		try {
			if(rs!=null)
				rs.close();
			if(stmt!=null)
				stmt.close();
			if(conn!=null)
				conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		
		
	}
	return list;
}
}