源码地址:https://download.csdn.net/download/m0_51152186/85687858
1.项目的需求(前后台功能需求,数据库的需求)
1.1 前后台功能
1.1.1 注册
用户通过安卓前端输入框输入注册账号信息(姓名、电话和密码),之后将用户信息存储到后台服务器中完成注册
1.1.2 登录
用户在安卓前端输入框输入电话号和密码,当与后台服务器中数据匹配时,提示登录成功,本地登录后,本地保存用户的登录信息。
1.1.3 同步数据
用户可以将后台服务器的数据下载到本地数据库,也可以将本地数据库上传后台服务器的数据库中,上传和下载有进度条显示
1.1.4 记账
用户可以及记录收入和支出两类数据,每一类都要记录:日期,主题,金额,时间及备注。用户可增删改查自己的记账信息。
1.1.5 统计
系统可以分类统计显示每月/每年/总计的收入和支出信息。
1.2 数据库的需求
本项目中一共建了两个数据库表分别为user表和record表
1.2.1 user表结构如图1.2.1
图1.2.1 user表结构图
1.2.2 record表结构如图1.2.2
图1.2.2 record表结构图
2.项目的设计
2.1项目流程图
图2.1 项目流程图
2.2服务端结构
服务端主要运用了Spring、SpringBoot和Mybatis框架进行搭建,具体包如图2.2
图2.2 服务端包结构图
2.3 Android端结构
Android端运用okhttp框架和LitePal框架进行搭建,具体包结构如图2.3
3.关键的代码
3.1服务端主要代码
3.1.1 数据库连接代码
#DB Configuration:
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/accountbook?serverTimezone=CTT&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true
spring.datasource.username=root
spring.datasource.password=123456
server.port=8080
server.servlet.context-path=/accountbook
3.1.2 Dao层主要代码
//添加一条记录
@Insert("insert into record(id,phoneNumber,category,content,money,status,date) " +
"values (#{record.uuid},#{phoneNumber},#{record.category},#{record.content},#{record.money},0,#{record.date})")
void addRecord(@Param("phoneNumber") String phoneNumber,@Param("record") Record record) throws Exception;
//根据手机号码查询该用户下所有的信息
@Select("SELECT * FROM record WHERe phoneNumber = #{phoneNumber}")
@Results({
@Result(property = "uuid",column = "id",id = true),
@Result(property = "category",column = "category"),
@Result(property = "content",column = "content"),
@Result(property = "money",column = "money"),
@Result(property = "status",column = "status"),
@Result(property = "date",column = "date")
})
List findAllByPhoneNumber(String phoneNumber) throws Exception;
//删除指定的记录
@Delete("DELETE FROM record WHERe id = #{recordId}")
void deleteRecord(@Param("recordId")String recordId) throws Exception;
//修改服务器中的记录
@Update("UPDATE record SET category=#{category},content=#{content},money=#{money},status=#{status},date=#{dateString} WHERe id = #{uuid}")
void upgradeRecord(Record record) throws Exception;
private void initWidget() {
//ViewPager
viewPager.addOnPageChangeListener(new ViewPager.OnPageChangeListener() {
@Override
public void onPageScrolled(int position, float positionOffset, int positionOffsetPixels) {
}
@Override
public void onPageSelected(int position) {
}
//当页面的滑动状态改变时该方法会被触发,页面的滑动状态有3个:“0”表示什么都不做,“1”表示开始滑动,“2”表示结束滑动
@Override
public void onPageScrollStateChanged(int state) {
if (state == 2) {
if (viewPager.getCurrentItem()==0) {
isIncome = false;
} else {
isIncome = true;
}
changeMoneyEditColor();
}
}
});
}
@RequiresApi(api = Build.VERSION_CODES.O)
private void initData() {
//初始化收入分类列表
List incomeList; //收入分类列表
incomeList = new ArrayList<>();
for (int i = 0; i< CategoriesUtils.incomeCategoryName.length ; i++) {
Category category = new Category();
category.setImageId(CategoriesUtils.incomeCategoryIcon[i]);
category.setName(CategoriesUtils.incomeCategoryName[i]);
incomeList.add(category);
}
//初始化支出分类列表
List expenditureList; //支出分类列表
expenditureList = new ArrayList<>();
for (int j = 0; j< CategoriesUtils.expenditureCategoryName.length ; j++) {
Category category = new Category();
category.setImageId(CategoriesUtils.expenditureCategoryIcon[j]);
category.setName(CategoriesUtils.expenditureCategoryName[j]);
expenditureList.add(category);
}
//初始化ViewPager每一页的View的集合
//支出页
pagerList = new ArrayList<>();
RecyclerView recyclerView1 = new RecyclerView(AddAndModifyRecordActivity.this);
StaggeredGridLayoutManager layoutManager1 = new
StaggeredGridLayoutManager(4, StaggeredGridLayoutManager.VERTICAL);
recyclerView1.setLayoutManager(layoutManager1);
recyclerView1.setAdapter(new CategoryAdapter(expenditureList));
pagerList.add(recyclerView1);
//收入页
RecyclerView recyclerView2 = new RecyclerView(AddAndModifyRecordActivity.this);
StaggeredGridLayoutManager layoutManager2 = new
StaggeredGridLayoutManager(3, StaggeredGridLayoutManager.VERTICAL);
recyclerView2.setLayoutManager(layoutManager2);
recyclerView2.setAdapter(new CategoryAdapter(incomeList));
pagerList.add(recyclerView2);
//设置适配器
viewPager.setAdapter(new ViewPagerAdapter());
//设置当前的日期
LocalDateTime nowDate = LocalDateTime.now();
dateString = nowDate.format(DateTimeFormatter.ofPattern("yyyy-MM-dd"));
year = nowDate.getYear();
month = nowDate.getMonthValue();
day = nowDate.getDayOfMonth();
dateText.setText(dateString);
//如果是修改数据,则将数据填充到页面上
if (toModify) {
categoryName.setText(toModifyRecord.getCategory());
contentEdit.setText(toModifyRecord.getContent());
moneyEdit.setText(String.valueOf(Math.abs(toModifyRecord.getMoney())));
dateString = toModifyRecord.getDateString();
dateText.setText(dateString);
}
}
@Event(value = {R.id.expenditure,R.id.income,R.id.add_record_date,R.id.save_record,R.id.back_to_main_})
private void myClick(View v) throws ParseException {
switch (v.getId()) {
case R.id.expenditure:
viewPager.setCurrentItem(0);
isIncome = false;
changeMoneyEditColor();
break;
case R.id.income:
viewPager.setCurrentItem(1);
isIncome = true;
changeMoneyEditColor();
break;
case R.id.add_record_date:
DatePickerDialog datePickerDialog = new DatePickerDialog(AddAndModifyRecordActivity.this,
new DatePickerDialog.OnDateSetListener() {
@Override
public void onDateSet(DatePicker view, int mYear, int mMonth, int dayOfMonth) {
year = mYear;
month = mMonth+1;
day = dayOfMonth;
dateString = year+"-" + (month<10 ? ("0"+month+"-") : (month+"-")) + (day<10 ? ("0"+day) : (day));
dateText.setText(dateString);
}
},
year, month-1, day);
datePickerDialog.show();
break;
case R.id.save_record:
Date date = new Date(year-1900,month-1,day);
boolean saveSuccess;
String categoryNameStr = categoryName.getText().toString();
String contentStr = contentEdit.getText().toString();
if (toModify) {
Log.d(TAG, toModifyRecord.toString());
toModifyRecord.setCategory(categoryName.getText().toString());
toModifyRecord.setContent(contentEdit.getText().toString());
double money = Double.parseDouble(moneyEdit.getText().toString());
toModifyRecord.setMoney(isIncome?(money):(money*-1));
toModifyRecord.setStatus(((toModifyRecord.getStatus()==0)?(3):(1)));
toModifyRecord.setDate(date);
toModifyRecord.setDateString(dateString);
saveSuccess = toModifyRecord.save();
Log.d(TAG, toModifyRecord.toString());
} else {
Record record = new Record();
record.setCategory((!TextUtils.isEmpty(categoryNameStr)?(categoryNameStr):("无")));
record.setContent((!TextUtils.isEmpty(contentStr)?(contentStr):("无")));
double money = Double.parseDouble(moneyEdit.getText().toString());
record.setMoney(isIncome?(money):(money*-1));
record.setStatus(1); //1代表未同步到服务器
record.setDate(date);
record.setUuid(UuidUtil.getUuid());
record.setDateString(dateString);
saveSuccess = record.save();
}
if (saveSuccess) {
ToastUtil.Pop("保存成功");
finish();
} else {
ToastUtil.Pop("保存失败");
}
break;
case R.id.back_to_main_:
finish();
break;
default:
}
}
@Override
public boolean onOptionsItemSelected(@NonNull MenuItem item) {
switch (item.getItemId()) {
case android.R.id.home: //Toolbar上的返回按钮,finish当前Activity
finish();
break;
default:
}
return true;
}
private void changeMoneyEditColor() {
moneyEdit.setText("");
categoryName.setText("");
if (isIncome) {
moneyEdit.setTextColor(Color.GREEN);
} else {
moneyEdit.setTextColor(Color.RED);
}
}
private class CategoryAdapter extends RecyclerView.Adapter {
private List categories;
class ViewHolder extends RecyclerView.ViewHolder {
View categoryView;
ImageView categoryImage;
TextView categoryName;
public ViewHolder(View view) {
super(view);
categoryView = view;
categoryImage = view.findViewById(R.id.add_record_icon);
categoryName = view.findViewById(R.id.add_record_name);
}
}
public CategoryAdapter(List categories) {
this.categories = categories;
}
@Override
public ViewHolder onCreateViewHolder(ViewGroup parent, int viewType) {
View view = LayoutInflater.from(parent.getContext())
.inflate(R.layout.add_record_category_item, parent, false);
final ViewHolder holder = new ViewHolder(view);
holder.categoryView.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
categoryName.setText(holder.categoryName.getText());
}
});
return holder;
}
@Override
public void onBindViewHolder(ViewHolder holder, int position) {
Category category = categories.get(position);
holder.categoryImage.setImageResource(category.getImageId());
holder.categoryName.setText(category.getName());
}
@Override
public int getItemCount() {
return categories.size();
}
}
private class ViewPagerAdapter extends PagerAdapter {
@Override
public int getCount() {
return pagerList.size();
}
@Override
public boolean isViewFromObject(@NonNull View view, @NonNull Object object) {
return view == object;
}
@NonNull
@Override
public Object instantiateItem(@NonNull ViewGroup container, int position) {
RecyclerView recyclerView = pagerList.get(position);
container.addView(recyclerView);
return recyclerView;
}
@Override
public void destroyItem(@NonNull ViewGroup container, int position, @NonNull Object object) {
container.removeView((View)object);
}
}
}
//同步数据
private void syncData() {
String ip = preferences.getString("ip","");
if (isUpload) { //上传
final List toUpgradeRecords = LitePal.where("status > ?", "0").find(Record.class);
HttpUtil.uploadRecords(ip+Constant.UPLOAD_RECORDS, phoneNumber, toUpgradeRecords, new Callback() {
@Override
public void onFailure(Call call, IOException e) {
showToast("服务器异常");
finish();
}
@Override
public void onResponse(Call call, Response response) throws IOException {
String responseBody = response.body().string();
ResultInfo resultInfo = JSONObject.parseObject(responseBody, ResultInfo.class);
if (resultInfo.isFlag()) {
for (Record record : toUpgradeRecords) {
if (record.getStatus() != 2) {
record.setStatus(0);
record.save();
} else {
record.delete();
}
}
showToast("同步成功");
finish();
} else {
showToast("同步失败");
finish();}}});
} else {//下载
String address = ip+Constant.DOWNLOAD_RECORDS + phoneNumber;
HttpUtil.sendOkHttpGetRequest(address, new Callback() {
@Override
public void onFailure(Call call, IOException e) {
showToast("服务器异常");
finish();
}
@Override
public void onResponse(Call call, Response response) throws IOException {
String responseBody = response.body().string();
ResultInfo resultInfo = JSONObject.parseObject(responseBody, ResultInfo.class);
Log.d(TAG, "onResponse: "+resultInfo.getData().toString());
List recordsDownloadFormServer = JSONArray.parseArray(resultInfo.getData().toString(),Record.class);
if (resultInfo.isFlag()) {
for (Record record : recordsDownloadFormServer) {
try {
LitePal.where("uuid = ? ", record.getUuid()).find(Record.class).get(0);
} catch (Exception e) {
e.printStackTrace(); record.setDateString(ConvertUtils.dateToString(record.getDate()));
record.save();
}
}
showToast("下载成功");
}
finish();
}});}}
4.测试用例
4.1测试连接服务器
输入ip
输入数据:18.114.0.80
操作过程:点击保存
预测结果:保存成功
实际结果:保存成功
4.2测试注册
输入数据:13926996293、yyc、123456、123456
操作过程:输入数据|点击注册
预测结果:注册成功并将数据存入后台服务器数据库
实际结果:注册成功并将数据存入后台服务器数据库
图4.2 测试注册
4.3 测试登录
输入数据:13926996293、123456
操作过程:输入数据
预测结果:登录成功
实际结果:登录成功
图4.3 测试登录
4.4测试下载到本地
作过程:选择同步、选择上下载到
预测结果:下载成功
实际结果:下载成功
图4.4 测试下载到本地
4.5测试添加
输入数据:book、55
操作过程:点击加号、点击学习、选择日期、输入数据、点击确定
预测结果:保存成功
实际结果:保存成功
图4.5测试添加
4.6 测试修改
输入数据:120
操作过程:长按一个账单、点击修改、点击确定
预测结果:保存成功
实际结果:保存成功
图 4.6 测试修改
4.7 测试删除
操作过程:长按一个账单、点击删除、点击确定
预测结果:删除成功
实际结果:删除成功
图4.7 测试删除
4.8测试上传服务器
操作过程:选择同步、选择上传服务器
预测结果:同步成功并存入后台服务器数据库
实际结果:同步成功并存入后台服务器数据库
图4.8测试上传服务器
4.9 查看统计数据
操作过程:点击统计数据
预测结果:显示统计数据
实际结果:显示统计数据
图4.9 查看统计数据
5.项目及课程总结
通过本次实验我再次学习了spring、springboot及mybatis的使用。并通过老师的讲解与学习,成功的与android成功的通过okhttp链接和LitePal,完成了同步信息,修改表,删除表,添加表等功能。进一步了解了安卓开发。