android利用手机传感器实现计步，并把步数数据存放到SQL完整代码实现

以下是一个简单的 Android 应用程序示例，它使用手机传感器实现计步，并将步数数据存储在 SQLite 数据库中。

步骤1：创建一个新的 Android 项目

步骤2：在项目中创建一个数据库类，用于创建和管理 SQLite 数据库。

public class DatabaseHelper extends SQLiteOpenHelper {
    public static final String DATABASE_NAME = "stepcounter.db";
    public static final String TABLE_NAME = "stepcounter_table";
    public static final String COL_1 = "ID";
    public static final String COL_2 = "DATE";
    public static final String COL_3 = "STEPS";

    public DatabaseHelper(Context context) {
        super(context, DATABASE_NAME, null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table " + TABLE_NAME + " (ID INTEGER PRIMARY KEY AUTOINCREMENT,DATE TEXT,STEPS INTEGER)");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
        onCreate(db);
    }

    public boolean insertData(String date, String steps) {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put(COL_2, date);
        contentValues.put(COL_3, steps);
        long result = db.insert(TABLE_NAME, null, contentValues);
        if (result == -1)
            return false;
        else
            return true;
    }

    public Cursor getAllData() {
        SQLiteDatabase db = this.getWritableDatabase();
        Cursor res = db.rawQuery("select * from " + TABLE_NAME, null);
        return res;
    }

}

步骤3：在 MainActivity.java 文件中添加以下代码来实现计步功能。

public class MainActivity extends AppCompatActivity implements SensorEventListener{
    private TextView textView;
    private SensorManager sensorManager;
    private boolean isStepCounterSensorPresent;
    private int stepCount;
    private DatabaseHelper myDb;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        textView = findViewById(R.id.textView);
        sensorManager = (SensorManager) getSystemService(Context.SENSOR_SERVICE);
        myDb = new DatabaseHelper(this);

        if (sensorManager.getDefaultSensor(Sensor.TYPE_STEP_COUNTER) != null) {
            isStepCounterSensorPresent = true;
        } else {
            isStepCounterSensorPresent = false;
            Toast.makeText(this, "Step Counter Sensor is not present!", Toast.LENGTH_SHORT).show();
        }
    }

    @Override
    protected void onResume() {
        super.onResume();
        if (isStepCounterSensorPresent) {
            sensorManager.registerListener(this, sensorManager.getDefaultSensor(Sensor.TYPE_STEP_COUNTER), SensorManager.SENSOR_DELAY_UI);
        }
    }

    @Override
    protected void onPause() {
        super.onPause();
        if (isStepCounterSensorPresent) {
            sensorManager.unregisterListener(this, sensorManager.getDefaultSensor(Sensor.TYPE_STEP_COUNTER));
        }
    }

    @Override
    public void onSensorChanged(SensorEvent event) {
        if (event.sensor.getType() == Sensor.TYPE_STEP_COUNTER) {
            stepCount = (int) event.values[0];
            textView.setText("Step Count : " + stepCount);

            SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
            String date = sdf.format(new Date());

            boolean isInserted = myDb.insertData(date, String.valueOf(stepCount));
            if (isInserted)
                Toast.makeText(this, "Data Inserted Successfully!", Toast.LENGTH_SHORT).show();
            else
                Toast.makeText(this, "Data Insertion Failed!", Toast.LENGTH_SHORT).show();
        }
    }

    @Override
    public void onAccuracyChanged(Sensor sensor, int accuracy) {

    }
}

这段代码将在应用程序启动时检查是否存在步数传感器。如果存在，则注册侦听器以获取步数数据，并将数据插入 SQLite 数据库中。如果步数传感器不存在，则显示一条消息。

请注意，此示例仅实现了最基本的计步功能，并且可能不适用于所有设备和所有情况。