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();
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; } }
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);
SQLServerDataSource dataSource = new SQLServerDataSource(); dataSource.setUser("aUser"); dataSource.setPassword("password"); dataSource.setServerName("hostname"); dataSource.setDatabaseName("db");
SQLServerDataSource ds = new SQLServerDataSource(); ds.setUser(dbUserID); ds.setPassword(Password);
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");
@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; }