该博客展示了如何使用JDBC在PostgreSQL中执行基本的更新操作和调用存储过程。`makeUsersInactive()`方法通过设置active为true使非活跃用户变为活跃。`purgeBadUsers()`方法调用名为`lab4.purgeBadFunction`的存储过程，传入参数censorLimit来删除不良用户，并返回受影响的记录数。
public List<Integer> getUsersByAddress(String theAddress)
{
List<Integer> result = new ArrayList<Integer>();
try{
String sql = "SELECT userID from lab4.ChirpUsers where address=?";
PreparedStatement st = connection.prepareStatement(sql);
st.setString(1, theAddress);
ResultSet rs = st.executeQuery();
while(rs.next()){
Integer userId = rs.getInt(1);
result.add(userId);
}
}catch(SQLException e){
e.
{
List<Integer> result = new ArrayList<Integer>();
try{
String sql = "SELECT userID from lab4.ChirpUsers where address=?";
PreparedStatement st = connection.prepareStatement(sql);
st.setString(1, theAddress);
ResultSet rs = st.executeQuery();
while(rs.next()){
Integer userId = rs.getInt(1);
result.add(userId);
}
}catch(SQLException e){
e.
最低0.47元/天 解锁文章
扫一扫
1759
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
