**
最近学习了mybatis(IDEA+maven),做了个小实验,记录一下,希望可以帮助到和我一样的小白,嘻嘻
**
一、实验要求:
二、数据库设计:
1.四个table
2.①Table----dept
②Table----emp
③Table----postsalary(用于做3.5建的表)
④Table----salarygrade
**
三、代码部分:
**
1.代码目录:
2.代码
pom.xml最先要配置好哦!(maven很方便,jar包真的每次搞得头大)
注意:我的MySQLWorkbench,所以在pom.xml里面如下,因人而异哦,否则会报错
<!--添加mysql的jdbc驱动 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.11</version>
</dependency>
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.zmj</groupId>
<artifactId>DZLseven</artifactId>
<version>1.0-SNAPSHOT</version>
<dependencies>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.5</version>
</dependency>
<!--添加mysql的jdbc驱动 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.11</version>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.12</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.10</version>
</dependency>
</dependencies>
</project>
(1)dao
①:DeptDao.java
package dao;
import vo.Dept;
import java.util.List;
public interface DeptDao {
Integer countEmpl(Dept dept);
List<Dept> findAll();
Dept findDeptById(Dept dept);
List<Dept> findByCondition(Dept dept);
List<Dept> findByIds(List ids);
}
②:DeptTreeDao.java
package dao;
import vo.Dept;
import vo.DeptTree;
import java.util.List;
public interface DeptTreeDao {
List<DeptTree> getDeptTree(Dept dept);
}
③:EmpDao.java
package dao;
import vo.Dept;
import vo.Emp;
import vo.Integ;
import vo.SalaryAndEmp;
import java.util.List;
public interface EmpDao {
List<Dept> getFemalIszZero(Integ integ);
List<SalaryAndEmp> getEmpSalgrade();
List<Emp> getSalaryHigherOverTenPercent();
}
④:SalGrade.java(这个写了,没用哈,不过大家如果丰富代码,可以用的哈~)
package dao;
public interface SalGrade {
}
(2)vo
①:Dept.java
package vo;
public class Dept {
private Integer deptid;
private String deptname;
private Integer parentid;
private Integer companyid;
private Integer rootid;
public Integer getDeptid() {
return deptid;
}
public void setDeptid(Integer deptid) {
this.deptid = deptid;
}
public String getDeptname() {
return deptname;
}
public Integer getRootid() {
return rootid;
}
public void setRootid(Integer rootid) {
this.rootid = rootid;
}
public void setDeptname(String deptname) {
this.deptname = deptname;
}
public Integer getParentid() {
return parentid;
}