更新的例子:
String sqlStr = "insert into flow_flowmodel values(id,name,code) ";
DBTransaction db = this.getDBTransaction();
PreparedStatement st = db.createPreparedStatement(sqlStr, 0);
try {
st.executeUpdate();
db.commit();
st.close();
} catch (SQLException e) {
e.printStackTrace();
String sqlStr = "insert into flow_flowmodel values(id,name,code) ";
DBTransaction db = this.getDBTransaction();
PreparedStatement st = db.createPreparedStatement(sqlStr, 0);
try {
st.executeUpdate();
db.commit();
st.close();
} catch (SQLException e) {
e.printStackTrace();
}
查询的例子:
String sql = "select * from table_name ";
ResultSet rs = null;
DBTransaction db = this.getDBTransaction();
PreparedStatement ps = db.createPreparedStatement(sql, 0);
try {
rs = ps.executeQuery();
while (rs.next()) {
messageContent = rs.getString("messageContent");
}
st.close();
} catch (SQLException ex) {
ex.printStackTrace();
}