| | |
|---|
| | | }
|
|---|
| | | return number;
|
|---|
| | | }
|
|---|
| | | |
|---|
| | | //查询具体某张表是否已经完成备份
|
|---|
| | | public boolean serchTable_en(Object obj){
|
|---|
| | | Database_backup baseup=(Database_backup) obj;
|
|---|
| | | boolean bl=false;
|
|---|
| | | String sql="select backup_en from web_site.tb_database_backup " +
|
|---|
| | | " where database_name=? and table_name=? limit 1 ";
|
|---|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{baseup.getDatabase_name(),baseup.getTable_name()}, new CallBack() {
|
|---|
| | | |
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | | List list=new ArrayList();
|
|---|
| | | try {
|
|---|
| | | while(rs.next()){
|
|---|
| | | list.add(rs.getInt("backup_en"));
|
|---|
| | | }
|
|---|
| | | } catch (SQLException e) {
|
|---|
| | | // TODO Auto-generated catch block
|
|---|
| | | e.printStackTrace();
|
|---|
| | | }
|
|---|
| | | return list;
|
|---|
| | | }
|
|---|
| | | });
|
|---|
| | | if(list!=null&&list.size()>0){
|
|---|
| | | int backup_en=(Integer) list.get(list.size()-1);
|
|---|
| | | if (backup_en==2) {
|
|---|
| | | bl=true;
|
|---|
| | | } else {
|
|---|
| | | bl=false;
|
|---|
| | | }
|
|---|
| | | }
|
|---|
| | | return bl;
|
|---|
| | | }
|
|---|
| | | public List serchByInfo(Object obj) {
|
|---|
| | | // TODO Auto-generated method stub
|
|---|
| | | return null;
|
|---|
