mysql删完数据后表打不开_程序删除数据库的表，运行后表删除了为什么还报异常？...

publicvoiddeleteNullTitleTable()throwsException{DatedNow=newDate();//当前时间DatedBefore=newDate();Calendarcalendar=Calendar.getInstance();//得到日历calendar.setTime(dNow...

public void deleteNullTitleTable()throws Exception{

Date dNow = new Date(); //当前时间

Date dBefore = new Date();

Calendar calendar = Calendar.getInstance(); //得到日历

calendar.setTime(dNow);//把当前时间赋给日历

calendar.add(Calendar.DAY_OF_MONTH, -2); //设置为前一天

dBefore = calendar.getTime(); //得到前一天的时间

SimpleDateFormat sdf2 = new SimpleDateFormat("yyyyMMdd");

defaultStartDate2 = sdf2.format(dBefore);

Connection conn = null;

try {

conn = DBUtil.getConnection();

Statement st = conn.createStatement();

int num = 1;

for(int i=0;i<10;i++){

String a = String.valueOf(num);

String sql ="DROP TABLE null_title_log_"+defaultStartDate2;

num = Integer.parseInt(a);

num++;

st.executeUpdate(sql);

}

st.close();

System.out.println("删除空标题表成功");

}catch (Exception e){

e.printStackTrace();

}finally{

DBUtil.close(conn);

}

}

报异常

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'bullbat-dmp.null_title_log_20151221'

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:408)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:389)

at com.mysql.jdbc.Util.getInstance(Util.java:372)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2531)

at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1618)

at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1549)

at com.adtime.bullbat.dmp.client.daoImpl.NullTitleDaoImpl.deleteNullTitleTable(NullTitleDaoImpl.java:208)

at com.adtime.bullbat.dmp.client.daoImpl.NullTitleDaoImpl.main(NullTitleDaoImpl.java:51)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:483)

at com.intellij.rt.execution.application.AppMain.main(AppMain.java:134)

展开