本文整理了Java中com.mysql.jdbc.jdbc2.optional.MysqlDataSource.setServerName()
方法的一些代码示例,展示了MysqlDataSource.setServerName()
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。MysqlDataSource.setServerName()
方法的具体详情如下:
包路径:com.mysql.jdbc.jdbc2.optional.MysqlDataSource
类名称:MysqlDataSource
方法名:setServerName
暂无
代码示例来源:origin: stackoverflow.com
MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setUser("scott");
dataSource.setPassword("tiger");
dataSource.setServerName("myDBHost.example.org");
代码示例来源:origin: alibaba/nacos
dataSource.setLoginTimeout(1);
dataSource.setServerName(ip.getIp());
dataSource.setPort(ip.getPort());
代码示例来源:origin: stackoverflow.com
MysqlDataSource ds = new MysqlDataSource();
ds.setServerName("host");
ds.setUser("user");
ds.setPassword("password");
JdbcTemplate jdbcTemplate = new JdbcTemplate(ds);
BufferedReader in = new BufferedReader(new FileReader("script.sql"));
LineNumberReader fileReader = new LineNumberReader(in);
String query = JdbcTestUtils.readScript(fileReader);
代码示例来源:origin: stackoverflow.com
MysqlDataSource ds = new MysqlDataSource();
ds.setServerName("hostname");
ds.setUser("username");
ds.setPassword("password");
JdbcTemplate jdbcTemplate = new JdbcTemplate(ds);
BufferedReader in = new BufferedReader(new FileReader("script.sql"));
LineNumberReader fileReader = new LineNumberReader(in);
String query = JdbcTestUtils.readScript(fileReader);
代码示例来源:origin: stackoverflow.com
MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setUser("scott");
dataSource.setPassword("tiger");
dataSource.setServerName("myDatabaseHost.example.org");
and then obtain connections from it, same as above:
Connection conn = dataSource.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT ID FROM USERS");
...
rs.close();
stmt.close();
conn.close();
代码示例来源:origin: stackoverflow.com
MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setUser(user);
dataSource.setPassword(password);
dataSource.setServerName(server);
dataSource.setDatabaseName(database);
Connection conn = dataSource.getConnection();
PreparedStatement stmt = conn.prepareStatement("INSERT INTO table (name, grade, age) VALUES (?, ?, ?)");
...then while going throug the XML:
stmt.setString(1, name);
stmt.setString(2, grade);
stmt.setString(3, age);
stmt.execute();
...at the end:
stmt.close();
conn.commit();
conn.close()
代码示例来源:origin: ops4j/org.ops4j.pax.jdbc
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);
}
}
代码示例来源:origin: stackoverflow.com
MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setDatabaseName("xyz");
dataSource.setUser("xyz");
dataSource.setPassword("xyz");
dataSource.setServerName("xyz.yourdomain.com");
代码示例来源:origin: stackoverflow.com
import com.mysql.jdbc.jdbc2.optional.MysqlDataSource;
public class SignalDB {
private static MysqlDataSource ds = null;
public static MysqlDataSource getDataSource(String db_name) {
if (ds == null) {
// db variables set here
getDataSource(db_url, db_user, db_password, db_port);
}
ds.setDatabaseName(db_name);
return ds;
}
private static void getDataSource(String db_url, String db_user, String db_password, int db_port) {
try {
ds = new MysqlDataSource();
ds.setServerName(db_url);
ds.setUser(db_user);
ds.setPassword(db_password);
ds.setPort(db_port);
} catch (Exception e) {
System.out.println("MysqlDataSource err: " + e.getMessage());
e.printStackTrace();
}
}
}
代码示例来源:origin: stackoverflow.com
MysqlDataSource ds = new MysqlDataSource();
ds.setServerName(serverName);
ds.setDatabaseName(mydatabase);
ds.setUser(username);
ds.setPassword(password);
connection = ds.getConnection();
代码示例来源:origin: stackoverflow.com
MysqlDataSource ds = new MysqlDataSource();
ds.setDatabaseName("DATABASE");
ds.setUser("USERNAME");
ds.setPassword("USER PASSWORD");
ds.setServerName("localhost");
ds.setPort(3306);
connection = ds.getConnection();
代码示例来源:origin: stackoverflow.com
MysqlDataSource ds = new MysqlDataSource();
ds.setServerName("localhost");
ds.setPort("3306");
ds.setDatabaseName("testdb");
ds.setUser("root");
ds.setPassword("");
Connection connection = ds.getConnection();
代码示例来源:origin: stackoverflow.com
MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setServerName("localhost");
dataSource.setDatabaseName("inventry");
dataSource.setPortNumber(3306);
dataSource.setUser("root");
dataSource.setPassword(""); // blank password is a terrible idea
Connection connection = dataSource.getConnection();
代码示例来源:origin: games647/LagMonitor
public Storage(Logger logger, String host, int port, String database, boolean usessl, String user, String pass, String prefix) {
this.logger = logger;
this.prefix = prefix;
this.dataSource = new MysqlDataSource();
this.dataSource.setUser(user);
this.dataSource.setPassword(pass);
this.dataSource.setServerName(host);
this.dataSource.setPort(port);
this.dataSource.setDatabaseName(database);
this.dataSource.setUseSSL(usessl);
}
代码示例来源:origin: stackoverflow.com
public class MySqlConnect {
public static Connection connectToDB() {
try {
MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setServerName("localhost");
dataSource.setDatabaseName("auto_lube");
dataSource.setPortNumber(3306);
dataSource.setUser("root");
dataSource.setPassword("mehar");
Connection conn = dataSource.getConnection();
JOptionPane.showMessageDialog(null, "Connection established"); // better log this message
return conn;
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e); // better log the exception
return null;
}
}
}
代码示例来源:origin: stackoverflow.com
mysqlDS.setTrustCertificateKeyStorePassword("truststore-pw");
mysqlDS.setServerName("server");
mysqlDS.setPort(3306);
mysqlDS.setDatabaseName("databasename");
内容来源于网络,如有侵权,请联系作者删除!