userdao.java

来自「用标签做的分页源代码」· Java 代码 · 共 59 行

package com.bluedot.persist;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.bluedot.common.JdbcUtil;
import com.bluedot.domain.User;

public class UserDao {
	public List<User> findUser(User user) {
		List<User> list = new ArrayList<User>();
		try {
			
			Connection connect = JdbcUtil.getConnection();
			String sql = getSql(user);
			System.out.println(sql+">>>>>>.");

			PreparedStatement p = connect.prepareStatement(sql);
			ResultSet rs = p.executeQuery();
			while(rs.next()){
				User u = new User();
				u.setAddress(rs.getString("address"));
				u.setAge(rs.getInt("age"));
				u.setUserName(rs.getString("name"));
				list.add(u);
				
			}
		} catch (SQLException e) {

			e.printStackTrace();
		}

		
		return list;
	}

	public String getSql(User user) {
		StringBuffer sb = new StringBuffer("select * from pages where 1=1");

		if (user.getAddress() != null && user.getAddress().length() > 0) {
			sb.append(" and address like '%").append(user.getAddress()).append(
					"%'");
		}
		if (user.getUserName() != null && user.getUserName().length() > 0) {
			sb.append(" and name like '%").append(user.getUserName()).append(
					"%'");
		}
		if (user.getAge() != 0) {
			sb.append(" and age=").append(user.getAge());
		}

		return sb.toString();
	}
}