java connection
java5
posted: May, 1st 2012 | jump to bottom
public UserModel getUser(Integer userId){ String userDataQuery = "SELECT user_.greeting, user_.firstname, user_.lastname, user_.emailaddress from user_ where user_.userid = " + userId; UserModel user = new UserModel(); Connection con = null; PreparedStatement ps = null; ResultSet rs = null; try{ Context ctx = new InitialContext(); DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/oracledb"); con = ds.getConnection(); ps = con.prepareStatement(userDataQuery); rs = ps.executeQuery(); rs.next(); user.set_greeting(rs.getString(1)); user.set_fname(rs.getString(2)); user.set_lname(rs.getString(3)); user.set_email(rs.getString(4)); } catch(Exception ex){ return null; } finally{ } return user; }
50 views




