发表于: 2020-05-18 20:45:07
2 1409
今天完成的事情:
Spring 整合mybatis还买了个服务器,但是还不会部署,
1.配置 Spring-Mybatis 整合依赖,把mybatis操作的SqlSessionFactory和持久化操作的DAO层的对象交给Spring
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.2</version>
<scope>compile</scope>
</dependency>
<!--Spring 整合 Mybatis-->
<!--数据源-->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="${driver}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
</bean>
<!--session工厂-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
</bean>
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="classpath:mapper/*.xml"/>
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
</bean>
</beans>
<mapper namespace="com.hyx.dao.StudentMapper">
<select id="findAll" resultType="com.hyx.entity.Student">
select * from student
</select>
<select id="findOne" resultType="com.hyx.entity.Student" parameterType="long">
select * from student where id = #{id}
</select>
<insert id="insert" parameterType="com.hyx.entity.Student" useGeneratedKeys="true" keyProperty="id">
insert into student (number,name,qq,job,university,link,target,brother)
values(#{number},#{name},#{qq},#{job},#{university},#{link},#{target},#{brother})
</insert>
<update id="updateById" parameterType="long">
update student set student = #{student} where id=#{id}
</update>
<delete id="delateById" parameterType="long">
delete from student where id=#{id}
</delete>
</mapper>
@Repository
public interface StudentMapper {
List<Student> findAll();
List<Student> findOne(long id);
long insert(Student student);
boolean updateById(Student student,long id);
boolean deleteById(long id);
}
public interface StudentService {
public List<Student> findAll();
public List<Student> findOne(long id);
public long insert(Student student);
public boolean updateById(Student student,long id);
public boolean deleteById(long id);
}
@Service("studentService")
public class StudentServiceImpl implements StudentService {
@Resource
private StudentMapper studentMapper;
public List<Student> findAll() {
return studentMapper.findAll();
}
public List<Student> findOne(long id) {
return studentMapper.findOne(id);
}
public long insert(Student student) {
return studentMapper.insert(student);
}
public boolean updateById(Student student, long id) {
return studentMapper.updateById(student,id);
}
public boolean deleteById(long id) {
return studentMapper.deleteById(id);
}
}
明天计划的事情: 明天把问题解决了,把代码上传到git以及在服务器跑一跑
遇到的问题:今天遇到两个BUG,一个BUG一上午,一个BUG一下午,真的心累。师兄今天也没来,哈哈。
收获:今天被BUG折磨的体无完肤。
评论