一张表，怎么根据id查询其他字段值???java后台代码，，我忘了怎么写了，悲催....
------解决方案--------------------------------------------------------
- Java code
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的