Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function readFromTable() {
- var address = '91.134.124.240:3306';
- var user = 'wachumb1_test';
- var userPwd = 'skola123';
- var db = 'wachumb1_test';
- var dbUrl = 'jdbc:mysql://' + address + '/' + db;
- var conn = Jdbc.getConnection(dbUrl, user, userPwd);
- var start = new Date();
- var stmt = conn.createStatement();
- stmt.setMaxRows(1000);
- var results = stmt.executeQuery('SELECT * FROM skola');
- var numCols = results.getMetaData().getColumnCount();
- while (results.next()) {
- var rowString = '';
- for (var col = 0; col < numCols; col++) {
- rowString += results.getString(col + 1) + '\t';
- }
- Logger.log(rowString)
- }
- results.close();
- stmt.close();
- var end = new Date();
- Logger.log('Time elapsed: %sms', end - start);
- function writeOneRecord() {
- var conn = Jdbc.getConnection(dbUrl, user, userPwd);
- var stmt = conn.prepareStatement('INSERT INTO skola '
- + '(text) values ("sutko je gay")');
- stmt.execute();
- }
- writeOneRecord()
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement