栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

MyBatis和Jdbc批量插入的性能对比示例

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

MyBatis和Jdbc批量插入的性能对比示例

还未详细分析MyBatis慢在哪里,先上小数据量对比图:

controller请求处理:

    @RequestMapping("/batch-insert-mybatis/{size}")
    @ResponseBody
    public String batchInsertUserInfoByMybatis(@PathVariable int size) {
        return userService.batchInsertUserByMybatis(size);
    }

    @RequestMapping("/batch-insert-jdbc/{size}")
    @ResponseBody
    public String batchInsertUserInfoByJdbc(@PathVariable int size) {
        return userService.batchInsertUserByJdbc(size);
    }

service处理:

    private final Log logger = LogFactory.getLog(getClass());

    @Autowired
    private UserMapper userMapper;

    @Autowired
    private UserJdbcDao userJdbcDao;

    public String batchInsertUserByMybatis(int size){
        List list = getUsers(size);
        long startTime = System.currentTimeMillis();
        userMapper.batchInsert(list);
        logger.info(" #####batchInsert "+size+" Users ByMybatis total time : "
                + (System.currentTimeMillis() - startTime) + " 毫秒 #####");
        return "SUCCESS";
    }

    public String batchInsertUserByJdbc(int size) {
        List list = getUsers(size);
        long startTime = System.currentTimeMillis();
        userJdbcDao.batchInsert(list);
        logger.info(" #####batchInsert "+size+" Users ByJdbc total time : "
                + (System.currentTimeMillis() - startTime) + " 毫秒 #####");
        return "SUCCESS";
    }

    private List getUsers(int size) {
        List list = new ArrayList<>();
        for (int i = 6; i < size; i++) {
            User user = new User();
            user.setName("who" + i);
            user.setAge(String.valueOf(i));
            user.setPassword("secret" + i);
            list.add(user);
        }
        return list;
    }

MyBatis示例:

public interface UserMapper {
    void batchInsert(List list);
}

    insert all
    
        into user1 (name, age,password) values (#{poi.name},  #{poi.age}, #{poi.password})
    
    SELECt * FROM dual

Jdbc示例

@Service
public class UserJdbcDao extends JdbcTemplate{
    @Resource(name="dataSource")
    public void init( DataSource dataSource) {
        super.setDataSource(dataSource);
    }

    public void batchInsert(List list) {
        String sql = " insert into user1 (name, age,password) values (?, ?, ?)";
        List batchArgs = new ArrayList();
        for (User poi : list) {
            Object[] args = {poi.getName(), poi.getAge(), poi.getPassword()};
            batchArgs.add(args);
        }
        batchUpdate(sql, batchArgs);
    }
}

然而,为什么MyBatis慢这么多,特别是首次执行的时候?

参考:

JDBC实现往MySQL插入百万级数据 - 酒香逢 - 博客园

MyBatis-spring和spring JDBC批量插入Mysql的效率比较-pudn.com

Mybatis与JDBC批量插入MySQL数据库性能测试及解决方案 - 竹马今安在 - 博客园

而且MyBatis参数不能超1千,否则报ORA-24335异常,如下:

2022-06-11 13:37:48.651  INFO 47544 --- [nio-8090-exec-7] o.s.b.f.xml.XmlBeanDefinitionReader      : Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
2022-06-11 13:37:48.702  INFO 47544 --- [nio-8090-exec-7] o.s.jdbc.support.SQLErrorCodesFactory    : SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase, Hana]
2022-06-11 13:37:48.719 ERROR 47544 --- [nio-8090-exec-7] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: 
### Error updating database.  Cause: java.sql.SQLException: ORA-24335: cannot support more than 1000 columns

### The error may involve cn.no7player.mapper.UserMapper.batchInsert-Inline
### The error occurred while setting parameters
### SQL: insert all                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)                into user1 (name, age,password) values (?,  ?, ?)           SELECt * FROM dual
### Cause: java.sql.SQLException: ORA-24335: cannot support more than 1000 columns

; uncategorized SQLException for SQL []; SQL state [99999]; error code [24335]; ORA-24335: cannot support more than 1000 columns
; nested exception is java.sql.SQLException: ORA-24335: cannot support more than 1000 columns
] with root cause

oracle.jdbc.OracleDatabaseException: ORA-24335: cannot support more than 1000 columns

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:910)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
	at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)
	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3887)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1079)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:44)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:69)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:48)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:105)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:71)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:152)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:141)
	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:498)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)
	at com.sun.proxy.$Proxy35.insert(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:240)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:51)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52)
	at com.sun.proxy.$Proxy57.batchInsert(Unknown Source)
	at cn.player.service.UserService.batchInsertUserByMybatis(UserService.java:36)
	at cn.player.controller.UserController.batchInsertUserInfoByMybatis(UserController.java:38)
	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:498)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:776)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:705)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:869)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.springframework.boot.actuate.autoconfigure.EndpointWebMvcAutoConfiguration$ApplicationContextHeaderFilter.doFilterInternal(EndpointWebMvcAutoConfiguration.java:295)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:102)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:85)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:68)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:668)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1521)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1478)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:750)

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/971078.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号