com.mysql.jdbc.jdbc2.optional.MysqlDataSource.setServerName()方法的使用及代码示例

x33g5p2x  于2022-01-25 转载在 其他  
字(6.7k)|赞(0)|评价(0)|浏览(149)

本文整理了Java中com.mysql.jdbc.jdbc2.optional.MysqlDataSource.setServerName()方法的一些代码示例,展示了MysqlDataSource.setServerName()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。MysqlDataSource.setServerName()方法的具体详情如下:
包路径:com.mysql.jdbc.jdbc2.optional.MysqlDataSource
类名称:MysqlDataSource
方法名:setServerName

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");

相关文章