The Easiest Way to Save and Share Code Snippets on the web

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