菜鸟问题,在线等答案。。。
一张表,怎么根据id查询其他字段值???java后台代码,,我忘了怎么写了,悲催....
[解决办法]
public List<FailedType> getFailedType(){ List<FailedType> failedTypes = new ArrayList<FailedType>(); String sql = "SELECT FAILED_TYPE,FAILED_NO FROM T_FAILED_TYPE WHERE ID = ?"; Connection connect = DBConnectFactory.getDBConnect(); ResultSet rs = null; try { PreparedStatement ps = connect.prepareStatement(sql.toString()); ps.setString(1, "111"); rs = ps.executeQuery(); while (rs.next()) { FailedType failedType = new FailedType(); String type = rs.getString("FAILED_TYPE"); String no = rs.getString("FAILED_NO"); failedType.setFailedType(type); failedType.setFailedNo(no); failedTypes.add(failedType); } } catch (SQLException e) { logger.error(e.getMessage()); e.printStackTrace(); } finally { DBConnectFactory.closeResultSet(rs); } return failedTypes; }
[解决办法]
呃。。。这个忘得有点多了
[解决办法]
是用jdbc取值么
select * from table where id=?
[解决办法]
那如果你用了什么框架之类的,就好好去看看框架的使用。我写的是jdbc的