`
k010010001
  • 浏览: 7851 次
社区版块
存档分类
最新评论

java 批量删除多张表数据

 
阅读更多
public String deleteMore(String... a) {
		// TODO Auto-generated method stub
		String return_code = "0000";
		Statement st=null;
		String sql = "";
		Connection con=null;
		try {
			con=JdbcManager.getMySqlConnection();
			st=con.createStatement();
			for (String str : a) {
				sql="delete from "+str;
				st.addBatch(sql);
			}
			st.executeBatch();
		} catch (Exception e) {
			return_code = "1111";
			e.printStackTrace();
		} finally {
			DataSourceUtils.closeStatement(st);
		}
		return return_code;
	}

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics