frienddao.java

10 博客网（Servlet2.4+JavaBean+SQLServer2000实现）

package com.wy.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.*;

import com.wy.form.FriendForm;
import com.wy.tool.JDBConnection;

public class FriendDao {
	private JDBConnection connection = null;

	public FriendDao() {
		connection = new JDBConnection();
	}

	// 修改朋友
	public boolean updateFriend(FriendForm form) {
		boolean flag = false;
		String sql = "update tb_friend set name='" + form.getName()
				+ "',QQNumber='" + form.getQQNumber() + "',description='"
				+ form.getDescription() + "' where id='" + form.getId() + "'";
		if (connection.executeUpdate(sql)) {
			flag = true;
		}
		return flag;
	}

	// 添加朋友
	public boolean addFriend(FriendForm form) {
		boolean flag = false;
		String sql = "insert into tb_friend values ('" + form.getName() + "','"
				+ form.getQQNumber() + "','" + form.getDescription() + "')";
		if (connection.executeUpdate(sql)) {
			flag = true;
		}
		return flag;
	}

	// 删除朋友
	public boolean deleteFriend(Integer id) {
		boolean flag = false;
		String sql = "delete from tb_friend where id='" + id + "'";
		if (connection.executeUpdate(sql)) {
			flag = true;
		}
		return flag;
	}

	// 查询所有朋友
	public List queryFriend() {
		List list = new ArrayList();
		FriendForm form = null;
		String sql = "select * from tb_friend";
		ResultSet rs = connection.executeQuery(sql);
		try {
			while (rs.next()) {
				form = new FriendForm();
				form.setId(Integer.valueOf(rs.getString(1)));
				form.setName(rs.getString(2));
				form.setQQNumber(rs.getString(3));
				form.setDescription(rs.getString(4));
				list.add(form);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}

		return list;
	}

	// 单独朋友信息查询
	public FriendForm queryFriendForm(String id) {
		FriendForm form = null;
		String sql = "select * from tb_friend where id='" + id + "'";
		ResultSet rs = connection.executeQuery(sql);
		try {
			while (rs.next()) {
				form = new FriendForm();
				form.setId(Integer.valueOf(rs.getString(1)));
				form.setName(rs.getString(2));
				form.setQQNumber(rs.getString(3));
				form.setDescription(rs.getString(4));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return form;
	}
	

	

}