栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

移动终端软件高级开发技术------- 记账本

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

移动终端软件高级开发技术------- 记账本

源码地址: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,完成了同步信息,修改表,删除表,添加表等功能。进一步了解了安卓开发。

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/981474.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号