package?com.sxt.tuangou.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

import?org.apache.commons.dbutils.QueryRunner;

import?com.sxt.tuangou.entity.Backup;
import?com.sxt.tuangou.entity.Manager;

public?class?BackupDao?{

	/**
	?*?通過id查詢
	?*?@return
	?*/
	public?Backup?findByBackupId（）{
		
		Connection?conn?=?null;
		
		Statement?stat?=?null;
		ResultSet?rs?=?null;
		Backup?backup=null;
		conn=DBUtil.getConn（）;
		try?{
			stat=conn.createStatement（）;
			String?sql?=?“select?*?from?kg_backup?where?backup_id?=?1“;
			rs?=?stat.executeQuery（sql）;
			if（rs.next（））{
				String?backupDate?=rs.getString（“backup_date“）;
				long?backupLength?=?rs.getLong（“backup_length“）;
				backup?=?new?Backup（1?backupDate?backupLength）;
				
			}
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			DBUtil.closeConn（conn?stat?rs）;
		}
		return?backup;
	}
	
	
	/*
	?*?更改備份日期和大小
	?*?
	?*/
	public?int?updateBackup（Backup?backup）{
		int?rowCount=0;
		Connection?conn=null;
		PreparedStatement?stat=null;
		try?{
			conn=DBUtil.getConn（）;
			String?sql=“update?kg_backup?set?backup_date=?backup_length=??where?backup_id=1“;
			stat=conn.prepareStatement（sql）;
			
			//填值
			stat.setString（1?backup.getBackupDate（））;
			stat.setLong（2?backup.getBackupLength（））;
			
			rowCount=stat.executeUpdate（）;
						
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			
			DBUtil.closeConn（conn?stat?null）;
		}
		return?rowCount;
		
	}
	
	
	/**
	?*?添加
	?*?@param?backup
	?*?@return
	?*/
	public?int?saveBackup（Backup?backup）?{
		String?sql=“insert?into?kg_backup（backup_idbackup_datebackup_length）?values（???）“;
		return?DBUtil.executeUpdate（sql?new?object[]?{
				backup.getBackupId（）
				backup.getBackupDate（）
				backup.getBackupLength（）?}）;
	}
	
	
	/**
	?*?刪除
	?*?@param?backupId
	?*?@return
	?*/
	
	public???void?deleteBackup（int?backupId）{
		Connection?conn=null;
		Statement?stat=null;
		conn=DBUtil.getConn（）;
		try?{
			stat=conn.createStatement（）;
			String?sql=“delete?from?kg_backup?where?backup_id=“+backupId;
			stat.executeUpdate（sql）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			DBUtil.closeConn（conn?stat?null）;
		}
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1232??2013-12-11?23:55??Hokilly_tuangou\.classpath

?????文件????????318??2013-12-11?23:56??Hokilly_tuangou\.mymetadata

?????文件???????1758??2013-11-05?11:34??Hokilly_tuangou\.project

?????文件????????500??2013-11-05?11:35??Hokilly_tuangou\.settings\.jsdtscope

?????文件???????1342??2013-11-06?13:56??Hokilly_tuangou\.settings\.svn\entries

?????文件????????500??2013-11-05?11:35??Hokilly_tuangou\.settings\.svn\text-base\.jsdtscope.svn-base

?????文件????????325??2013-11-05?11:35??Hokilly_tuangou\.settings\.svn\text-base\org.eclipse.core.resources.prefs.svn-base

?????文件????????364??2013-11-05?11:35??Hokilly_tuangou\.settings\.svn\text-base\org.eclipse.jdt.core.prefs.svn-base

?????文件????????483??2013-11-05?11:35??Hokilly_tuangou\.settings\.svn\text-base\org.eclipse.wst.common.component.svn-base

?????文件????????252??2013-11-05?11:35??Hokilly_tuangou\.settings\.svn\text-base\org.eclipse.wst.common.project.facet.core.xml.svn-base

?????文件?????????49??2013-11-05?11:35??Hokilly_tuangou\.settings\.svn\text-base\org.eclipse.wst.jsdt.ui.superType.container.svn-base

?????文件??????????6??2013-11-05?11:35??Hokilly_tuangou\.settings\.svn\text-base\org.eclipse.wst.jsdt.ui.superType.name.svn-base

?????文件?????????99??2013-12-11?23:55??Hokilly_tuangou\.settings\com.genuitec.eclipse.j2eedt.core.xml

?????文件????????416??2013-12-12?14:14??Hokilly_tuangou\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2013-11-05?11:35??Hokilly_tuangou\.settings\org.eclipse.jdt.core.prefs

?????文件????????483??2013-11-05?11:35??Hokilly_tuangou\.settings\org.eclipse.wst.common.component

?????文件????????299??2013-12-11?23:55??Hokilly_tuangou\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2013-11-05?11:35??Hokilly_tuangou\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2013-11-05?11:35??Hokilly_tuangou\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????647??2013-11-06?13:56??Hokilly_tuangou\.svn\entries

?????文件????????934??2013-10-31?14:30??Hokilly_tuangou\.svn\text-base\.classpath.svn-base

?????文件????????318??2013-10-31?08:58??Hokilly_tuangou\.svn\text-base\.mymetadata.svn-base

?????文件???????1758??2013-10-31?08:58??Hokilly_tuangou\.svn\text-base\.project.svn-base

?????文件????????179??2013-11-06?13:56??Hokilly_tuangou\src\.svn\entries

?????文件????????183??2013-11-06?13:56??Hokilly_tuangou\src\com\.svn\entries

?????文件????????191??2013-11-06?13:56??Hokilly_tuangou\src\com\sxt\.svn\entries

?????文件????????256??2013-11-06?13:56??Hokilly_tuangou\src\com\sxt\tuangou\.svn\entries

?????文件???????1371??2013-11-06?13:56??Hokilly_tuangou\src\com\sxt\tuangou\dao\.svn\entries

?????文件???????2444??2013-11-05?19:12??Hokilly_tuangou\src\com\sxt\tuangou\dao\.svn\text-base\BackupDao.java.svn-base

?????文件???????3434??2013-11-05?11:34??Hokilly_tuangou\src\com\sxt\tuangou\dao\.svn\text-base\DBUtil.java.svn-base

............此處省略4453個文件信息