- Add the Codota plugin to your IDE and get smart completions
private void myMethod () {Connection c =
DataSource dataSource;dataSource.getConnection()
String url;DriverManager.getConnection(url)
IdentityDatabaseUtil.getDBConnection()
- Smart code suggestions by Codota
}
public void setDataSource(DataSource dataSource) { if (dataSource == null) { throw new NullPointerException("dataSource can't be null"); } setDataSourceFactory(new SimpleDataSourceFactory(dataSource)); }
@Override public Mango createMango() { try { Mango mango = Mango.newInstance(new SimpleDataSourceFactory(CronnerConstant.DB,buildDataSource())); this.mango = mango; return mango; } catch (Exception e) { logger.error("Init datasource error",e); throw e; } }
public static void main(String[] args) { String driverClassName = "com.mysql.jdbc.Driver"; String username = "root"; // 这里请使用您自己的用户名 String password = "root"; // 这里请使用您自己的密码 int dbNum = 3; List<DataSourceFactory> dsfs = new ArrayList<DataSourceFactory>(); for (int i = 0; i < dbNum; i++) { String name = "dsf" + i; String url = "jdbc:mysql://localhost:3306/db" + i; DataSource ds = new DriverManagerDataSource(driverClassName, url, username, password); DataSourceFactory dsf = new SimpleDataSourceFactory(name, ds); dsfs.add(dsf); } Mango mango = Mango.newInstance(dsfs); DatabaseShardingOrderDao orderDao = mango.create(DatabaseShardingOrderDao.class); List<Integer> uids = Lists.newArrayList(1, 2, 3, 4, 5); for (Integer uid : uids) { String id = RandomUtils.randomStringId(10); // 随机生成10位字符串ID Order order = new Order(); order.setId(id); order.setUid(uid); order.setPrice(100); order.setStatus(1); orderDao.addOrder(order); System.out.println(orderDao.getOrdersByUid(uid)); } }
public static void main(String[] args) { String driverClassName = "com.mysql.jdbc.Driver"; String username = "root"; // 这里请使用您自己的用户名 String password = "root"; // 这里请使用您自己的密码 int dbNum = 3; List<DataSourceFactory> dsfs = new ArrayList<DataSourceFactory>(); for (int i = 0; i < dbNum; i++) { String name = "dsf" + i; String url = "jdbc:mysql://localhost:3306/db" + i; DataSource ds = new DriverManagerDataSource(driverClassName, url, username, password); DataSourceFactory dsf = new SimpleDataSourceFactory(name, ds); dsfs.add(dsf); } Mango mango = Mango.newInstance(dsfs); SmartShardingOrderDao orderDao = mango.create(SmartShardingOrderDao.class); List<Integer> uids = Lists.newArrayList(1, 2, 3, 30001, 30002, 30003); for (Integer uid : uids) { String id = RandomUtils.randomStringId(10); // 随机生成10位字符串ID Order order = new Order(); order.setId(id); order.setUid(uid); order.setPrice(100); order.setStatus(1); orderDao.addOrder(order); System.out.println(orderDao.getOrdersByUid(uid)); } }
public static void main(String[] args) { String driverClassName = "com.mysql.jdbc.Driver"; String username = "root"; // 这里请使用您自己的用户名 String password = "root"; // 这里请使用您自己的密码 int dbNum = 3; List<DataSourceFactory> dsfs = new ArrayList<DataSourceFactory>(); for (int i = 0; i < dbNum; i++) { String name = "dsf" + i; String url = "jdbc:mysql://localhost:3306/db" + i; DataSource ds = new DriverManagerDataSource(driverClassName, url, username, password); DataSourceFactory dsf = new SimpleDataSourceFactory(name, ds); dsfs.add(dsf); } Mango mango = Mango.newInstance(dsfs); ShardingOrderDao orderDao = mango.create(ShardingOrderDao.class); List<Integer> uids = Lists.newArrayList(1, 2, 3, 30001, 30002, 30003); for (Integer uid : uids) { String id = RandomUtils.randomStringId(10); // 随机生成10位字符串ID Order order = new Order(); order.setId(id); order.setUid(uid); order.setPrice(100); order.setStatus(1); orderDao.addOrder(order); System.out.println(orderDao.getOrdersByUid(uid)); } }
String url = "jdbc:mysql://localhost:3306/db" + i; DataSource ds = new DriverManagerDataSource(driverClassName, url, username, password); DataSourceFactory dsf = new SimpleDataSourceFactory(name, ds); dsfs.add(dsf);
public static void main(String[] args) { String driverClassName = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql://localhost:3306/mango_example"; String username = "root"; // 这里请使用您自己的用户名 String password = "root"; // 这里请使用您自己的密码 DataSource datasource = new DriverManagerDataSource(driverClassName, url, username, password); DataSourceFactory dsf = new SimpleDataSourceFactory(datasource); Mango mango = Mango.newInstance(dsf); //Mango mango = Mango.newInstance(datasource); ArticleDao dao = mango.create(ArticleDao.class); Article article = new Article(); article.setUid(9527); article.setTitle("article_title"); article.setContent("article_content"); int id = dao.addArticle(article); System.out.println(dao.getArticle(id)); }
String url2 = "jdbc:mysql://localhost:3306/mango_example_db2"; DataSource datasource = new DriverManagerDataSource(driverClassName, url2, username, password); DataSourceFactory dsf2 = new SimpleDataSourceFactory(name2, datasource);