dao类
/**
* 开发一个JDBC小程序
* 将Motel168客房管理系统员工表(Employee)中的
* 员工姓名(empName)逐个显示在一个JComboBox中
*/
package com.Test.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.Test.Util.DBUtil;
import com.Test.dto.UsernameDTO;
public class UsernameDAO {
public List<UsernameDTO> findAllUsers() {
Connection conn = null;
PreparedStatement statement = null;
ResultSet rs = null;
try {
conn = DBUtil.getConnection();
String sql = "select * from Employee";
statement = conn.prepareStatement(sql);
rs = statement.executeQuery();
List<UsernameDTO> users = new