spring + SQLite在多线程应用程序中

使用Spring框架和SQLite数据库在多线程应用程序中进行开发，可以提供高效、稳定的解决方案。Spring框架是一个开源的Java应用程序框架，它提供了丰富的功能和模块，可以简化开发过程，提高开发效率。SQLite是一种轻量级的嵌入式数据库，它适用于小型应用程序和移动设备。

    
        org.springframework
        spring-context
        5.3.10
    
    
        org.xerial
        sqlite-jdbc
        3.34.0
    

@Repository
public class UserDao {
    @Autowired
    private DataSource dataSource;
    public void save(User user) {
        String sql = "INSERT INTO users (id, name) VALUES (?, ?)";
        try (Connection conn = dataSource.getConnection();
             PreparedStatement pstmt = conn.prepareStatement(sql)) {
            pstmt.setInt(1, user.getId());
            pstmt.setString(2, user.getName());
            pstmt.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

public class MultiThreadApp {
    public static void main(String[] args) {
        ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
        UserDao userDao = context.getBean(UserDao.class);
        ExecutorService executorService = Executors.newFixedThreadPool(10);
        for (int i = 1; i <= 100; i++) {
            int id = i;
            String name = "User" + i;
            executorService.execute(() -> {
                User user = new User(id, name);
                userDao.save(user);
            });
        }
        executorService.shutdown();
        try {
            executorService.awaitTermination(Long.MAX_VALUE, TimeUnit.NANOSECONDS);
        } catch (InterruptedException e) {
            e.printStackTrace();
        }
    }
}