@Bean @Qualifier("Runelite Cache SQL2O") public Sql2o sql2o(DataSource dataSource) { Map<Class, Converter> converters = new HashMap<>(); converters.put(Instant.class, new InstantConverter()); return new Sql2o(dataSource, new NoQuirks(converters)); }
@Override public Sql2o get() { return new Sql2o(dataSource, quirks); } }
/** * 初始化数据库配置 * @param dataSource */ public static void init(DataSource dataSource){ sql2o = new Sql2o(dataSource); }
/** * 初始化数据库配置 * @param url * @param user * @param pass */ public static void init(String url, String user, String pass){ sql2o = new Sql2o(url, user, pass); }
Sql2o sql2o = new Sql2o("jdbc:sqlite:test.db", null, null);
@Bean Sql2o sql2o(DataSource dataSource) { return new Sql2o(dataSource); } }
public static void open(String driver,String url ,String username,String password){ try { Class.forName(driver); sql2o = new Sql2o(url,username,password); } catch (ClassNotFoundException e) { e.printStackTrace(); } }
/** * Create anima with url and db info * * @param url jdbc url * @param user database username * @param pass database password * @param quirks DBQuirks * @return Anima */ public static Anima open(String url, String user, String pass, Quirks quirks) { return open(new Sql2o(url, user, pass, quirks)); }
/** * Create anima with datasource * * @param dataSource datasource instance * @return Anima */ public static Anima open(DataSource dataSource) { return open(new Sql2o(dataSource)); }
/** * Create anima with datasource and quirks * * @param dataSource datasource instance * @return Anima */ public static Anima open(DataSource dataSource, Quirks quirks) { return open(new Sql2o(dataSource, quirks)); }
public static Sql2o open(DataSource dataSource) { sql2o = new Sql2o(dataSource); initSql2o(); return sql2o; }
public static Sql2o open(String url, String user, String password) { sql2o = new Sql2o(url, user, password); initSql2o(); return sql2o; }
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String DB_URL = "jdbc:mysql://localhost:3306/salesteam"; String USER = "root"; String PASS = "1234 "; Sql2o sql2o = new Sql2o(DB_URL, USER, PASS); String sql = "SELECT empID, fName " + "FROM salesteam " + "WHERE empID = 1"; List<Person> people; try (Connection con = sql2o.open()){ people = con.createQuery(sql).executeAndFetch(Person.class); } // code to generate json here... }
private DBConnections(String dbUrl) { this.dbUrl = dbUrl; if (dbUrl == null) { dbUrl = Configuration.getInstance().getDBUrl().orElse("jdbc:sqlite:data.db"); } HikariDataSource dataSource = new HikariDataSource(); dataSource.setMaximumPoolSize(Configuration.getInstance().getDBConnections()); dataSource.setJdbcUrl(dbUrl); database = new Sql2o(dataSource); }
Sql2o sql2o = new Sql2o("jdbc:postgresql://" + options.dbHost + ":" + options.dbPort + "/" + options.database, options.dbUsername, options.dbPassword, new PostgresQuirks() {
@Override public void preHandle(Blade blade) { Ioc ioc = blade.ioc(); boolean devMode = true; if (blade.environment().hasKey("app.dev")) { devMode = blade.environment().getBoolean("app.dev", true); } if (blade.environment().hasKey("app.devMode")) { devMode = blade.environment().getBoolean("app.devMode", true); } SqliteJdbc.importSql(devMode); Sql2o sql2o = new Sql2o(SqliteJdbc.DB_SRC, null, null); Base.open(sql2o); Commons.setSiteService(ioc.getBean(SiteService.class)); }