java seq_JAVA 不知道怎么写,就是获取新增的数据库seq序列值。

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

public List findAll() {

List list = new ArrayList<>();

PreparedStatement stmt = null;

ResultSet rs = null;

try{

String sql = "select customer_id,customer_name,customer_account,sex,customer_password,email,phone,credits from customer order by customer_id desc";

stmt = conn.prepareStatement(sql);

rs = stmt.executeQuery();

while(rs.next()){

int customerId = rs.getInt("customer_id");

String customerName = rs.getString("customer_name");

String customerAccount = rs.getString("customer_account");

String sex = rs.getString("sex");

String customerPassword = rs.getString("customer_password");

String email = rs.getString("email");

String phone = rs.getString("phone");

Double credits = rs.getDouble("credits");

list.add(new Customer(customerId,customerName,customerAccount,sex,customerPassword,email,phone,credits));

}

}catch(SQLException e){

e.printStackTrace();

throw new QXcmsException("查询客户信息失败");

}finally{

DBUtil.closeAll(null, stmt, rs);

}

return list;

}

然后怎么在就是测试类里面写获得这个新增的序列值,就是customerId.....大神写一句来助我,我是菜鸟~

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值