96
db = sqlHelper.getWritableDatabase();
Bundle extras = getIntent().getExtras();
if (extras != null) {
userId = extras.getLong("id");
}
// если 0, то добавление
if (userId > 0) {
// получаем элемент по id из бд
userCursor = db.rawQuery("select * from " +
DatabaseHelper.TABLE1 + " where " +
DatabaseHelper.COLUMN_ID + "=?", new
String[]{String.valueOf(userId)});
userCursor.moveToFirst();
nameBox.setText(userCursor.getString(1));
adres.setText(userCursor.getString(3));
phone.setText(userCursor.getString(4));
infoBox.setText(userCursor.getString(5));
payBox.setText(userCursor.getString(2));
userCursor.close();
}
}
public void save(View view){
ContentValues cv = new ContentValues();
cv.put(DatabaseHelper.COLUMN_NAME1, nameBox.getText().toString());
cv.put(DatabaseHelper.COLUMN_SURNAME1,
payBox.getText().toString());
cv.put(DatabaseHelper.COLUMN_USERNAME1,
adres.getText().toString());
cv.put(DatabaseHelper.COLUMN_TYPE, phone.getText().toString());
cv.put(DatabaseHelper.COLUMN_ABOUT, infoBox.getText().toString());
cv.put(DatabaseHelper.COLUMN_COMPLETED,
spinner.getSelectedItem().toString());
if (userId > 0) {
db.update(DatabaseHelper.TABLE1, cv, DatabaseHelper.COLUMN_ID +
"=" + String.valueOf(userId), null);
} else {
db.insert(DatabaseHelper.TABLE1, null, cv);
}
goHome();
}
private void goHome(){
// закрываем подключение
db.close();
// переход к главной activity
Intent intent = new Intent(this, AdminActivity.class);
intent.addFlags(Intent.FLAG_ACTIVITY_CLEAR_TOP |
Intent.FLAG_ACTIVITY_SINGLE_TOP);
startActivity(intent);
}
}
public class MainActivity extends AppCompatActivity {
Button go, gou;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
97
go = findViewById(R.id.go);
gou = findViewById(R.id.gou);
go.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
Intent admin = new Intent(MainActivity.this,
AdminActivity.class);
startActivity(admin);
}
});
gou.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
Intent user = new Intent(MainActivity.this,
UserLookActivity.class);
startActivity(user);
}
});
}
}
public class UserActivity extends AppCompatActivity {
EditText nameBox;
EditText infoBox;
EditText payBox;
EditText adres;
EditText phone;
Button delButton;
Button saveButton;
DatabaseHelper sqlHelper;
SQLiteDatabase db;
Cursor userCursor;
long userId=0;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_user);
nameBox = (EditText) findViewById(R.id.name);
payBox = (EditText) findViewById(R.id.paymnt);
adres = (EditText) findViewById(R.id.adres);
phone = (EditText) findViewById(R.id.phone);
infoBox = (EditText) findViewById(R.id.info);
delButton = (Button) findViewById(R.id.deleteButton);
saveButton = (Button) findViewById(R.id.saveButton);
sqlHelper = new DatabaseHelper(this);
db = sqlHelper.getWritableDatabase();
Bundle extras = getIntent().getExtras();
if (extras != null) {
userId = extras.getLong("id");
}
// если 0, то добавление
if (userId > 0) {
// получаем элемент по id из бд
userCursor = db.rawQuery("select * from " +
DatabaseHelper.TABLE + " where " +
DatabaseHelper.COLUMN_ID + "=?", new
String[]{String.valueOf(userId)});
98
userCursor.moveToFirst();
nameBox.setText(userCursor.getString(1));
adres.setText(userCursor.getString(3));
phone.setText(userCursor.getString(2));
infoBox.setText(userCursor.getString(5));
payBox.setText(userCursor.getString(4));
userCursor.close();
} else {
// скрываем кнопку удаления
delButton.setVisibility(View.GONE);
}
}
public void save(View view){
ContentValues cv = new ContentValues();
cv.put(DatabaseHelper.COLUMN_NAME, nameBox.getText().toString());
cv.put(DatabaseHelper.COLUMN_ADDRESS, phone.getText().toString());
cv.put(DatabaseHelper.COLUMN_PHONE, adres.getText().toString());
cv.put(DatabaseHelper.COLUMN_YEAR, infoBox.getText().toString());
cv.put(DatabaseHelper.COLUMN_PHIO, payBox.getText().toString());
if (userId > 0) {
db.update(DatabaseHelper.TABLE, cv, DatabaseHelper.COLUMN_ID +
"=" + String.valueOf(userId), null);
} else {
db.insert(DatabaseHelper.TABLE, null, cv);
}
goHome();
}
public void delete(View view){
db.delete(DatabaseHelper.TABLE, "_id = ?", new
String[]{String.valueOf(userId)});
goHome();
}
private void goHome(){
// закрываем подключение
db.close();
// переход к главной activity
Intent intent = new Intent(this, AdminActivity.class);
intent.addFlags(Intent.FLAG_ACTIVITY_CLEAR_TOP |
Intent.FLAG_ACTIVITY_SINGLE_TOP);
startActivity(intent);
}
}
public class UserLookActivity extends AppCompatActivity {
TextView nameBox;
TextView infoBox;
TextView payBox;
TextView adres;
TextView phone;
DatabaseHelper sqlHelper;
SQLiteDatabase db;
Cursor userCursor;
long userId=0;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_user_look);
nameBox = (TextView) findViewById(R.id.name);
99
payBox = (TextView) findViewById(R.id.paymnt);
adres = (TextView) findViewById(R.id.adres);
phone = (TextView) findViewById(R.id.phone);
infoBox = (TextView) findViewById(R.id.info);
sqlHelper = new DatabaseHelper(this);
db = sqlHelper.getWritableDatabase();
Bundle extras = getIntent().getExtras();
if (extras != null) {
userId = extras.getLong("id");
}
// если 0, то добавление
if (userId > 0) {
// получаем элемент по id из бд
userCursor = db.rawQuery("select * from " +
DatabaseHelper.TABLE1 + " where " +
DatabaseHelper.COLUMN_ID + "=?", new
String[]{String.valueOf(userId)});
userCursor.moveToFirst();
nameBox.setText(userCursor.getString(1));
adres.setText(userCursor.getString(3));
phone.setText(userCursor.getString(4));
infoBox.setText(userCursor.getString(5));
payBox.setText(userCursor.getString(2));
userCursor.close();
}
}
public void save(View view){
ContentValues cv = new ContentValues();
cv.put(DatabaseHelper.COLUMN_NAME1, nameBox.getText().toString());
cv.put(DatabaseHelper.COLUMN_SURNAME1,
payBox.getText().toString());
cv.put(DatabaseHelper.COLUMN_USERNAME1,
adres.getText().toString());
cv.put(DatabaseHelper.COLUMN_TYPE, phone.getText().toString());
cv.put(DatabaseHelper.COLUMN_ABOUT, infoBox.getText().toString());
cv.put(DatabaseHelper.COLUMN_COMPLETED, "В обработке");
if (userId > 0) {
db.update(DatabaseHelper.TABLE1, cv, DatabaseHelper.COLUMN_ID +
"=" + String.valueOf(userId), null);
} else {
db.insert(DatabaseHelper.TABLE1, null, cv);
}
Toast toast = Toast.makeText(this, "Ваша заявка принята и будет
добавлена в пулл к специалистам, скоро вашу проблему
решат.",Toast.LENGTH_LONG);
toast.show();
goHome();
}
private void goHome(){
// закрываем подключение
db.close();
// переход к главной activity
Intent intent = new Intent(this, MainActivity.class);
intent.addFlags(Intent.FLAG_ACTIVITY_CLEAR_TOP |
Intent.FLAG_ACTIVITY_SINGLE_TOP);
startActivity(intent);
100
}
}
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:orientation="vertical"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:background="@drawable/floortile">
<ListView
android:id="@+id/list"
android:layout_width="match_parent"
android:layout_height="500dp"
android:layout_weight="14"></ListView>
<LinearLayout
android:layout_width="match_parent"
android:layout_height="wrap_content">
<Button
style="@style/Widget.AppCompat.Button.Colored"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:layout_weight="1"
android:onClick="add"
android:text="Добавить пользователя"
android:textSize="18dp" />
<Button
style="@style/Widget.AppCompat.Button.Colored"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:layout_weight="1"
android:text="Посмотреть заявки"
android:textSize="18dp"
android:onClick="lookHelp"/>
</LinearLayout>
</LinearLayout>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:orientation="vertical"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:background="@drawable/floortile">
<ListView
android:id="@+id/list"
android:layout_width="match_parent"
android:layout_height="500dp"
android:layout_weight="14"></ListView>
</LinearLayout>