思途实训-day01
上午
- 开班动员大会,没啥好说的
- 分班,分到杜老师的班级,讲解了JAVA未来的方向及一些编译器和环境的配置和安装思途工具提取码:7x5f
下午
老师讲解使用JAVA spring来操作数据库,以下为代码(尚未完成)
- DepartmentMapper.java
package com.situ.company.department.mapper; import java.util.List; import org.apache.ibatis.annotations.Mapper;//主函数 import org.apache.ibatis.annotations.Select;//mysql的选择函数 import org.apache.ibatis.annotations.Update;//mysql的更新函数 import org.apache.ibatis.annotations.Insert;//mysql的添加函数 import org.apache.ibatis.annotations.Delete;//mysql的删除函数 import com.situ.company.department.model.DepartmentModel; @Mapper public interface DepartmentMapper { //department 公司 //数据的添加 @Insert("insert into department(code, name, tel) values(#{code}, #{name}, #{tel})") int insert(DepartmentModel model); //数据的删除 @Delete("delete from department where code = #{code}") int Delete(DepartmentModel model); //数据的更新 @Update("updata department set name = #{name}, tel = #{tel} where code = #{code}") int updata(DepartmentModel model); //根据编号获取数据 @Select("select code, name, tel, (SELECT count(1) FROM st_company.employee where dept_code = department.code count FROM department where code=#{code})") DepartmentModel selectModel(DepartmentModel model); }
- DepartmentModel
package com.situ.company.department.model;//全包名 public class DepartmentModel { private Integer id; private String code; private String name; private String tel; public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getCode() { return code; } public void setCode(String code) { this.code = code; } public String getTel() { return tel; } public void setTel(String tel) { this.tel = tel; } public String getName() { return name; } public void setName(String name) { this.name = name; } }
晚上
巩固mysql的语法并写出其他三张表的Mapper和Model