public class UserDaoImpl implements UserDao {
    @Override
    public int insert(User user)// ? throws Exception
     {
        String sql = "insert into user(id,userNo,userName,pwd) values(?,?,?,?)";
        Object[] param = new Object[]{user.getId(),user.getUserNo(),user.getUserName(),user.getPwd()};
        QueryRunner queryRunner = new QueryRunner(JdbcUtil.getDataSource());

        int result = 0;


        try {
            result=queryRunner.update(sql,param);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }

        return result;
    }

    @Override
    public int delete(int id) {
        String sql = "delete from user where id=?";
Object[] param = new Object[]{id};
QueryRunner queryRunner = new QueryRunner(JdbcUtil.getDataSource());

        int result = 0;
        try {
          result = queryRunner.update(sql,param);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        } catch (Exception e) {
            throw new RuntimeException(e);
        }
        return result;
    }

    @Override
    public int update(User user) {
        String sql = "update user set userNo=?,userName=? where id=?";
Object[] param = new Object[]{user.getUserNo(),user.getUserName(),user.getId()};
QueryRunner queryRunner = new QueryRunner(JdbcUtil.getDataSource());
        int result = 0;
        try {
       result = queryRunner.update(sql,param);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        } catch (Exception e) {
            throw new RuntimeException(e);
        }
        return result;

    }

    @Override
    public List<User> selectAll() {
        String sql = "select * from user";

QueryRunner queryRunner = new QueryRunner(JdbcUtil.getDataSource());
        List<User> list = new ArrayList<User>();
        try {
         list=queryRunner.query(sql,new BeanListHandler<User>(User.class));
            } catch (SQLException ex) {
            throw new RuntimeException(ex);
        }

        return list;

    }

    @Override
    public List<User> selectByName(String name) {
        String sql = "select * from user where userName=?";
        Object[] param = new Object[]{name};
        QueryRunner queryRunner = new QueryRunner(JdbcUtil.getDataSource());
        List<User> list = new ArrayList<User>();

        ResultSet result;
        try {
          list=queryRunner.query(sql,param,new BeanListHandler<User>(User.class));
        } catch (SQLException e) {
            throw new RuntimeException(e);
        } catch (Exception e) {
            throw new RuntimeException(e);
        }

        return list;
    }

    @Override
    public User selectById(int id) {


        String sql = "select * from user where id=?";
        Object[] param = new Object[]{id};
        User user = new User();
QueryRunner queryRunner = new QueryRunner(JdbcUtil.getDataSource());

        try {
        user = queryRunner.query(sql,param,new BeanHandler<User>(User.class));
        } catch (SQLException e) {
            throw new RuntimeException(e);
        } catch (Exception e) {
            throw new RuntimeException(e);
        }

        return user;
    }
}