/** Display the file in the text area */
private void showFile() {
Scanner input = null;
try {
// Use a Scanner to read text from the file
input = new Scanner(new File(jtfFilename.getText().trim()));
// Read a line and append the line to the text area
while (input.hasNext()) jtaFile.append(input.nextLine() + '\n');
} catch (FileNotFoundException ex) {
System.out.println("File not found: " + jtfFilename.getText());
} catch (IOException ex) {
ex.printStackTrace();
} finally {
if (input != null) input.close();
}
}
public static void main(String[] args) throws Exception {
File f = new File(inputFile);
if (f.exists()) {
Scanner input = new Scanner(f);
String credentials = input.nextLine();
input.close();
String uname = credentials.split(",")[0].split("=")[1];
String pword = credentials.split(",")[1].split("=")[1];
con = connectToDb(uname, pword);
if (con != null) {
System.out.println("Connected to Database:" + con);
loadData(uname, pword);
task1();
task2();
task3();
task4();
con.close();
} else System.out.println("Connection Error");
} else System.out.println("Input file system.in not found");
}
public static void main(String args[]) throws IOException {
try {
Scanner in = args.length == 0 ? new Scanner(System.in) : new Scanner(Paths.get(args[0]));
try (Connection conn = getConnection()) {
Statement stat = conn.createStatement();
while (true) {
if (args.length == 0) System.out.println("Enter command or EXIT to exit:");
if (!in.hasNextLine()) return;
String line = in.nextLine();
if (line.equalsIgnoreCase("EXIT")) return;
if (line.trim().endsWith(";")) // remove trailing semicolon
{
line = line.trim();
line = line.substring(0, line.length() - 1);
}
try {
boolean isResult = stat.execute(line);
if (isResult) {
ResultSet rs = stat.getResultSet();
showResultSet(rs);
} else {
int updateCount = stat.getUpdateCount();
System.out.println(updateCount + " rows updated");
}
} catch (SQLException ex) {
for (Throwable e : ex) e.printStackTrace();
}
}
}
} catch (SQLException e) {
for (Throwable t : e) t.printStackTrace();
}
}
private void insertRows(Connection connection) {
// Build the SQL INSERT statement
String sqlInsert = "insert into " + jtfTableName.getText() + " values (";
// Use a Scanner to read text from the file
Scanner input = null;
// Get file name from the text field
String filename = jtfFilename.getText().trim();
try {
// Create a scanner
input = new Scanner(new File(filename));
// Create a statement
Statement statement = connection.createStatement();
System.out.println(
"Driver major version? " + connection.getMetaData().getDriverMajorVersion());
// Determine if batchUpdatesSupported is supported
boolean batchUpdatesSupported = false;
try {
if (connection.getMetaData().supportsBatchUpdates()) {
batchUpdatesSupported = true;
System.out.println("batch updates supported");
} else {
System.out.println(
"The driver is of JDBC 2 type, but " + "does not support batch updates");
}
} catch (UnsupportedOperationException ex) {
System.out.println("The driver does not support JDBC 2");
}
// Determine if the driver is capable of batch updates
if (batchUpdatesSupported) {
// Read a line and add the insert table command to the batch
while (input.hasNext()) {
statement.addBatch(sqlInsert + input.nextLine() + ")");
}
statement.executeBatch();
jlblStatus.setText("Batch updates completed");
} else {
// Read a line and execute insert table command
while (input.hasNext()) {
statement.executeUpdate(sqlInsert + input.nextLine() + ")");
}
jlblStatus.setText("Single row update completed");
}
} catch (SQLException ex) {
System.out.println(ex);
} catch (FileNotFoundException ex) {
System.out.println("File not found: " + filename);
} catch (IOException ex) {
ex.printStackTrace();
} finally {
if (input != null) input.close();
}
}
