Skip to content

Commit bc7250b

Browse files
AndroidAndYangAndroidAndYang
committed
完成对用户某个月的全部所有详细数据
1 parent 3c8d371 commit bc7250b

File tree

22 files changed

+213
-155
lines changed

22 files changed

+213
-155
lines changed

‎.idea/workspace.xml‎

Lines changed: 120 additions & 111 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎src/main/java/com/yjz/notepad/dao/IBookkeepingDao.java‎

Lines changed: 15 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -21,13 +21,23 @@ public interface IBookkeepingDao {
2121
Long addBookkeepingDate(BookkeepingBean bookkeepingBean);
2222

2323
/**
24-
* 查询用户某个月数据
24+
* 查询用户某个月记账的天的日期
2525
*
26-
* @param userID 用戶id
27-
* @param addTime 添加事件
26+
* @param userID 用戶id
27+
* @param addTime 添加某个月
2828
* @param bookType 记账本类型
29-
* @return 某个月的记账数据
29+
* @return 用户某个月记账的天的日期
3030
*/
31-
List<UserBookkeepingBean> queryUserByBookkeepingType(Long userID, Long bookType, String addTime);
31+
List<String> queryBookkeepingDateByMonth(Long userID, Long bookType, String addTime);
32+
33+
/**
34+
* 查询用户某个月所有的记账记录
35+
*
36+
* @param userID 用戶id
37+
* @param exactTime 添加的某一天
38+
* @param bookType 记账本类型
39+
* @return 用户某个月所有的记账记录
40+
*/
41+
List<UserBookkeepingBean> queryAllBookkeeping(Long userID, Long bookType, String exactTime);
3242

3343
}

‎src/main/java/com/yjz/notepad/service/IBookkeepingService.java‎

Lines changed: 11 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -29,6 +29,16 @@ public interface IBookkeepingService {
2929
* @param bookType 记账本类型
3030
* @return 某个月的记账数据
3131
*/
32-
List<UserBookkeepingBean> queryUserByBookkeepingType(Long userID, Long bookType, String addTime);
32+
List<String> queryBookkeepingDateByMonth(Long userID, Long bookType, String addTime);
33+
34+
/**
35+
* 查询用户某个月所有的记账记录
36+
*
37+
* @param userID 用戶id
38+
* @param exactTime 添加的某一天
39+
* @param bookType 记账本类型
40+
* @return 用户某个月所有的记账记录
41+
*/
42+
List<UserBookkeepingBean> queryAllBookkeeping(Long userID, Long bookType, String exactTime);
3343

3444
}

‎src/main/java/com/yjz/notepad/service/impl/BookkeepingServiceImpl.java‎

Lines changed: 7 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -26,7 +26,12 @@ public Long addBookkeepingDate(BookkeepingBean bookkeepingBean) {
2626
}
2727

2828
@Override
29-
public List<UserBookkeepingBean> queryUserByBookkeepingType(Long userID, Long bookType, String addTime) {
30-
return bookkeepingDao.queryUserByBookkeepingType(userID, bookType, addTime);
29+
public List<String> queryBookkeepingDateByMonth(Long userID, Long bookType, String addTime) {
30+
return bookkeepingDao.queryBookkeepingDateByMonth(userID, bookType, addTime);
31+
}
32+
33+
@Override
34+
public List<UserBookkeepingBean> queryAllBookkeeping(Long userID, Long bookType, String exactTime) {
35+
return bookkeepingDao.queryAllBookkeeping(userID, bookType, exactTime);
3136
}
3237
}

‎src/main/java/com/yjz/notepad/test/BookkeepingTest.java‎

Lines changed: 15 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -9,6 +9,7 @@
99
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
1010

1111
import javax.annotation.Resource;
12+
import java.util.ArrayList;
1213
import java.util.Date;
1314
import java.util.List;
1415

@@ -43,13 +44,23 @@ public void testAddBookkeepingData() {
4344
}
4445

4546
/**
46-
* 查詢记账数据
47+
* 查詢用户一个月的记账记录
4748
*/
4849
@Test
4950
public void testQueryUserByBookkeepingType() {
50-
List<UserBookkeepingBean> userBookkeepingBeans = service.queryUserByBookkeepingType(19L, 1L, "2018-11");
51-
for (UserBookkeepingBean userBookkeepingBean : userBookkeepingBeans) {
52-
System.out.println(userBookkeepingBean.toString());
51+
List<String> dataList = new ArrayList<>();
52+
List<String> userBookkeepingBeans = service.queryBookkeepingDateByMonth(2L, 1L, "2018-11");
53+
for (String exactDate : userBookkeepingBeans) {
54+
if (!dataList.contains(exactDate)) {
55+
dataList.add(exactDate);
56+
}
57+
}
58+
for (String exactTime : dataList) {
59+
List<UserBookkeepingBean> userBookkeepingBeans1 = service.queryAllBookkeeping(2L, 1L, exactTime);
60+
for (UserBookkeepingBean userBookkeepingBean : userBookkeepingBeans1) {
61+
System.out.println(userBookkeepingBean.toString());
62+
}
63+
System.out.println("-------------------------------");
5364
}
5465
}
5566
}

‎src/main/resource/mapper/BookkeepingDao.xml‎

Lines changed: 8 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -15,14 +15,19 @@
1515
#{exactAddTime});
1616
</insert>
1717

18-
<!-- 查询记账数据 -->
19-
<select id="queryUserByBookkeepingType" resultType="UserBookkeepingBean">
18+
<!-- 查询用戶一个月中记账了日期 -->
19+
<select id="queryBookkeepingDateByMonth" resultType="java.lang.String">
20+
SELECT exact_time FROM bookkeeping WHERE user_id=#{0} AND type_id =#{1} AND add_time=#{2} order by exact_time;
21+
</select>
22+
23+
<!-- 查询用户一个月中所有的记账记录 -->
24+
<select id="queryAllBookkeeping" resultType="UserBookkeepingBean">
2025
SELECT b.user_id,b.content,b.money,b.money_type,c.des,t.name,b.exact_time
2126
FROM bookkeeping b
2227
LEFT JOIN user u on u.id = b.user_id
2328
LEFT JOIN classification c on c.id = b.classification_id
2429
LEFT JOIN bookkeeping_type t on t.id = b.type_id
25-
WHERE b.user_id=#{0} AND b.type_id=#{1} AND b.add_time = #{2} ;
30+
WHERE b.user_id=#{0} AND b.type_id=#{1} AND b.exact_time = #{2} ;
2631
</select>
2732

2833
</mapper>

‎target/classes/com/yjz/notepad/dao/IBookkeepingDao.class‎

130 Bytes
Binary file not shown.

‎target/classes/com/yjz/notepad/service/IBookkeepingService.class‎

130 Bytes
Binary file not shown.

‎target/classes/com/yjz/notepad/service/impl/BookkeepingServiceImpl.class‎

243 Bytes
Binary file not shown.

‎target/classes/com/yjz/notepad/test/BookkeepingTest.class‎

554 Bytes
Binary file not shown.

0 commit comments

Comments
 (0)