xml -》 mapper -》 service -》 serviceimpl
xml 文件:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"
"http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
<mapper namespace="com.springboot.HUI.mapper.UserMapper">
<!--查询所有用户信息 -->
<select id="selectUserAlls"
resultType="com.springboot.HUI.entity.UserManagement">
select
*
from
user_test
</select>
<!--新增所有用户信息 -->
<insert id="inserUserManage" useGeneratedKeys="true"
keyProperty="id">
INSERT INTO user_test (name,sex,age)
VALUES
(#{name},
#{sex},#{age})
</insert>
<!-- 新增富文本插入信息 -->
<insert id="inserAnnouncement" useGeneratedKeys="true"
keyProperty="announcement_id">
INSERT INTO announcement_test (announcement_mag)
VALUES
(#{announcement_mag})
</insert>
<!--查询树-->
<select id="selectTree" resultType="com.springboot.HUI.entity.Trees">
SELECT
*
FROM
menu
</select>
</mapper>
mapper:
package com.springboot.HUI.mapper;
import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import com.springboot.HUI.entity.Announcement;
import com.springboot.HUI.entity.Trees;
import com.springboot.HUI.entity.UserManagement;
@Mapper
public interface UserMapper {
/*
* 查询所有用户信息
*/
List<UserManagement> selectUserAlls();
/*
* 新增用户信息数据
*/
Integer inserUserManage(UserManagement userManagements);
/*
* 新增公告信息
*/
Integer inserAnnouncement(Announcement announcement);
//查询树
List<Trees> selectTree();
}
service:
package com.springboot.HUI.dao;
import java.util.List;
import com.springboot.HUI.entity.Announcement;
import com.springboot.HUI.entity.Trees;
import com.springboot.HUI.entity.UserManagement;
/**
* @author 作者 Your-Name:
* @version 创建时间:2019年3月19日 下午3:14:08
* 类说明
*/
public interface userService {
/*
* 显示用户全部信息
*/
List<UserManagement> selectUserAll();
/*
* mybitis:显示用户全部信息
*/
List<UserManagement> selectUserAlls();
/*
* 新增用户信息数据
*/
Integer inserUserManage(UserManagement userManagements);
/*
* 新增公告信息
*/
Integer inserAnnouncement(Announcement announcement);
/*
* 查询树
*/
List<Trees> selectTree();
}
impl:
package com.springboot.HUI.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.springboot.HUI.entity.Announcement;
import com.springboot.HUI.entity.Trees;
import com.springboot.HUI.entity.UserManagement;
import com.springboot.HUI.mapper.UserMapper;
import com.springboot.HUI.util.DatabaseConnection;
/**
* @author cuishuai
* @version 创建时间:2019年3月19日 下午3:16:14
* 类说明
*/
@Service
public class userServiceImpl implements userService {
@Autowired
UserMapper usermapper;
/*
* mybitis:显示用户全部信息
*/
@Override
public List<UserManagement> selectUserAlls() {
List<UserManagement> selectUserAlls= new ArrayList<UserManagement>();
try {
selectUserAlls = usermapper.selectUserAlls();
} catch (Exception e) {
e.printStackTrace();
}
return selectUserAlls;
}
/*
* 新增用户信息数据
* @see com.springboot.HUI.dao.userService#inserUserManage()
*/
public Integer inserUserManage(UserManagement userManagements) {
int insert= usermapper.inserUserManage(userManagements);
return insert;
}
public static void main(String[] args) {
userServiceImpl userImpls = new userServiceImpl();
try {
List<UserManagement> arrayLists= new ArrayList<UserManagement>();
arrayLists = userImpls.selectUserAlls();
for (UserManagement userManagement : arrayLists) {
System.out.println(userManagement);
}
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 新增公告信息
*/
@Override
public Integer inserAnnouncement(Announcement announcement) {
Integer insert = usermapper.inserAnnouncement(announcement);
return insert;
}
/**
* 查询树
*/
@Override
public List<Trees> selectTree() {
List<Trees> trees = usermapper.selectTree();
return trees;
}
}