1 package net.jaekl.squelch.stmt;
3 import java.io.IOException;
4 import java.io.PrintWriter;
5 import java.sql.Connection;
6 import java.sql.PreparedStatement;
7 import java.sql.ResultSet;
8 import java.sql.SQLException;
9 import java.util.Locale;
11 public class Select extends Query {
14 public boolean handles(String line) {
19 String s = line.trim().toUpperCase(Locale.CANADA);
20 return (s.startsWith("SELECT "));
24 public int exec(Connection conn, PrintWriter pw, String line) throws IOException, SQLException
28 try (PreparedStatement ps = conn.prepareStatement(line))
30 try (ResultSet rs = ps.executeQuery())
32 rowCount = printFormatted(pw, rs);
38 private int printFormatted(PrintWriter pw, ResultSet rs) throws IOException, SQLException
40 TabularResultSet trs = new TabularResultSet(rs);
41 int rowCount = trs.printTable(pw);