filluserinfo.java

ajax 中流行框架dwr 本人写的官方的例子。。。不容错过对Ajax的同学。

package com.kongnan.text;

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

import com.kongnan.benn.ConnDB;
import com.kongnan.benn.Employee;

public class FillUserInfo {
	public Collection getInfo(String se) {
		Collection list = new Vector();
		String sql = "";
		if (!se.equals("")) {
			sql = "select * from employee where minit=?";
		} else {
			sql = "select * from employee";
		}
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			ps = ConnDB.getConn().prepareStatement(sql);
			if (!se.equals("")) {
				ps.setString(1, se);
			}
			rs = ps.executeQuery();
			Employee emp = null;
			while (rs.next()) {
				emp = new Employee();
				emp.setEmp_id(rs.getString("emp_id"));
				emp.setFname(rs.getString("fname"));
				emp.setHire_date(rs.getString("hire_date"));
				emp.setJob_id(rs.getString("job_id"));
				emp.setLname(rs.getString("lname"));
				emp.setMinit(rs.getString("minit"));
				emp.setPub_id(rs.getString("pub_id"));
				list.add(emp);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return list;
	}
}