MyBatis动态SQL（一）

最新推荐文章于 2023-04-05 22:54:58 发布

「已注销」

最新推荐文章于 2023-04-05 22:54:58 发布

阅读量82

点赞数

本文链接：https://blog.csdn.net/m0_51945027/article/details/114079772

版权

@SuppressWarnings("all")
public class EmpDao {
   


    //设计两个方法 分别查询所有的deptno  和  所有的job
    public List<Integer> selectAllDeptno(){
   
        List<Integer> deptnoList = new ArrayList();
        try {
   
            //原生JDBC
            String driver = "com.mysql.jdbc.Driver";
            String url = "jdbc:mysql://localhost:3306/testmybatis?useSSL=false";
            String username = "root";
            String password = "123456";
            String sql = "select distinct deptno from emp order by deptno";
            Class.forName(driver);
            Connection conn = DriverManager.getConnection(url,username,password);
            PreparedStatement pstat = conn.prepareStatement(sql);
            ResultSet rs = pstat.executeQuery();
            while(rs.next()){
   
                deptnoList.add(rs.getInt("deptno"));
            }
            rs.close();
            pstat.close();
            conn.close();
        } catch (Exception e) {
   
            e.printStackTrace();
        }
        return deptnoList;
    }

    public List<String> selectAllJob(){
   
        List<String> jobList = new ArrayList();
        try {