rSgC5Eht

103-14 13:07:01.910 19906-19906/com.example.dp_7_kholood.taskone E/AndroidRuntime: FATAL EXCEPTION: main
2                                                                              Process: com.example.dp_7_kholood.taskone, PID: 19906
3                                                                              java.lang.IllegalStateException: Could not execute method for android:onClick
4                                                                                  at android.support.v7.app.AppCompatViewInflater$DeclaredOnClickListener.onClick(AppCompatViewInflater.java:293)
5                                                                                  at android.view.View.performClick(View.java:5198)
6                                                                                  at android.view.View$PerformClick.run(View.java:21147)
7                                                                                  at android.os.Handler.handleCallback(Handler.java:739)
8                                                                                  at android.os.Handler.dispatchMessage(Handler.java:95)
9                                                                                  at android.os.Looper.loop(Looper.java:148)
10                                                                                  at android.app.ActivityThread.main(ActivityThread.java:5417)
11                                                                                  at java.lang.reflect.Method.invoke(Native Method)
12                                                                                  at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:726)
13                                                                                  at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:616)
14                                                                               Caused by: java.lang.reflect.InvocationTargetException
15                                                                                  at java.lang.reflect.Method.invoke(Native Method)
16                                                                                  at android.support.v7.app.AppCompatViewInflater$DeclaredOnClickListener.onClick(AppCompatViewInflater.java:288)
17                                                                                  at android.view.View.performClick(View.java:5198) 
18                                                                                  at android.view.View$PerformClick.run(View.java:21147) 
19                                                                                  at android.os.Handler.handleCallback(Handler.java:739) 
20                                                                                  at android.os.Handler.dispatchMessage(Handler.java:95) 
21                                                                                  at android.os.Looper.loop(Looper.java:148) 
22                                                                                  at android.app.ActivityThread.main(ActivityThread.java:5417) 
23                                                                                  at java.lang.reflect.Method.invoke(Native Method) 
24                                                                                  at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:726) 
25                                                                                  at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:616) 
26                                                                               Caused by: android.database.sqlite.SQLiteException: no such column: uname (code 1): , while compiling: select uname, pass from contacts
27                                                                                  at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
28                                                                                  at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:887)
29                                                                                  at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:498)
30                                                                                  at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
31                                                                                  at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
32                                                                                  at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
33                                                                                  at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
34                                                                                  at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1316)
35                                                                                  at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1255)
36                                                                                  at com.example.dp_7_kholood.taskone.DatabaseHelper.searchPass(DatabaseHelper.java:58)
37                                                                                  at com.example.dp_7_kholood.taskone.Login.onButtonClick(Login.java:32)
38                                                                                  at java.lang.reflect.Method.invoke(Native Method) 
39                                                                                  at android.support.v7.app.AppCompatViewInflater$DeclaredOnClickListener.onClick(AppCompatViewInflater.java:288) 
40                                                                                  at android.view.View.performClick(View.java:5198) 
41                                                                                  at android.view.View$PerformClick.run(View.java:21147) 
42                                                                                  at android.os.Handler.handleCallback(Handler.java:739) 
43                                                                                  at android.os.Handler.dispatchMessage(Handler.java:95) 
44                                                                                  at android.os.Looper.loop(Looper.java:148) 
45                                                                                  at android.app.ActivityThread.main(ActivityThread.java:5417) 
46                                                                                  at java.lang.reflect.Method.invoke(Native Method) 
47                                                                                  at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:726) 
48                                                                                  at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:616) 
49	
50String name, email,username,pass;
51
52public String getEmail() {
53    return email;
54}
55
56public void setEmail(String email) {
57    this.email = email;
58}
59
60public String getName() {
61    return name;
62}
63
64public void setName(String name) {
65    this.name = name;
66}
67
68public String getUsername() {
69    return username;
70}
71
72public void setUsername(String username) {
73    this.username = username;
74}
75
76public String getPass() {
77    return pass;
78}
79
80public void setPass(String pass) {
81    this.pass = pass;
82}
83	
84public class DatabaseHelper extends SQLiteOpenHelper {
85private static final int DATABASE_VERSION = 1;
86private static final String DATABASE_NAME= "contacts.db";
87private static final String TABLE_NAME ="contacts";
88private static final String COLUMN_ID ="id";
89private static final String COLUMN_NAME ="name";
90private static final String COLUMN_EMAIL ="email";
91private static final String COLUMN_USERNAME="username";
92private static final String COLUMN_PASS="pass";
93SQLiteDatabase db;
94
95private static final String TABLE_CREATE= "create table contacts (id integer primary key not null , "+ "name text not null , email text not null , username text not null , pass text not null);";
96
97public DatabaseHelper(Context context){
98
99    super(context , DATABASE_NAME, null,DATABASE_VERSION );
100}
101@Override
102public void onCreate(SQLiteDatabase db) {
103
104    db.execSQL(TABLE_CREATE);
105    this.db=db;
106
107}
108public void insertContact(Contact c){
109db=this.getWritableDatabase();
110    ContentValues values=new ContentValues();
111
112    String query= "select * from contacts";
113    Cursor cursor=db.rawQuery(query, null);
114    int count= cursor.getCount();
115
116    values.put(COLUMN_ID,count);
117    values.put(COLUMN_NAME , c.getName());
118    values.put(COLUMN_USERNAME, c.getUsername());
119    values.put(COLUMN_EMAIL , c.getEmail());
120    values.put(COLUMN_PASS , c.getPass());
121
122    db.insert(TABLE_NAME, null, values);
123    db.close();
124}
125
126public String searchPass(String uname){
127    db=this.getReadableDatabase();
128    String query=" select uname, pass from "+TABLE_NAME;
129    Cursor cursor =db.rawQuery(query,null);
130
131    String a,b;
132    b="not found";
133    if(cursor.moveToFirst())
134    {
135        do{
136            a=cursor.getString(0);
137
138            if (a.equals(uname)){
139
140            b=cursor.getString(1);
141                break;
142        }
143
144    }
145        while(cursor.moveToNext());
146}
147return b;
148}
149@Override
150public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
151
152    String query ="DROP TABLE IF EXISTS "+TABLE_NAME;
153    db.execSQL(query);
154    this.onCreate(db);
155}
156	
157public class Login extends AppCompatActivity {
158
159DatabaseHelper helper=new DatabaseHelper(this);
160@Override
161protected void onCreate(Bundle savedInstanceState) {
162    super.onCreate(savedInstanceState);
163    setContentView(R.layout.activity_login);
164
165}
166
167public void onButtonClick(View v){
168
169
170    if (v.getId() == R.id.Blogin);
171    {
172        EditText a = (EditText)findViewById(R.id.Tfusername);
173        String str= a.getText().toString();
174        EditText b = (EditText)findViewById(R.id.Tfpassword);
175        String pass= b.getText().toString();
176        String password= helper.searchPass(str);
177
178        if(pass.equals(password)){
179
180        Intent i= new Intent(Login.this, SingUp.class);
181        i.putExtra("Username",str);
182        startActivity(i);
183
184    }
185
186        else{
187            Toast t=Toast.makeText(Login.this, "Username and Paasword not match!", Toast.LENGTH_SHORT);
188            t.show();
189        }}
190    if(v.getId()==R.id.BtnSingup){
191
192         Intent i= new Intent(Login.this, SingUp.class);
193         startActivity(i);
194    }
195}
196	
197public class SingUp extends Activity {
198
199DatabaseHelper helper=new DatabaseHelper(this);
200@Override
201protected void onCreate(Bundle savedInstanceState) {
202    super.onCreate(savedInstanceState);
203    setContentView(R.layout.signup);
204
205}
206public void OnSignUp(View v){
207    if (v.getId()==R.id.Bsingup){
208
209        EditText name= (EditText)findViewById(R.id.Tfname);
210        EditText username= (EditText)findViewById(R.id.Tfusername);
211        EditText email= (EditText)findViewById(R.id.Tfemail);
212        EditText pass1= (EditText)findViewById(R.id.Tfpass1);
213        EditText pass2= (EditText)findViewById(R.id.Tfpass2);
214
215        String namestr = name.getText().toString();
216        String usernamestr = username.getText().toString();
217        String emailstr = email.getText().toString();
218        String pass1str = pass1.getText().toString();
219        String pass2str = pass2.getText().toString();
220
221        if(!pass1str.equals(pass2str)){
222            Toast pass=Toast.makeText(SingUp.this, "Paasword not match!", Toast.LENGTH_SHORT);
223            pass.show();
224        }
225        else{
226
227            Contact c =new Contact();
228            c.setName(namestr);
229            c.setEmail(emailstr);
230            c.setUsername(usernamestr);
231            c.setPass(pass1str);
232            helper.insertContact(c);
233        }
234
235    }
236}