Subversion Repository Public Repository

TransPort_Tracking

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.bestray.transtracking.dao.mapper;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.ResultSetExtractor;

import com.bestray.trastrack.domain.User;

/**
 *
 * @author Girija Sahu
 */
public class UserResultSetExtractor implements  ResultSetExtractor<Object>{

	public Object extractData(ResultSet rs) throws SQLException,
			DataAccessException {
		List <User> userList = new ArrayList<User>();
        while(rs.next()){
            User user = new User();
         user.setId(rs.getInt("id"));
         user.setUserName(rs.getString("username"));
         user.setPassword(rs.getString("password"));
         user.setFirstName(rs.getString("first_name"));
         user.setLastName(rs.getString("last_name"));
         userList.add(user);
              }
     return userList.size()>0?userList.get(0):null;
	}
     
   
   
    
}

Commits for TransPort_Tracking/TransPortTracking/src/main/java/com/bestray/transtracking/dao/mapper/UserResultSetExtractor.java

Diff revisions: vs.
Revision Author Commited Message
1 girijabapi picture girijabapi Sat 28 Jul, 2018 05:29:14 +0000