2月2日总结

今日代码：打完了日常生活评估的dao方法

    public void AddUser_Daily(int eating,int bathing,int grooming,int dressing,int bowelControl,int bladderControl,int toileting,int transfers,int walking,int stairs,String SpiritResult,String Username)
    {
        Connection connection =util.getConnection();
        PreparedStatement preparedStatement=null;

        try {
            String sql = "update 用户基本信息表 set 进食=?,洗澡=?,修饰=?,穿衣=?大便控制=?,小便控制=?,如厕=?,床椅转移=?,行走=?,上下楼梯=? where 用户名=?";
            preparedStatement=connection.prepareStatement(sql);
            preparedStatement.setInt(1, eating);
            preparedStatement.setInt(2, bathing);
            preparedStatement.setInt(3, grooming);
            preparedStatement.setInt(4, dressing);
            preparedStatement.setInt(5, bowelControl);
            preparedStatement.setInt(6, bladderControl);
            preparedStatement.setInt(7, toileting);
            preparedStatement.setInt(8, transfers);
            preparedStatement.setInt(9, walking);
            preparedStatement.setInt(10, stairs);
            preparedStatement.setString(11, SpiritResult);
            preparedStatement.setString(5, Username);
            preparedStatement.executeUpdate();

        } catch (SQLException  e) {
            e.printStackTrace();
        }finally{
            util.close(preparedStatement);
            util.close(connection);
        }
    }

在b站上浅浅学了一点点怎么编写手机app的教程