7.10作业

1检索所有的职工姓名与年薪
public String toString() {
return “User{“ +
“, ename=’” + ename + ‘'‘
“, salary=” + salary +
‘}’+’\n’;
}
##
select * from user
##

2检索所有的工作和相应的部门编号

select job，deptno from emp where


3检索工作是salesman的员工姓名

select * from emp where job=’salesman’;


4检索员工津贴comm为null或comm小于300的员工姓名和津贴值

select * from emp where comm <300 or comm=300 or comm=null;


5检索所有职员的姓名和所在部门名

select ename,deptno from emp;


6检索在任何位置有字母“A”的员工姓名

select * from emp where ename like ‘%a%’;


7向表eemp中插入至少5条员工记录

insert into eemp(empno, ename,job,hiredate,salary,comm,deptno) values (1,’SMITH’,’manager’,’2019-2-1’,3300,300,2);

// 接收参数
Integer empno=1;
String ename=”liming”;
String job=”liming”;
String hiredate=”liming”;
double salary=100;
double comm=100;
double deptno=100;

// 生成对象
User user = new User(empno, ename,job,hiredate,salary,comm,deptno);
// 1.加载mybatis的核心配置文件，获取SqlSessionFactory对象
String resource = “mybatis-config.xml”;
InputStream inputStream = null;
try {
inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new
SqlSessionFactoryBuilder().build(inputStream);
// 2.获取SqlSession对象，执行sql语句
// 手动提交事务，使用sql.commit()方法
SqlSession sqlSession = sqlSessionFactory.openSession();
// 自动提交事务
// SqlSession sqlSession = sqlSessionFactory.openSession(true);
// 3.执行sql语句
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
// 插入操作
userMapper.add(user);
// 提交事务
sqlSession.commit();
// 4.释放资源
sqlSession.close();
} catch (IOException e) {
throw new RuntimeException(e);
}
}
}

8从eemp中删除名为“SMITH”的记录

delete from eemp where ename = ‘SMITH’;