import net.sourceforge.jtds.jdbcx.JtdsDataSource;
JtdsDataSource dataSource = new JtdsDataSource();
dataSource.setUrl("jdbc:jtds:sqlserver://localhost:1433/MyDatabase");
dataSource.setUser("username");
dataSource.setPassword("password");
Connection connection = dataSource.getConnection();
...
Statement statement = connection.createStatement();
statement.addBatch("INSERT INTO MyTable (Column1, Column2) VALUES (Value1, Value2)");
statement.addBatch("INSERT INTO MyTable (Column1, Column2) VALUES (Value3, Value4)");
statement.addBatch("INSERT INTO MyTable (Column1, Column2) VALUES (Value5, Value6)");
statement.executeBatch();
Statement statement = connection.createStatement();
statement.executeUpdate("CREATE INDEX idx_column1 ON MyTable (Column1)");
PreparedStatement preparedStatement = connection.prepareStatement("SELECT * FROM MyTable WHERE Column1 = ?");
ResultSet resultSet = preparedStatement.executeQuery();
...
