JavaBean的实现

JavaBean

领域对象层

;/*
 * 作用：领域对象层
 *
 *@author hby_gd@163.com
 *@date 25/7/2020 下午11:20
 */

public class Employee {
    private String username;
    private int age;
    private int salary;

    public Employee() {
    }

    public Employee(String username, int age, int salary) {
        this.username = username;
        this.age = age;
        this.salary = salary;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public int getSalary() {
        return salary;
    }

    public void setSalary(int salary) {
        this.salary = salary;
    }

    @Override
    public String toString() {
        return "Employee{" +
                "username='" + username + '\'' +
                ", age=" + age +
                ", salary=" + salary +
                '}';
    }
}

数据链路层

/*
 * 作用：数据链路层
 *
 *@author hby_gd@163.com
 *@date 25/7/2020 下午11:25
 */

import com.openlab.pojo.Employee;
import com.openlab.utils.JDBCUtius;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class EmployeeDao extends JDBCUtius {
    @Override
    public Object toObj(ResultSet resultSet) {
        Object obj = null;
        Employee emp = new Employee();

        try {

            if(resultSet.next()){
                emp.setAge(resultSet.getInt("age"));
                emp.setSalary(resultSet.getInt("salary"));
                emp.setUsername(resultSet.getString("username"));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        obj = (Object)emp;
        return obj;
    }

    @Override
    public List toList(ResultSet resultSet) {
        List<Employee> list = null;

        try {
            Employee emp = new Employee();
            list = new ArrayList();
            while(resultSet.next()){
                emp.setAge(resultSet.getInt("age"));
                emp.setSalary(resultSet.getInt("salary"));
                emp.setUsername(resultSet.getString("username"));
                list.add(emp);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }

        return list;
    }
}

业务逻辑层

package com.openlab.service;/*
 * 作用：业务逻辑层
 *
 *@author hby_gd@163.com
 *@date 25/7/2020 下午11:22
 */

import com.openlab.pojo.Employee;

import java.util.List;

public interface EmployeeService {

    Employee queryByUsername(String username);
    List<Employee> queryByAge(int age);

}

业务实现层

package com.openlab.serviceImpl;/*
 * 作用：
 *
 *@author hby_gd@163.com
 *@date 25/7/2020 下午11:32
 */

import com.openlab.dao.EmployeeDao;
import com.openlab.pojo.Employee;
import com.openlab.service.EmployeeService;

import java.util.ArrayList;
import java.util.List;

public class EmpolteeServiceImpl implements EmployeeService {
    EmployeeDao eDao = new EmployeeDao();
    @Override
    public Employee queryByUsername(String username) {
        Employee e = null;
        Object obj = eDao.queryOne("select * from tb1 where username = '" + username + "'");
        e = (Employee) obj;
        return e;
    }

    @Override
    public List queryByAge(int age) {
        List list = new ArrayList();
        list = eDao.queryAll("select * from tb1 where age = '" + age + "'");
        return list;
    }
}