API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 14th, 2016
132
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.77 KB | None | 0 0
raw download clone embed print report
  1. 03-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.  
  50. String name, email,username,pass;
  51.  
  52. public String getEmail() {
  53. return email;
  54. }
  55.  
  56. public void setEmail(String email) {
  57. this.email = email;
  58. }
  59.  
  60. public String getName() {
  61. return name;
  62. }
  63.  
  64. public void setName(String name) {
  65. this.name = name;
  66. }
  67.  
  68. public String getUsername() {
  69. return username;
  70. }
  71.  
  72. public void setUsername(String username) {
  73. this.username = username;
  74. }
  75.  
  76. public String getPass() {
  77. return pass;
  78. }
  79.  
  80. public void setPass(String pass) {
  81. this.pass = pass;
  82. }
  83.  
  84. public class DatabaseHelper extends SQLiteOpenHelper {
  85. private static final int DATABASE_VERSION = 1;
  86. private static final String DATABASE_NAME= "contacts.db";
  87. private static final String TABLE_NAME ="contacts";
  88. private static final String COLUMN_ID ="id";
  89. private static final String COLUMN_NAME ="name";
  90. private static final String COLUMN_EMAIL ="email";
  91. private static final String COLUMN_USERNAME="username";
  92. private static final String COLUMN_PASS="pass";
  93. SQLiteDatabase db;
  94.  
  95. private 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.  
  97. public DatabaseHelper(Context context){
  98.  
  99. super(context , DATABASE_NAME, null,DATABASE_VERSION );
  100. }
  101. @Override
  102. public void onCreate(SQLiteDatabase db) {
  103.  
  104. db.execSQL(TABLE_CREATE);
  105. this.db=db;
  106.  
  107. }
  108. public void insertContact(Contact c){
  109. db=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.  
  126. public 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. }
  147. return b;
  148. }
  149. @Override
  150. public 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.  
  157. public class Login extends AppCompatActivity {
  158.  
  159. DatabaseHelper helper=new DatabaseHelper(this);
  160. @Override
  161. protected void onCreate(Bundle savedInstanceState) {
  162. super.onCreate(savedInstanceState);
  163. setContentView(R.layout.activity_login);
  164.  
  165. }
  166.  
  167. public 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.  
  197. public class SingUp extends Activity {
  198.  
  199. DatabaseHelper helper=new DatabaseHelper(this);
  200. @Override
  201. protected void onCreate(Bundle savedInstanceState) {
  202. super.onCreate(savedInstanceState);
  203. setContentView(R.layout.signup);
  204.  
  205. }
  206. public 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. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!