public static void main(String args[]) {
try {
// Step 2: load driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
// Step 3: define the connection URL
String url = "jdbc:odbc:personDSN";
// Step 4: establish the connection
Connection con = DriverManager.getConnection(url);
// Step 5: create PrepareStatement by passing sql and
// ResultSet appropriate fields
String sql = "SELECT * FROM Person";
PreparedStatement pStmt =
con.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
// Step 6: execute the query
ResultSet rs = pStmt.executeQuery();
// moving cursor to insert row
rs.moveToInsertRow();
// updating values in insert row
rs.updateString("Name", "imitiaz");
rs.updateString("Address", "cantt");
rs.updateString("phoneNum", "9201211");
// inserting row in resultset & into database
rs.insertRow();
// Step 8: close the connection
con.close();
} catch (Exception sqlEx) {
System.out.println(sqlEx);
}
} // end main
public void addToDb(Contact c, Connection con) {
try (Statement s = con.createStatement();
ResultSet resultSet = s.executeQuery("SELECT * FROM contact")) {
resultSet.moveToInsertRow();
resultSet.updateInt("ID", c.getId());
resultSet.updateString("name", c.getName());
if (c.getClass().getName().equals("jdbase.model.Person"))
resultSet.updateString("surname", ((Person) c).getSurname);
else resultSet.updateString("surname", " ---- ");
resultSet.updateString("email", c.getEmail());
resultSet.updateString("phoneNumber", c.getPhoneNumber());
resultSet.insertRow();
System.out.println(" After adding :");
System.out.println("ID \tfName \tsurname \temail \t\tphoneNo");
while (resultSet.next()) {
System.out.println(
resultSet.getInt("id")
+ "\t"
+ resultSet.getString("name")
+ "t\""
+ resultSet.getString("surname")
+ "t\""
+ resultSet.getString("email")
+ "t\""
+ resultSet.getString("phoneNumber"));
}
} catch (SQLException e) {
e.printStackTrace();
}
}
/**
* Helper function intended to be overwritten by subclasses. Thsi is where the real requiest for
* IDs happens
*/
protected void performIDRequest() throws Exception {
Connection dbConnection = null;
try {
try {
dbConnection = dataSource.getConnection();
Statement stmt =
dbConnection.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE);
ResultSet set = null;
set =
stmt.executeQuery(
"SELECT id, " + dbColumn + " FROM " + dbTable); // $NON-NLS-1$ //$NON-NLS-2$
if (!set.next()) {
set.moveToInsertRow();
set.insertRow();
set.updateLong(dbColumn, NUM_IDS_GRABBED);
set.moveToCurrentRow();
set.next();
}
long nextID = set.getLong(dbColumn);
long upTo = nextID + mCacheQuantity;
set.updateLong(dbColumn, upTo);
set.updateRow();
stmt.close();
setMaxAllowedID(upTo);
setNextID(nextID);
} finally {
if (dbConnection != null) {
dbConnection.close();
}
}
} catch (SQLException e) {
throw new NoMoreIDsException(e);
}
}
protected void index(ResultSet rs, ILinguist linguist, long sid, String sent)
throws LoadException {
if (rs == null) throw new LoadException("Index ResultSet null");
try {
// System.out.println(sent);
String[] words = linguist.indexkeys(sent);
if (words.length > 0) {
Map<String, String> dup = new HashMap<String, String>();
int i = 0;
for (String word : words) {
// System.out.print(word+" ");
if (!dup.containsKey(word)) {
dup.put(word, word);
rs.moveToInsertRow();
rs.updateString("F_Word", word);
rs.updateLong("F_SID", sid);
rs.updateInt("F_Offset", i++);
rs.insertRow();
}
}
// System.out.println();
}
} catch (SQLException se) {
throw new LoadException("SQLException occurred: " + se.getMessage());
} catch (LanguageException le) {
throw new LoadException("LanguageException occurred indexing: " + le.getMessage());
}
}
public static void main(String[] args) {
Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;
// note that we're doing this the old way - without a try-with-resources block
try {
// make a connection to the database
connection = DriverManager.getConnection(URL + DATABASE, USER, PASSWORD);
// ensure that we're using transactions
connection.setAutoCommit(false);
// create a statement object. make sure the resultset is updateable
statement =
connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
// execute the query
resultSet = statement.executeQuery("SELECT * FROM Person");
// prepare to insert a row into the resultset. recall that the resultset can also be used for
// updates
resultSet.moveToInsertRow();
resultSet.updateString("name", "Austin");
resultSet.updateInt("age", 87);
// insert the row
resultSet.insertRow();
// commit the transaction
connection.commit();
} catch (SQLException sqle) {
// rollback the transaction
try {
connection.rollback();
} catch (SQLException sqle2) {
sqle2.printStackTrace();
System.out.println("Transaction was rolled back!");
}
} finally {
// close the resources
try {
if (connection != null) connection.close();
if (statement != null) statement.close();
if (resultSet != null) resultSet.close();
} catch (SQLException sqle3) {
}
}
}
public Boolean begin_new_record(String table) {
try {
Statement s =
connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
s.execute("Select * From " + table + " Where " + table + "_id = 0");
if (results != null) results.close();
results = s.getResultSet();
results.moveToInsertRow();
current_table = table;
error = false;
return true;
} catch (Exception ex) {
throw new InvalidQueryException("Database update failed");
}
}
