MysqlDataSource ds = new MysqlDataSource(); ds.setUrl(dbUrl); DBI dbi = new DBI(ds);
@Override public DataSource get() { MysqlDataSource mysqlds = new MysqlDataSource(); mysqlds.setUrl(prop.getProperty("urlConnection")); mysqlds.setUser(prop.getProperty("user")); mysqlds.setPassword(prop.getProperty("password")); return mysqlds; }
public class JavaApplication { private static final String DATABASE_URL = "jdbc:mysql://localhost/test?characterEncoding=utf8"; private static final String DATABASE_USER = "root"; private static final String DATABASE_PASSWORD = ""; private static Connection con; public static void main(String[] args) { try { Timestamp date = new Timestamp(System.currentTimeMillis()); MysqlDataSource ds = new MysqlDataSource(); ds.setUrl(DATABASE_URL); ds.setUser(DATABASE_USER); ds.setPassword(DATABASE_PASSWORD); con = ds.getConnection(); PreparedStatement ps = con.prepareStatement("INSERT INTO tablename (date) VALUES (?)"); ps.setTimestamp(1, date); ps.executeUpdate(); ps = con.prepareStatement("SELECT * FROM tablename"); ResultSet rs = ps.executeQuery(); while(rs.next()){ System.out.println("Date in database: "+rs.getTimestamp("date")); System.out.println("Time difference between server and database record in seconds: "+(rs.getTimestamp("date").getTime()-System.currentTimeMillis())/1000); } } catch (SQLException ex) { ex.printStackTrace(); } }
private void setProperties(MysqlDataSource ds, Properties properties) throws SQLException { Properties props = (Properties) properties.clone(); String url = (String) props.remove(DataSourceFactory.JDBC_URL); if (url != null) { ds.setUrl(url); } String databaseName = (String) props.remove(DataSourceFactory.JDBC_DATABASE_NAME); if (databaseName == null && url == null) { throw new SQLException("missing required property " + DataSourceFactory.JDBC_DATABASE_NAME); } ds.setDatabaseName(databaseName); String password = (String) props.remove(DataSourceFactory.JDBC_PASSWORD); ds.setPassword(password); String portNumber = (String) props.remove(DataSourceFactory.JDBC_PORT_NUMBER); if (portNumber != null) { ds.setPortNumber(Integer.parseInt(portNumber)); } String serverName = (String) props.remove(DataSourceFactory.JDBC_SERVER_NAME); ds.setServerName(serverName); String user = (String) props.remove(DataSourceFactory.JDBC_USER); ds.setUser(user); if (!props.isEmpty()) { BeanConfig.configure(ds, props); } }