Flex 使用 Cairngorm 框架与java进行数据交互

package com.bean.dao.impl; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; import com.bean.Employee; import com.bean.dao.EmployeeDAO; import com.util.DBUtil; public class EmployeeDAOImpl implements EmployeeDAO { public boolean saveEmployee(Employee employee) { Connection conn = null; PreparedStatement psmt = null; String sql = "insert into employee(username,password,gender) value (?,?,?)"; try { conn = DBUtil.getConnection(); psmt = conn.prepareStatement(sql); psmt.setString(1, employee.getUsername()); psmt.setString(2, employee.getPassword()); psmt.setString(3, employee.getGender()); System.out.println(psmt.execute()); return true; } catch (Exception e) { e.printStackTrace(); } finally { DBUtil.close(psmt); DBUtil.close(conn); } return false; } public List<Employee> getEmployees() { Connection conn = null; PreparedStatement psmt = null; ResultSet rs = null; String sql = "select * from employee"; List<Employee> list = new ArrayList<Employee>(); try { conn = DBUtil.getConnection(); psmt = conn.prepareStatement(sql); rs = psmt.executeQuery(); Employee employee = null; while(rs.next()){ employee = new Employee(); employee.setUsername(rs.getString("username")); employee.setPassword(rs.getString("password")); employee.setGender(rs.getString("gender")); list.add(employee); } } catch (Exception e) { e.printStackTrace(); } finally { DBUtil.close(rs); DBUtil.close(psmt); DBUtil.close(conn); } return list; } }