| |
MyServiceImpl.java
package myapp.server;
import java.sql.*;
import java.util.*;
import myapp.server.common.BaseService;
import myapp.client.MyService;
import myapp.client.MyBean;
public class MyServiceImpl extends BaseService implements MyService
{
public List<MyBean> getNameList()
throws SQLException
{
Connection connection = getConnection();
PreparedStatement pstmt= connection.prepareCall(
"select id, name "+
"from t_name ");
ResultSet resultSet=pstmt.executeQuery();
List<MyBean> c = new ArrayList<MyBean>();
while ( resultSet.next() )
{
c.add(resultSetToMyBean( resultSet ) );
}
resultSet.close();
pstmt.close();
returnConnection(connection);
return c;
}
private MyBean resultSetToMyBean(ResultSet resultSet)
throws SQLException
{
MyBean o = new MyBean();
o.setId( resultSet.getInt(1));
o.setName( resultSet.getString(2));
return o;
}
}
|