本文整理汇总了Java中java.sql.ResultSet.deleteRow方法的典型用法代码示例。如果您正苦于以下问题：Java ResultSet.deleteRow方法的具体用法？Java ResultSet.deleteRow怎么用？Java ResultSet.deleteRow使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类java.sql.ResultSet的用法示例。
在下文中一共展示了ResultSet.deleteRow方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: testDeletable2
import java.sql.ResultSet; //导入方法依赖的package包/类
public void testDeletable2() {
try {
Connection c =
DriverManager.getConnection("jdbc:hsqldb:mem:mytestdb", "SA",
"");
String createSQL =
"create table test (num INTEGER PRIMARY KEY, str VARCHAR(25))";
Statement createStmt = c.createStatement();
createStmt.execute(createSQL);
createStmt.close();
String ins = "insert into test (num,str) values (?,?)";
PreparedStatement pStmt = c.prepareStatement(ins);
for (int i = 0; i < 100; i++) {
pStmt.setInt(1, i);
pStmt.setString(2, "String" + i);
pStmt.execute();
}
// there should now be 100 rows in the table
String select = "SELECT * FROM test";
PreparedStatement stmt = c.prepareStatement(select,
ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery();
rs.beforeFirst();
while (rs.next()) {
int num = rs.getInt("num");
if ((num % 7) == 0) {
System.out.println("Deleting row:" + num);
rs.deleteRow();
}
}
Statement dropStmt = c.createStatement();
dropStmt.execute("drop table test;");
dropStmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
示例2: testQuery
import java.sql.ResultSet; //导入方法依赖的package包/类
public void testQuery() {
try {
Connection c = newConnection();
Statement st = c.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String s =
"CREATE TABLE T (I INTEGER, C CHARACTER(10), B BIT(4) DEFAULT B'')";
st.execute(s);
s = "INSERT INTO T VALUES(?,?, DEFAULT)";
PreparedStatement ps = c.prepareStatement(s);
for (int i = 1; i <= 20; i++) {
ps.setInt(1, i);
ps.setString(2, "TEST " + i);
ps.execute();
}
c.setAutoCommit(false);
s = "SELECT * FROM T";
ResultSet rs = st.executeQuery(s);
rs.absolute(10);
rs.updateString(2, "UPDATE10");
rs.updateRow();
rs.absolute(11);
rs.deleteRow();
rs.moveToInsertRow();
rs.updateInt(1, 1011);
rs.updateString(2, "INSERT1011");
rs.updateString(3, "0101");
rs.insertRow();
rs.close();
rs = st.executeQuery(s);
while (rs.next()) {
System.out.println("" + rs.getInt(1) + " "
+ rs.getString(2) + " "
+ rs.getString(3));
}
st.execute("SHUTDOWN");
if (!isNetwork) {
c.close();
}
} catch (Exception e) {
System.out.print(e);
}
}