public void setValueAt(Object value, int row, int col) { // are you editing?
/*prepare the query*/
/*you have to change the query to adapt it to your table*/
if (col == 0) kolon = "english";
if (col == 1) kolon = "turkish";
String s =
"update soz set "
+ kolon
+ " = '"
+ (String) value
+ "' where "
+ kolon
+ " = '"
+ ((String[]) cache.elementAt(row))[col]
+ "'";
System.out.println(s);
/*excecute the query*/
try {
statement.execute(s);
} catch (Exception e) {
System.out.println("Could not updated");
}
((String[]) cache.elementAt(row))[col] = (String) value;
fireTableCellUpdated(row, col); // also update the table
}
/** Method declaration Adjust this method for large strings...ie multi megabtypes. */
void execute() {
String sCmd = null;
if (4096 <= ifHuge.length()) {
sCmd = ifHuge;
} else {
sCmd = txtCommand.getText();
}
if (sCmd.startsWith("-->>>TEST<<<--")) {
testPerformance();
return;
}
String g[] = new String[1];
lTime = System.currentTimeMillis();
try {
sStatement.execute(sCmd);
lTime = System.currentTimeMillis() - lTime;
int r = sStatement.getUpdateCount();
if (r == -1) {
formatResultSet(sStatement.getResultSet());
} else {
g[0] = "update count";
gResult.setHead(g);
g[0] = String.valueOf(r);
gResult.addRow(g);
}
addToRecent(txtCommand.getText());
} catch (SQLException e) {
lTime = System.currentTimeMillis() - lTime;
g[0] = "SQL Error";
gResult.setHead(g);
String s = e.getMessage();
s += " / Error Code: " + e.getErrorCode();
s += " / State: " + e.getSQLState();
g[0] = s;
gResult.addRow(g);
}
updateResult();
System.gc();
}
public boolean isValidUser() throws SQLException {
CreateJDBCConnection jdbc = new CreateJDBCConnection();
Statement stmt = jdbc.getStatement();
stmt.execute("use jana;");
String sqlQuery =
"select password from user_details where idno = '" + nameText.getText() + "';";
ResultSet rs = stmt.executeQuery(sqlQuery);
while (rs.next()) {
if (rs.getString("password").equals(passText.getText())) return true;
}
return false;
}
/**
* _more_
*
* @param sql _more_
* @return _more_
* @throws SQLException _more_
*/
private Statement evaluate(String sql) throws SQLException {
System.err.println("EVAL: " + sql);
Statement stmt = getConnection().createStatement();
stmt.execute(sql);
return stmt;
}