jtopenlite.com.ibm.jtopenlite.samples.RunSqlSSL Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of jt400-jdk8 Show documentation
Show all versions of jt400-jdk8 Show documentation
The Open Source version of the IBM Toolbox for Java
package com.ibm.jtopenlite.samples;
import java.sql.*;
import java.util.Properties;
import java.io.*;
import javax.net.ssl.SSLSocketFactory;
/**
* Sample class to run sql statements
*/
public class RunSqlSSL {
public final static String PROMPT="ENTER SQL STATEMENT or exit > ";
public static void main(String[] args) {
try {
Class.forName("com.ibm.jtopenlite.database.jdbc.JDBCDriver");
String url = args[0];
String userid = args[1];
String password = args[2];
Properties props = new Properties();
props.setProperty("user", userid);
props.setProperty("password", password);
props.setProperty("secure", "true"); // this argument tells the JDBC driver to use SSL
Connection connection = DriverManager.getConnection(url, props);
Statement statement = connection.createStatement();
BufferedReader reader = new BufferedReader(new InputStreamReader(System.in));
System.out.print(PROMPT);
String line = reader.readLine();
if (line != null) line = line.trim();
while ((line != null) && ! line.equalsIgnoreCase("exit") ) {
try {
boolean results = statement.execute(line);
if (results) {
ResultSet rs = statement.getResultSet();
ResultSetMetaData rsmd = rs.getMetaData();
int columnCount = rsmd.getColumnCount();
StringBuffer sb = new StringBuffer();
while (rs.next()) {
sb.setLength(0);
sb.append(rs.getString(1));
for (int column = 2; column <= columnCount; column++) {
sb.append(",");
sb.append(rs.getString(column));
}
System.out.println(sb.toString());
}
}
} catch (SQLException sqlex) {
System.out.println("SQLException caught");
System.out.println(sqlex.toString());
}
System.out.print(PROMPT);
line = reader.readLine();
if (line != null) line = line.trim();
}
} catch (Exception e) {
System.out.println("Fatal error occurred");
e.printStackTrace(System.out);
System.out.println("Usage: java com.ibm.jtopenlite.samples.RunSql JDBCURL USERID PASSWORD");
}
}
}