dQi1FCaS

1package com.nico.mcrpg;
2
3import android.app.*;
4import android.content.*;
5import android.database.*;
6import android.database.sqlite.*;
7import android.graphics.*;
8import android.graphics.drawable.*;
9import android.os.*;
10import android.text.*;
11import android.view.*;
12import android.widget.*;
13import java.util.*;
14
15public class MainActivity extends Activity 
16{
17	String name;
18	ArrayList<String> names = new ArrayList<String>();
19	
20    @Override
21    protected void onCreate(Bundle savedInstanceState)
22    {
23        super.onCreate(savedInstanceState);
24        setContentView(R.layout.main);
25		
26		ActionBar ab = getActionBar();
27		ab.setTitle(Html.fromHtml("<font color='#ffffff'>Список работников</font>"));
28		ab.setBackgroundDrawable(new ColorDrawable(Color.GRAY));
29		
30		
31		
32		SQLiteDatabase myDB = openOrCreateDatabase("people.db", MODE_PRIVATE, null);
33		myDB.execSQL(
34			"CREATE TABLE IF NOT EXISTS user (name VARCHAR(200), otd VARCHAR(200), dol VARCHAR, warn INT, data VARCHAR(200))"
35		);
36		
37		Cursor myCursor = myDB.rawQuery("select name from user", null);
38		
39		while(myCursor.moveToNext()) {
40		name = myCursor.getString(0);
41		names.add(name);
42		}
43		
44		
45		ListView lvMain = (ListView) findViewById(R.id.names);
46		ArrayAdapter<String> adapter = new ArrayAdapter<String>(this,android.R.layout.simple_list_item_1, names);
47		lvMain.setAdapter(adapter);
48		lvMain.setOnItemClickListener(new AdapterView.OnItemClickListener() {
49				@Override
50				public void onItemClick(AdapterView<?> parent, View itemClicked, int position,
51										long id) {
52					TextView textView = (TextView) itemClicked;
53					String strText = textView.getText().toString();
54					Intent intent = new Intent(MainActivity.this, Profile.class);
55					intent.putExtra("name", strText);
56					startActivity(intent);
57				}
58			});
59    }
60	
61	@Override
62	public boolean onCreateOptionsMenu(Menu menu) {
63		getMenuInflater().inflate(R.menu.main_menu, menu);
64		return true;
65	}
66	
67	@Override
68	public boolean onOptionsItemSelected(MenuItem item) {
69		
70		switch (item.getItemId()) {
71			case R.id.add:
72				Intent intent = new Intent(MainActivity.this, AddActivity.class);
73				startActivity(intent);
74				return true;
75			case R.id.exit:
76				finish();
77				return true;
78			default:
79				return super.onOptionsItemSelected(item);
80		}
81	}
82}