mysql如何实现批量删除_mysql+servlet+ajax实现批量删除功能

1.数据连接池采用c3p0,配置如下

com.mysql.jdbc.Driver

jdbc:mysql://localhost:3306/manager

root

root

1.1.获得c3p0数据连接池的数据源

public classComboPooledDataSourceUtil {//无参构造硬编码(配置这个后无需配置xml)

public static DataSource getDataSource() throwsPropertyVetoException {

ComboPooledDataSource dataSource=newComboPooledDataSource();

dataSource.setDriverClass("com.mysql.jdbc.Driver");

dataSource.setJdbcUrl("jdbc:mysql://localhost:3306/manager");

dataSource.setUser("root");

dataSource.setPassword("root");returndataSource;

}//xml编码

public staticDataSource getDataSourceByxml(){

ComboPooledDataSource cpds=new ComboPooledDataSource("c3p0");returncpds;

}

}

2. dao层采用dbutils工具类操作数据库语句

@Overridepublic Integer delmany(Integer[] ids) throwsSQLException {

String sql= "delete from `grade` where gradeId=?";int n=0;for (int i = 0; i

n=queryRunner.update(sql, ids[i]);

}returnn;

}

3.jsonresult类,向页面输送json格式数据,用于ajax

public classJsonResult {private intcode;privateString msg;privateObject data;publicJsonResult() {super();

}public JsonResult(intcode) {this.code =code;

}publ