SQLServerDataSource dataSource = new SQLServerDataSource(); dataSource.setUser("aUser"); dataSource.setPassword("password"); dataSource.setServerName("hostname"); dataSource.setDatabaseName("db");
String url = "jdbc:sqlserver://...."; SQLServerDataSource sqls = new SQLServerDataSource(); sqls.setURL(url); sqls.getConnection(); CallableStatement callStatement = sqls.getConnection().prepareCall("{? = CALL DB.dbo.f_promedio(?,?)}"); callStatement.setDouble(2, 1.8); callStatement.setDouble(3, 6.8); callStatement.registerOutParameter(1, java.sql.Types.DECIMAL); callStatement.execute(); double d = callStatement.getDouble(1);
@Override public DataSource dataSource() { SQLServerDataSource dataSource = new SQLServerDataSource(); dataSource.setURL( "jdbc:sqlserver://localhost;instance=SQLEXPRESS;" + "databaseName=high_performance_java_persistence;" ); dataSource.setUser("sa"); dataSource.setPassword("adm1n"); return dataSource; }
List<String> listOfStatements = new ArrayList<String>(); Connection connection = new SQLServerDataSource().getConnection(); Statement statement = connection.createStatement(); connection.setAutoCommit(false); for(String query : listOfStatements) { statement.executeUpdate(query); } connection.commit(); connection.setAutoCommit(true); connection.close();
@Override public DataSource dataSource() { SQLServerDataSource dataSource = (SQLServerDataSource) super.dataSource(); dataSource.setStatementPoolingCacheSize(cacheSize); if (cacheSize > 0) { dataSource.setDisableStatementPooling(false); } return dataSource; }
public static boolean getConnection() { try { System.out.println(ServerName); ds = new SQLServerDataSource(); ds.setServerName(ServerName); ds.setPortNumber(1433); ds.setDatabaseName(DatabaseName); ds.setUser(UserName); ds.setPassword(Password); con = ds.getConnection(); if (con != null) { System.out.println("Success"); } stmt = con.createStatement(); return true; } // Handle any errors that may have occurred. catch (Exception e) { System.out.println(e.getMessage()); return false; } }
SQLServerDataSource sql = new SQLServerDataSource(); sql.setServerName("Your SQL server name"); sql.setUser("sa"); sql.setPassword("your password"); sql.setPortNumber(1433); // Make sure this port is open sql.setDatabaseName("Your database name");
SQLServerDataSource ds = new SQLServerDataSource(); ds.setUser(dbUserID); ds.setPassword(Password); ds.setServerName(DBServer); ds.setPortNumber(1433); ds.setDatabaseName(dbName); con = (SQLServerConnection) ds.getConnection(); Statement statement = con.createStatement(); rs = statement.executeQuery(SQL);