public static Team getTeam(Connection con, String team_id) throws java.sql.SQLException {
Team teamObj = null;
PreparedStatement pstmt = null;
java.sql.ResultSet rs = null;
String sql = null;
sql =
" select team_id, team_code, type_code, team_name, team_desc, team_manager_id, team_manager_name, creater, created "
+ " from t_team "
+ " where team_id = ?";
pstmt = con.prepareStatement(sql);
pstmt.setString(1, team_id);
rs = pstmt.executeQuery();
if (rs.next()) {
teamObj = new Team();
teamObj.team_id = rs.getString("team_id");
teamObj.team_code = rs.getString("team_code");
teamObj.type_code = rs.getString("type_code");
teamObj.team_name = rs.getString("team_name");
teamObj.team_desc = rs.getString("team_desc");
teamObj.team_manager_id = rs.getString("team_manager_id");
teamObj.team_manager_name = rs.getString("team_manager_name");
teamObj.creater = rs.getString("creater");
teamObj.created = rs.getTimestamp("created");
}
rs.close();
pstmt.close();
return teamObj;
}
