批量执行sql

最新推荐文章于 2023-10-24 08:51:52 发布

月下独影灬

最新推荐文章于 2023-10-24 08:51:52 发布

阅读量596

点赞数

文章标签： sql 数据库 database

本文链接：https://blog.csdn.net/Lxd2121/article/details/121224057

版权

获取session
private JdbcSession getJdbcSession() {
    	PersistenceManager manager = null;
    	JdbcSession session = null;
    	try {
    		manager = PersistenceManager.getInstance(getds());
    	} catch (DbException e) {
            Log.getInstance(this.getClass()).error(e.getMessage());
            Log.getInstance(this.getClass()).error(e);
    	}
    	session= manager.getJdbcSession();
    	
    	return session;
    }
    private String getds(){	
    	return InvocationInfoProxy.getInstance().getUserDataSource();
    }

    private Connection getConnection(){
    	JdbcSession session = getJdbcSession();
    	return session.getConnection();
    }

//执行方法
String sql = "update bd_deptdoc set dept_code =‘aaa’ where dept_code=‘bbb’"; 
JdbcSession session = getJdbcSession();
session.addBatch(sql); //添加需要执行的同构SQL
int rows = session.executeBatch(); //执行