Android开发多线程断点续传下载器

淡淡的烟草味﹌ 2022-07-27 12:59 155阅读 0赞

使用多线程断点续传下载器在下载的时候多个线程并发可以占用服务器端更多资源，从而加快下载速度，在下载过程中记录每个线程已拷贝数据的数量，如果下载中断，比如无信号断线、电量不足等情况下，这就需要使用到断点续传功能，下次启动时从记录位置继续下载，可避免重复部分的下载。这里采用数据库来记录下载的进度。

**效果图**

![0_1317467381Z6MF.gif][]       ![0_1317467514YVbY.gif][]

**断点续传**

1.断点续传需要在下载过程中记录每条线程的下载进度

2.每次下载开始之前先读取数据库，查询是否有未完成的记录，有就继续下载，没有则创建新记录插入数据库

3.在每次向文件中写入数据之后，在数据库中更新下载进度

4.下载完成之后删除数据库中下载记录

**Handler传输数据**

这个主要用来记录百分比，每下载一部分数据就通知主线程来记录时间

1.主线程中创建的View只能在主线程中修改，其他线程只能通过和主线程通信，在主线程中改变View数据

2.我们使用Handler可以处理这种需求

主线程中创建Handler，重写handleMessage()方法

新线程中使用Handler发送消息，主线程即可收到消息，并且执行handleMessage()方法

**动态生成新View**

可实现多任务下载

1.创建XML文件，将要生成的View配置好

2.获取系统服务LayoutInflater，用来生成新的View

LayoutInflater inflater = (LayoutInflater) getSystemService(*LAYOUT\_INFLATER\_SERVICE*);

3.使用inflate(int resource, ViewGroup root)方法生成新的View

4.调用当前页面中某个容器的addView，将新创建的View添加进来

示例

进度条样式 download.xml

**\[html\]** [ view plain][view plain] [ copy][view plain] [ print][view plain] [?][view plain]

1.  <?xml version="1.0" encoding="utf-8"?>  
2.  <LinearLayout   
3.      xmlns:android="http://schemas.android.com/apk/res/android"  
4.      android:layout\_width="fill\_parent"  
5.      android:layout\_height="wrap\_content"  
6.      >  
7.      <LinearLayout   
8.          android:orientation="vertical"  
9.          android:layout\_width="fill\_parent"  
10.         android:layout\_height="wrap\_content"  
11.         android:layout\_weight="1"  
12.         >  
13.           
15.         <ProgressBar  
16.             android:layout\_width="fill\_parent"   
17.             android:layout\_height="20dp"  
18.             style="?android:attr/progressBarStyleHorizontal"  
19.             />  
20.         <TextView  
21.             android:layout\_width="wrap\_content"   
22.             android:layout\_height="wrap\_content"  
23.             android:layout\_gravity="center"  
24.             android:text="0%"  
25.             />  
26.     </LinearLayout>  
27.     <Button  
28.         android:layout\_width="40dp"  
29.         android:layout\_height="40dp"  
30.         android:onClick="pause"  
31.         android:text="||"  
32.         />  
33. </LinearLayout>

<?xml version="1.0" encoding="utf-8"?>
    <LinearLayout 
      	xmlns:android="http://schemas.android.com/apk/res/android"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        >
    	<LinearLayout 
    		android:orientation="vertical"
    	    android:layout_width="fill_parent"
    	    android:layout_height="wrap_content"
    	    android:layout_weight="1"
    	    >
    	    
    		<ProgressBar
    			android:layout_width="fill_parent" 
    			android:layout_height="20dp"
    			style="?android:attr/progressBarStyleHorizontal"
    			/>
    		<TextView
    			android:layout_width="wrap_content" 
    			android:layout_height="wrap_content"
    			android:layout_gravity="center"
    			android:text="0%"
    			/>
    	</LinearLayout>
    	<Button
    		android:layout_width="40dp"
    	    android:layout_height="40dp"
    	    android:onClick="pause"
    	    android:text="||"
    		/>
    </LinearLayout>

顶部样式 main.xml

**\[html\]** [ view plain][view plain] [ copy][view plain] [ print][view plain] [?][view plain]

1.  <?xml version="1.0" encoding="utf-8"?>  
2.  <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"  
3.      android:orientation="vertical"  
4.      android:layout\_width="fill\_parent"  
5.      android:layout\_height="fill\_parent"  
6.      android:id="@+id/root"  
7.      >  
8.      <TextView    
9.          android:layout\_width="fill\_parent"   
10.         android:layout\_height="wrap\_content"   
11.         android:text="请输入下载路径"  
12.         />  
13.     <LinearLayout   
14.         android:layout\_width="fill\_parent"  
15.         android:layout\_height="wrap\_content"  
16.         android:layout\_marginBottom="30dp"  
17.         >  
18.         <EditText  
19.             android:id="@+id/path"  
20.             android:layout\_width="fill\_parent"   
21.             android:layout\_height="wrap\_content"   
22.             android:singleLine="true"  
23.             android:layout\_weight="1"  
24.             />  
25.         <Button  
26.             android:layout\_width="wrap\_content"   
27.             android:layout\_height="wrap\_content"   
28.             android:text="下载"  
29.             android:onClick="download"  
30.             />  
31.     </LinearLayout>  
32. </LinearLayout>  
33.

<?xml version="1.0" encoding="utf-8"?>
    <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
        android:orientation="vertical"
        android:layout_width="fill_parent"
        android:layout_height="fill_parent"
        android:id="@+id/root"
        >
    	<TextView  
    	    android:layout_width="fill_parent" 
    	    android:layout_height="wrap_content" 
    	    android:text="请输入下载路径"
    	    />
    	<LinearLayout 
    	    android:layout_width="fill_parent"
    	    android:layout_height="wrap_content"
    	    android:layout_marginBottom="30dp"
    	    >
    		<EditText
    			android:id="@+id/path"
    			android:layout_width="fill_parent" 
    		    android:layout_height="wrap_content" 
    		    android:singleLine="true"
    		    android:layout_weight="1"
    			/>
    		<Button
    			android:layout_width="wrap_content" 
    		    android:layout_height="wrap_content" 
    		    android:text="下载"
    		    android:onClick="download"
    		    />
    	</LinearLayout>
    </LinearLayout>

MainActivity.java

**\[java\]** [ view plain][view plain] [ copy][view plain] [ print][view plain] [?][view plain]

1.  public class MainActivity extends Activity \{  
2.      private LayoutInflater inflater;  
3.      private LinearLayout rootLinearLayout;  
4.      private EditText pathEditText;  
5.    
6.      @Override  
7.      public void onCreate(Bundle savedInstanceState) \{  
8.          super.onCreate(savedInstanceState);  
9.          setContentView(R.layout.main);  
10.   
11.         //动态生成新View，获取系统服务LayoutInflater，用来生成新的View   
12.         inflater = (LayoutInflater) getSystemService(LAYOUT\_INFLATER\_SERVICE);  
13.         rootLinearLayout = (LinearLayout) findViewById(R.id.root);  
14.         pathEditText = (EditText) findViewById(R.id.path);  
15.   
16.         // 窗体创建之后, 查询数据库是否有未完成任务, 如果有, 创建进度条等组件, 继续下载    
17.         List<String> list = new InfoDao(this).queryUndone();  
18.         for (String path : list)  
19.             createDownload(path);  
20.     \}  
21.   
22.     /\*\* 
23.      \* 下载按钮 
24.      \* @param view 
25.      \*/  
26.     public void download(View view) \{  
27.         String path = "http://192.168.1.199:8080/14\_Web/" + pathEditText.getText().toString();  
28.         createDownload(path);  
29.     \}  
30.   
31.     /\*\* 
32.      \* 动态生成新View 
33.      \* 初始化表单数据 
34.      \* @param path 
35.      \*/  
36.     private void createDownload(String path) \{  
37.         //获取系统服务LayoutInflater，用来生成新的View    
38.         LayoutInflater inflater = (LayoutInflater) getSystemService(LAYOUT\_INFLATER\_SERVICE);  
39.         LinearLayout linearLayout = (LinearLayout) inflater.inflate(R.layout.download, null);  
40.           
41.         LinearLayout childLinearLayout = (LinearLayout) linearLayout.getChildAt(0);  
42.         ProgressBar progressBar = (ProgressBar) childLinearLayout.getChildAt(0);  
43.         TextView textView = (TextView) childLinearLayout.getChildAt(1);  
44.         Button button = (Button) linearLayout.getChildAt(1);  
45.   
46.         try \{  
47.             button.setOnClickListener(new MyListener(progressBar, textView, path));  
48.             //调用当前页面中某个容器的addView，将新创建的View添加进来    
49.             rootLinearLayout.addView(linearLayout);  
50.         \} catch (Exception e) \{  
51.             e.printStackTrace();  
52.         \}  
53.     \}  
54.   
55.     private final class MyListener implements OnClickListener \{  
56.         private ProgressBar progressBar;  
57.         private TextView textView;  
58.         private int fileLen;  
59.         private Downloader downloader;  
60.         private String name;  
61.           
62.         /\*\* 
63.          \* 执行下载 
64.          \* @param progressBar //进度条 
65.          \* @param textView //百分比 
66.          \* @param path  //下载文件路径 
67.          \*/  
68.         public MyListener(ProgressBar progressBar, TextView textView, String path) \{  
69.             this.progressBar = progressBar;  
70.             this.textView = textView;  
71.             name = path.substring(path.lastIndexOf("/") + 1);  
72.   
73.             downloader = new Downloader(getApplicationContext(), handler);  
74.             try \{  
75.                 downloader.download(path, 3);  
76.             \} catch (Exception e) \{  
77.                 e.printStackTrace();  
78.                 Toast.makeText(getApplicationContext(), "下载过程中出现异常", 0).show();  
79.                 throw new RuntimeException(e);  
80.             \}  
81.         \}  
82.           
83.         //Handler传输数据   
84.         private Handler handler = new Handler() \{  
85.             @Override  
86.             public void handleMessage(Message msg) \{  
87.                 switch (msg.what) \{  
88.                     case 0:  
89.                         //获取文件的大小   
90.                         fileLen = msg.getData().getInt("fileLen");  
91.                         //设置进度条最大刻度：setMax()   
92.                         progressBar.setMax(fileLen);  
93.                         break;  
94.                     case 1:  
95.                         //获取当前下载的总量    
96.                         int done = msg.getData().getInt("done");  
97.                         //当前进度的百分比   
98.                         textView.setText(name + "\\t" + done \* 100 / fileLen + "%");  
99.                         //进度条设置当前进度：setProgress()   
100.                         progressBar.setProgress(done);  
101.                         if (done == fileLen) \{  
102.                             Toast.makeText(getApplicationContext(), name + " 下载完成", 0).show();  
103.                             //下载完成后退出进度条    
104.                             rootLinearLayout.removeView((View) progressBar.getParent().getParent());  
105.                         \}  
106.                         break;  
107.                 \}  
108.             \}  
109.         \};  
110.   
111.         /\*\* 
112.          \* 暂停和继续下载 
113.          \*/  
114.         public void onClick(View v) \{  
115.             Button pauseButton = (Button) v;  
116.             if ("||".equals(pauseButton.getText())) \{  
117.                 downloader.pause();  
118.                 pauseButton.setText("▶");  
119.             \} else \{  
120.                 downloader.resume();  
121.                 pauseButton.setText("||");  
122.             \}  
123.         \}  
124.     \}  
125. \}

public class MainActivity extends Activity {
    	private LayoutInflater inflater;
    	private LinearLayout rootLinearLayout;
    	private EditText pathEditText;
    
    	@Override
    	public void onCreate(Bundle savedInstanceState) {
    		super.onCreate(savedInstanceState);
    		setContentView(R.layout.main);
    
    		//动态生成新View，获取系统服务LayoutInflater，用来生成新的View
    		inflater = (LayoutInflater) getSystemService(LAYOUT_INFLATER_SERVICE);
    		rootLinearLayout = (LinearLayout) findViewById(R.id.root);
    		pathEditText = (EditText) findViewById(R.id.path);
    
    		// 窗体创建之后, 查询数据库是否有未完成任务, 如果有, 创建进度条等组件, 继续下载
    		List<String> list = new InfoDao(this).queryUndone();
    		for (String path : list)
    			createDownload(path);
    	}
    
    	/**
    	 * 下载按钮
    	 * @param view
    	 */
    	public void download(View view) {
    		String path = "http://192.168.1.199:8080/14_Web/" + pathEditText.getText().toString();
    		createDownload(path);
    	}
    
    	/**
    	 * 动态生成新View
    	 * 初始化表单数据
    	 * @param path
    	 */
    	private void createDownload(String path) {
    		//获取系统服务LayoutInflater，用来生成新的View
    		LayoutInflater inflater = (LayoutInflater) getSystemService(LAYOUT_INFLATER_SERVICE);
    		LinearLayout linearLayout = (LinearLayout) inflater.inflate(R.layout.download, null);
    		
    		LinearLayout childLinearLayout = (LinearLayout) linearLayout.getChildAt(0);
    		ProgressBar progressBar = (ProgressBar) childLinearLayout.getChildAt(0);
    		TextView textView = (TextView) childLinearLayout.getChildAt(1);
    		Button button = (Button) linearLayout.getChildAt(1);
    
    		try {
    			button.setOnClickListener(new MyListener(progressBar, textView, path));
    			//调用当前页面中某个容器的addView，将新创建的View添加进来
    			rootLinearLayout.addView(linearLayout);
    		} catch (Exception e) {
    			e.printStackTrace();
    		}
    	}
    
    	private final class MyListener implements OnClickListener {
    		private ProgressBar progressBar;
    		private TextView textView;
    		private int fileLen;
    		private Downloader downloader;
    		private String name;
    		
    		/**
    		 * 执行下载
    		 * @param progressBar //进度条
    		 * @param textView //百分比
    		 * @param path  //下载文件路径
    		 */
    		public MyListener(ProgressBar progressBar, TextView textView, String path) {
    			this.progressBar = progressBar;
    			this.textView = textView;
    			name = path.substring(path.lastIndexOf("/") + 1);
    
    			downloader = new Downloader(getApplicationContext(), handler);
    			try {
    				downloader.download(path, 3);
    			} catch (Exception e) {
    				e.printStackTrace();
    				Toast.makeText(getApplicationContext(), "下载过程中出现异常", 0).show();
    				throw new RuntimeException(e);
    			}
    		}
    		
    		//Handler传输数据
    		private Handler handler = new Handler() {
    			@Override
    			public void handleMessage(Message msg) {
    				switch (msg.what) {
    					case 0:
    						//获取文件的大小
    						fileLen = msg.getData().getInt("fileLen");
    						//设置进度条最大刻度：setMax()
    						progressBar.setMax(fileLen);
    						break;
    					case 1:
    						//获取当前下载的总量
    						int done = msg.getData().getInt("done");
    						//当前进度的百分比
    						textView.setText(name + "\t" + done * 100 / fileLen + "%");
    						//进度条设置当前进度：setProgress()
    						progressBar.setProgress(done);
    						if (done == fileLen) {
    							Toast.makeText(getApplicationContext(), name + " 下载完成", 0).show();
    							//下载完成后退出进度条
    							rootLinearLayout.removeView((View) progressBar.getParent().getParent());
    						}
    						break;
    				}
    			}
    		};
    
    		/**
    		 * 暂停和继续下载
    		 */
    		public void onClick(View v) {
    			Button pauseButton = (Button) v;
    			if ("||".equals(pauseButton.getText())) {
    				downloader.pause();
    				pauseButton.setText("▶");
    			} else {
    				downloader.resume();
    				pauseButton.setText("||");
    			}
    		}
    	}
    }

Downloader.java

**\[java\]** [ view plain][view plain] [ copy][view plain] [ print][view plain] [?][view plain]

1.  public class Downloader \{  
2.    
3.      private int done;  
4.      private InfoDao dao;  
5.      private int fileLen;  
6.      private Handler handler;  
7.      private boolean isPause;  
8.    
9.      public Downloader(Context context, Handler handler) \{  
10.         dao = new InfoDao(context);  
11.         this.handler = handler;  
12.     \}  
13.     /\*\* 
14.      \* 多线程下载 
15.      \* @param path 下载路径 
16.      \* @param thCount 需要开启多少个线程 
17.      \* @throws Exception 
18.      \*/  
19.     public void download(String path, int thCount) throws Exception \{  
20.         URL url = new URL(path);  
21.         HttpURLConnection conn = (HttpURLConnection) url.openConnection();  
22.         //设置超时时间   
23.         conn.setConnectTimeout(3000);  
24.         if (conn.getResponseCode() == 200) \{  
25.             fileLen = conn.getContentLength();  
26.             String name = path.substring(path.lastIndexOf("/") + 1);  
27.             File file = new File(Environment.getExternalStorageDirectory(), name);  
28.             RandomAccessFile raf = new RandomAccessFile(file, "rws");  
29.             raf.setLength(fileLen);  
30.             raf.close();  
31.               
32.             //Handler发送消息，主线程接收消息，获取数据的长度   
33.             Message msg = new Message();  
34.             msg.what = 0;  
35.             msg.getData().putInt("fileLen", fileLen);  
36.             handler.sendMessage(msg);  
37.               
38.             //计算每个线程下载的字节数   
39.             int partLen = (fileLen + thCount - 1) / thCount;  
40.             for (int i = 0; i < thCount; i++)  
41.                 new DownloadThread(url, file, partLen, i).start();  
42.         \} else \{  
43.             throw new IllegalArgumentException("404 path: " + path);  
44.         \}  
45.     \}  
46.   
47.     private final class DownloadThread extends Thread \{  
48.         private URL url;  
49.         private File file;  
50.         private int partLen;  
51.         private int id;  
52.   
53.         public DownloadThread(URL url, File file, int partLen, int id) \{  
54.             this.url = url;  
55.             this.file = file;  
56.             this.partLen = partLen;  
57.             this.id = id;  
58.         \}  
59.   
60.         /\*\* 
61.          \* 写入操作 
62.          \*/  
63.         public void run() \{  
64.             // 判断上次是否有未完成任务   
65.             Info info = dao.query(url.toString(), id);  
66.             if (info != null) \{  
67.                 // 如果有, 读取当前线程已下载量   
68.                 done += info.getDone();  
69.             \} else \{  
70.                 // 如果没有, 则创建一个新记录存入   
71.                 info = new Info(url.toString(), id, 0);  
72.                 dao.insert(info);  
73.             \}  
74.   
75.             int start = id \* partLen + info.getDone(); // 开始位置 += 已下载量   
76.             int end = (id + 1) \* partLen - 1;  
77.   
78.             try \{  
79.                 HttpURLConnection conn = (HttpURLConnection) url.openConnection();  
80.                 conn.setReadTimeout(3000);  
81.                 //获取指定位置的数据，Range范围如果超出服务器上数据范围, 会以服务器数据末尾为准   
82.                 conn.setRequestProperty("Range", "bytes=" + start + "-" + end);  
83.                 RandomAccessFile raf = new RandomAccessFile(file, "rws");  
84.                 raf.seek(start);  
85.                 //开始读写数据   
86.                 InputStream in = conn.getInputStream();  
87.                 byte\[\] buf = new byte\[1024 \* 10\];  
88.                 int len;  
89.                 while ((len = in.read(buf)) != -1) \{  
90.                     if (isPause) \{  
91.                         //使用线程锁锁定该线程    
92.                         synchronized (dao) \{  
93.                             try \{  
94.                                 dao.wait();  
95.                             \} catch (InterruptedException e) \{  
96.                                 e.printStackTrace();  
97.                             \}  
98.                         \}  
99.                     \}  
100.                     raf.write(buf, 0, len);  
101.                     done += len;  
102.                     info.setDone(info.getDone() + len);  
103.                     // 记录每个线程已下载的数据量    
104.                     dao.update(info);   
105.                     //新线程中用Handler发送消息，主线程接收消息   
106.                     Message msg = new Message();  
107.                     msg.what = 1;  
108.                     msg.getData().putInt("done", done);  
109.                     handler.sendMessage(msg);  
110.                 \}  
111.                 in.close();  
112.                 raf.close();  
113.                 // 删除下载记录   
114.                 dao.deleteAll(info.getPath(), fileLen);   
115.             \} catch (IOException e) \{  
116.                 e.printStackTrace();  
117.             \}  
118.         \}  
119.     \}  
120.   
121.     //暂停下载   
122.     public void pause() \{  
123.         isPause = true;  
124.     \}  
125.     //继续下载   
126.     public void resume() \{  
127.         isPause = false;  
128.         //恢复所有线程   
129.         synchronized (dao) \{  
130.             dao.notifyAll();  
131.         \}  
132.     \}  
133. \}

public class Downloader {
    
    	private int done;
    	private InfoDao dao;
    	private int fileLen;
    	private Handler handler;
    	private boolean isPause;
    
    	public Downloader(Context context, Handler handler) {
    		dao = new InfoDao(context);
    		this.handler = handler;
    	}
        /**
         * 多线程下载
         * @param path 下载路径
         * @param thCount 需要开启多少个线程
         * @throws Exception
         */
    	public void download(String path, int thCount) throws Exception {
    		URL url = new URL(path);
    		HttpURLConnection conn = (HttpURLConnection) url.openConnection();
    		//设置超时时间
    		conn.setConnectTimeout(3000);
    		if (conn.getResponseCode() == 200) {
    			fileLen = conn.getContentLength();
    			String name = path.substring(path.lastIndexOf("/") + 1);
    			File file = new File(Environment.getExternalStorageDirectory(), name);
    			RandomAccessFile raf = new RandomAccessFile(file, "rws");
    			raf.setLength(fileLen);
    			raf.close();
    			
    			//Handler发送消息，主线程接收消息，获取数据的长度
    			Message msg = new Message();
    			msg.what = 0;
    			msg.getData().putInt("fileLen", fileLen);
    			handler.sendMessage(msg);
                
    			//计算每个线程下载的字节数
    			int partLen = (fileLen + thCount - 1) / thCount;
    			for (int i = 0; i < thCount; i++)
    				new DownloadThread(url, file, partLen, i).start();
    		} else {
    			throw new IllegalArgumentException("404 path: " + path);
    		}
    	}
    
    	private final class DownloadThread extends Thread {
    		private URL url;
    		private File file;
    		private int partLen;
    		private int id;
    
    		public DownloadThread(URL url, File file, int partLen, int id) {
    			this.url = url;
    			this.file = file;
    			this.partLen = partLen;
    			this.id = id;
    		}
    
    		/**
    		 * 写入操作
    		 */
    		public void run() {
    			// 判断上次是否有未完成任务
    			Info info = dao.query(url.toString(), id);
    			if (info != null) {
    				// 如果有, 读取当前线程已下载量
    				done += info.getDone();
    			} else {
    				// 如果没有, 则创建一个新记录存入
    				info = new Info(url.toString(), id, 0);
    				dao.insert(info);
    			}
    
    			int start = id * partLen + info.getDone(); // 开始位置 += 已下载量
    			int end = (id + 1) * partLen - 1;
    
    			try {
    				HttpURLConnection conn = (HttpURLConnection) url.openConnection();
    				conn.setReadTimeout(3000);
    				//获取指定位置的数据，Range范围如果超出服务器上数据范围, 会以服务器数据末尾为准
    				conn.setRequestProperty("Range", "bytes=" + start + "-" + end);
    				RandomAccessFile raf = new RandomAccessFile(file, "rws");
    				raf.seek(start);
    				//开始读写数据
    				InputStream in = conn.getInputStream();
    				byte[] buf = new byte[1024 * 10];
    				int len;
    				while ((len = in.read(buf)) != -1) {
    					if (isPause) {
    						//使用线程锁锁定该线程
    						synchronized (dao) {
    							try {
    								dao.wait();
    							} catch (InterruptedException e) {
    								e.printStackTrace();
    							}
    						}
    					}
    					raf.write(buf, 0, len);
    					done += len;
    					info.setDone(info.getDone() + len);
    					// 记录每个线程已下载的数据量
    					dao.update(info); 
    					//新线程中用Handler发送消息，主线程接收消息
    					Message msg = new Message();
    					msg.what = 1;
    					msg.getData().putInt("done", done);
    					handler.sendMessage(msg);
    				}
    				in.close();
    				raf.close();
    				// 删除下载记录
    				dao.deleteAll(info.getPath(), fileLen); 
    			} catch (IOException e) {
    				e.printStackTrace();
    			}
    		}
    	}
    
    	//暂停下载
    	public void pause() {
    		isPause = true;
    	}
    	//继续下载
    	public void resume() {
    		isPause = false;
    		//恢复所有线程
    		synchronized (dao) {
    			dao.notifyAll();
    		}
    	}
    }

**Dao：**

DBOpenHelper：

**\[java\]** [ view plain][view plain] [ copy][view plain] [ print][view plain] [?][view plain]

1.  public class DBOpenHelper extends SQLiteOpenHelper \{  
2.    
3.      public DBOpenHelper(Context context) \{  
4.          super(context, "download.db", null, 1);  
5.      \}  
6.    
7.      @Override  
8.      public void onCreate(SQLiteDatabase db) \{  
9.          db.execSQL("CREATE TABLE info(path VARCHAR(1024), thid INTEGER, done INTEGER, PRIMARY KEY(path, thid))");  
10.     \}  
11.   
12.     @Override  
13.     public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) \{  
14.     \}  
15.   
16. \}

public class DBOpenHelper extends SQLiteOpenHelper {
    
    	public DBOpenHelper(Context context) {
    		super(context, "download.db", null, 1);
    	}
    
    	@Override
    	public void onCreate(SQLiteDatabase db) {
    		db.execSQL("CREATE TABLE info(path VARCHAR(1024), thid INTEGER, done INTEGER, PRIMARY KEY(path, thid))");
    	}
    
    	@Override
    	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    	}
    
    }

InfoDao：

**\[java\]** [ view plain][view plain] [ copy][view plain] [ print][view plain] [?][view plain]

1.  public class InfoDao \{  
2.      private DBOpenHelper helper;  
3.    
4.      public InfoDao(Context context) \{  
5.          helper = new DBOpenHelper(context);  
6.      \}  
7.    
8.      public void insert(Info info) \{  
9.          SQLiteDatabase db = helper.getWritableDatabase();  
10.         db.execSQL("INSERT INTO info(path, thid, done) VALUES(?, ?, ?)", new Object\[\] \{ info.getPath(), info.getThid(), info.getDone() \});  
11.     \}  
12.   
13.     public void delete(String path, int thid) \{  
14.         SQLiteDatabase db = helper.getWritableDatabase();  
15.         db.execSQL("DELETE FROM info WHERE path=? AND thid=?", new Object\[\] \{ path, thid \});  
16.     \}  
17.   
18.     public void update(Info info) \{  
19.         SQLiteDatabase db = helper.getWritableDatabase();  
20.         db.execSQL("UPDATE info SET done=? WHERE path=? AND thid=?", new Object\[\] \{ info.getDone(), info.getPath(), info.getThid() \});  
21.     \}  
22.   
23.     public Info query(String path, int thid) \{  
24.         SQLiteDatabase db = helper.getWritableDatabase();  
25.         Cursor c = db.rawQuery("SELECT path, thid, done FROM info WHERE path=? AND thid=?", new String\[\] \{ path, String.valueOf(thid) \});  
26.         Info info = null;  
27.         if (c.moveToNext())  
28.             info = new Info(c.getString(0), c.getInt(1), c.getInt(2));  
29.         c.close();  
30.   
31.         return info;  
32.     \}  
33.   
34.     public void deleteAll(String path, int len) \{  
35.         SQLiteDatabase db = helper.getWritableDatabase();  
36.         Cursor c = db.rawQuery("SELECT SUM(done) FROM info WHERE path=?", new String\[\] \{ path \});  
37.         if (c.moveToNext()) \{  
38.             int result = c.getInt(0);  
39.             if (result == len)  
40.                 db.execSQL("DELETE FROM info WHERE path=? ", new Object\[\] \{ path \});  
41.         \}  
42.     \}  
43.   
44.     public List<String> queryUndone() \{  
45.         SQLiteDatabase db = helper.getWritableDatabase();  
46.         Cursor c = db.rawQuery("SELECT DISTINCT path FROM info", null);  
47.         List<String> pathList = new ArrayList<String>();  
48.         while (c.moveToNext())  
49.             pathList.add(c.getString(0));  
50.         c.close();  
51.         return pathList;  
52.     \}  
53.   
54. \}

public class InfoDao {
    	private DBOpenHelper helper;
    
    	public InfoDao(Context context) {
    		helper = new DBOpenHelper(context);
    	}
    
    	public void insert(Info info) {
    		SQLiteDatabase db = helper.getWritableDatabase();
    		db.execSQL("INSERT INTO info(path, thid, done) VALUES(?, ?, ?)", new Object[] { info.getPath(), info.getThid(), info.getDone() });
    	}
    
    	public void delete(String path, int thid) {
    		SQLiteDatabase db = helper.getWritableDatabase();
    		db.execSQL("DELETE FROM info WHERE path=? AND thid=?", new Object[] { path, thid });
    	}
    
    	public void update(Info info) {
    		SQLiteDatabase db = helper.getWritableDatabase();
    		db.execSQL("UPDATE info SET done=? WHERE path=? AND thid=?", new Object[] { info.getDone(), info.getPath(), info.getThid() });
    	}
    
    	public Info query(String path, int thid) {
    		SQLiteDatabase db = helper.getWritableDatabase();
    		Cursor c = db.rawQuery("SELECT path, thid, done FROM info WHERE path=? AND thid=?", new String[] { path, String.valueOf(thid) });
    		Info info = null;
    		if (c.moveToNext())
    			info = new Info(c.getString(0), c.getInt(1), c.getInt(2));
    		c.close();
    
    		return info;
    	}
    
    	public void deleteAll(String path, int len) {
    		SQLiteDatabase db = helper.getWritableDatabase();
    		Cursor c = db.rawQuery("SELECT SUM(done) FROM info WHERE path=?", new String[] { path });
    		if (c.moveToNext()) {
    			int result = c.getInt(0);
    			if (result == len)
    				db.execSQL("DELETE FROM info WHERE path=? ", new Object[] { path });
    		}
    	}
    
    	public List<String> queryUndone() {
    		SQLiteDatabase db = helper.getWritableDatabase();
    		Cursor c = db.rawQuery("SELECT DISTINCT path FROM info", null);
    		List<String> pathList = new ArrayList<String>();
    		while (c.moveToNext())
    			pathList.add(c.getString(0));
    		c.close();
    		return pathList;
    	}
    
    }

转载地址：[http://blog.csdn.net/furongkang/article/details/6838521][http_blog.csdn.net_furongkang_article_details_6838521]

[0_1317467381Z6MF.gif]: http://hi.csdn.net/attachment/201110/1/0_1317467381Z6MF.gif
[0_1317467514YVbY.gif]: /images/20220727/9965ab6115694e38b3345d0238c60c0f.png
[view plain]: http://blog.csdn.net/furongkang/article/details/6838521#
[http_blog.csdn.net_furongkang_article_details_6838521]: http://blog.csdn.net/furongkang/article/details/6838521