fork download

copy

public void query(String queryString,String finish){ //查詢資料
 
		Calendar c=Calendar.getInstance();
		String where;
		String value[];
		File databasePath=this.getDatabasePath("Princess");
 
		System.out.println("DatabaseExist:"+databasePath.getPath());
		System.out.println("Permission QQ:" +checkSelfPermission(Manifest.permission.READ_EXTERNAL_STORAGE));
		//CreatDB dbhelper=new CreatDB(this.getApplicationContext());
 
	    SQLiteDatabase  db=this.getApplicationContext().openOrCreateDatabase("Princess", SQLiteDatabase.OPEN_READWRITE,null);
	    //SQLiteDatabase db=dbhelper.getReadableDatabase();
 
	    where=null;
    	value=null;
	    String colum[]= new String[]{"_id","Finish_date","HyperLink","Main","Context","Address"};
	    if(queryString.equals("")&&finish.equals("")){
	    	where=null;
	    	value=null;
	    }else if(queryString.equals("")&&!finish.equals("")){
	    	where="Finish_date is null";
 
	    }else if(!queryString.equals("")&&finish.equals("")){
	    	where="Main like ? AND Finish_date is not null";
	    	value=new String[]{"%"+queryString+"%"};;
	    }else if(!queryString.equals("")&&!finish.equals("")){
	     where="Main like ? AND Finish_date is null";
	     value=new String[]{"%"+queryString+"%"};
 
	    }else if(queryString.equals("")&&finish.equals("all")){
	    	 where="Main like ? ";
			 value=new String[]{"%"+queryString+"%"};
	    }else{
	    	System.out.println("error");
	    	where="Main like ? ";
			value=new String[]{"%"+queryString+"%"};
	    }
	    Cursor cursor = db.query("Place",colum,where, value, null, null, null);  
	    ArrayList<HashMap<String,String>> list2 = new ArrayList<HashMap<String,String>>();
 
	    if(cursor.getCount()!=0){
			cursor.moveToFirst();
			do{
				HashMap<String,String> list=new HashMap<String,String>();
				String id=String.valueOf(cursor.getInt(0));
				String Finish_date=String.valueOf(cursor.getInt(1));
				String HyperLink=cursor.getString(2);
				String Main=cursor.getString(3);
				String Context=cursor.getString(4);
				String AddressText=cursor.getString(5);
				String ID=id+","+Main;
				String FINISH=Finish_date;
				if(FINISH.equals("0")){
					FINISH="未完成";
				}else{
					FINISH="已完成";
				}
				System.out.println("TESTQQ:"+AddressText);
				list.put("ID",ID);
				list.put("FINISH", FINISH);	
				list2.add(list);
			}while(cursor.moveToNext());
		}else{
			Toast.makeText(this.getApplicationContext(),"NO DATA", Toast.LENGTH_SHORT).show();
 
		}
	    cursor.close();
	    db.close();
 
 
	}

Main.java:1: error: class, interface, or enum expected
public void query(String queryString,String finish){ //????
       ^
Main.java:4: error: class, interface, or enum expected
		String where;
		^
Main.java:5: error: class, interface, or enum expected
		String value[];
		^
Main.java:6: error: class, interface, or enum expected
		File databasePath=this.getDatabasePath("Princess");
		^
Main.java:8: error: class, interface, or enum expected
		System.out.println("DatabaseExist:"+databasePath.getPath());
		^
Main.java:9: error: class, interface, or enum expected
		System.out.println("Permission QQ:" +checkSelfPermission(Manifest.permission.READ_EXTERNAL_STORAGE));
		^
Main.java:12: error: class, interface, or enum expected
	    SQLiteDatabase  db=this.getApplicationContext().openOrCreateDatabase("Princess", SQLiteDatabase.OPEN_READWRITE,null);
	    ^
Main.java:15: error: class, interface, or enum expected
	    where=null;
	    ^
Main.java:16: error: class, interface, or enum expected
    	value=null;
    	^
Main.java:17: error: class, interface, or enum expected
	    String colum[]= new String[]{"_id","Finish_date","HyperLink","Main","Context","Address"};
	    ^
Main.java:18: error: class, interface, or enum expected
	    if(queryString.equals("")&&finish.equals("")){
	    ^
Main.java:20: error: class, interface, or enum expected
	    	value=null;
	    	^
Main.java:21: error: class, interface, or enum expected
	    }else if(queryString.equals("")&&!finish.equals("")){
	    ^
Main.java:24: error: class, interface, or enum expected
	    }else if(!queryString.equals("")&&finish.equals("")){
	    ^
Main.java:26: error: class, interface, or enum expected
	    	value=new String[]{"%"+queryString+"%"};;
	    	^
Main.java:27: error: class, interface, or enum expected
	    }else if(!queryString.equals("")&&!finish.equals("")){
	    ^
Main.java:29: error: class, interface, or enum expected
	     value=new String[]{"%"+queryString+"%"};
	     ^
Main.java:31: error: class, interface, or enum expected
	    }else if(queryString.equals("")&&finish.equals("all")){
	    ^
Main.java:33: error: class, interface, or enum expected
			 value=new String[]{"%"+queryString+"%"};
			 ^
Main.java:34: error: class, interface, or enum expected
	    }else{
	    ^
Main.java:36: error: class, interface, or enum expected
	    	where="Main like ? ";
	    	^
Main.java:37: error: class, interface, or enum expected
			value=new String[]{"%"+queryString+"%"};
			^
Main.java:38: error: class, interface, or enum expected
	    }
	    ^
Main.java:40: error: class, interface, or enum expected
	    ArrayList<HashMap<String,String>> list2 = new ArrayList<HashMap<String,String>>();
	    ^
Main.java:42: error: class, interface, or enum expected
	    if(cursor.getCount()!=0){
	    ^
Main.java:44: error: class, interface, or enum expected
			do{
			^
Main.java:46: error: class, interface, or enum expected
				String id=String.valueOf(cursor.getInt(0));
				^
Main.java:47: error: class, interface, or enum expected
				String Finish_date=String.valueOf(cursor.getInt(1));
				^
Main.java:48: error: class, interface, or enum expected
				String HyperLink=cursor.getString(2);
				^
Main.java:49: error: class, interface, or enum expected
				String Main=cursor.getString(3);
				^
Main.java:50: error: class, interface, or enum expected
				String Context=cursor.getString(4);
				^
Main.java:51: error: class, interface, or enum expected
				String AddressText=cursor.getString(5);
				^
Main.java:52: error: class, interface, or enum expected
				String ID=id+","+Main;
				^
Main.java:53: error: class, interface, or enum expected
				String FINISH=Finish_date;
				^
Main.java:54: error: class, interface, or enum expected
				if(FINISH.equals("0")){
				^
Main.java:56: error: class, interface, or enum expected
				}else{
				^
Main.java:58: error: class, interface, or enum expected
				}
				^
Main.java:60: error: class, interface, or enum expected
				list.put("ID",ID);
				^
Main.java:61: error: class, interface, or enum expected
				list.put("FINISH", FINISH);	
				^
Main.java:62: error: class, interface, or enum expected
				list2.add(list);
				^
Main.java:63: error: class, interface, or enum expected
			}while(cursor.moveToNext());
			^
Main.java:64: error: class, interface, or enum expected
		}else{
		^
Main.java:67: error: class, interface, or enum expected
		}
		^
Main.java:69: error: class, interface, or enum expected
	    db.close();
	    ^
Main.java:72: error: class, interface, or enum expected
	}
	^
45 errors

Standard output is empty