| |
Output of stage 2
//FILE: myapp/client/generated/TodoBean.java
package myapp.client.generated;
public class TodoBean
{
private int todoId;
private String description;
private int rank;
public TodoBean()
{
super();
}
public void setTodoId(int _n) { todoId=_n; }
public int getTodoId() { return todoId; }
public void setDescription(String _n) { description=_n; }
public String getDescription() { return description; }
public void setRank(int _n) { rank=_n; }
public int getRank() { return rank; }
}
//FILE: myapp/client/generated/AttributeBean.java
package myapp.client.generated;
public class AttributeBean
{
private String name;
private String displayName;
public AttributeBean()
{
super();
}
public void setName(String _n) { name=_n; }
public String getName() { return name; }
public void setDisplayName(String _n) { displayName=_n; }
public String getDisplayName() { return displayName; }
}
//FILE: myapp/client/generated/IdLabel.java
package myapp.client.generated;
public class IdLabel
{
private String id;
private String label;
public IdLabel()
{
super();
}
public void setId(String _n) { id=_n; }
public String getId() { return id; }
public void setLabel(String _n) { label=_n; }
public String getLabel() { return label; }
}
//FILE: myapp/client/generated/DoneService.java
package myapp.client.generated;
import java.sql.*;
import java.util.*;
import myapp.client.generated.TodoBean;
import myapp.client.generated.AttributeBean;
import myapp.client.generated.IdLabel;
public interface DoneService
{
public List<TodoBean> getTodoList()
throws SQLException;
public int getNextSequenceValue()
throws SQLException;
public int getMaxRank()
throws SQLException;
public void insertTask(int id, String description, int rank)
throws SQLException;
public int addNewTask(String task)
throws SQLException;
}
//FILE: myapp/server/generated/DoneServiceImpl.java
package myapp.server.generated;
import java.sql.*;
import java.util.*;
import myapp.server.common.BaseService;
import myapp.client.generated.DoneService;
import myapp.client.generated.TodoBean;
import myapp.client.generated.AttributeBean;
import myapp.client.generated.IdLabel;
public class DoneServiceImpl extends BaseService implements DoneService
{
public List<TodoBean> getTodoList()
throws SQLException
{
Connection connection = getConnection();
PreparedStatement pstmt= connection.prepareCall(
"select todo_id, description, rank "+
"from t_todo "+
"order by rank ");
ResultSet resultSet=pstmt.executeQuery();
List<TodoBean> c = new ArrayList<TodoBean>();
while ( resultSet.next() )
{
c.add(resultSetToTodoBean( resultSet ) );
}
resultSet.close();
pstmt.close();
returnConnection(connection);
return c;
}
public int getNextSequenceValue()
throws SQLException
{
Connection connection = getConnection();
PreparedStatement pstmt= connection.prepareCall(
"select nextval('seq_todo') ");
ResultSet resultSet=pstmt.executeQuery();
resultSet.next();
int o=resultSetToInt( resultSet);
resultSet.close();
pstmt.close();
returnConnection(connection);
return o;
}
public int getMaxRank()
throws SQLException
{
Connection connection = getConnection();
PreparedStatement pstmt= connection.prepareCall(
"select max(rank) from t_todo ");
ResultSet resultSet=pstmt.executeQuery();
resultSet.next();
int o=resultSetToInt( resultSet);
resultSet.close();
pstmt.close();
returnConnection(connection);
return o;
}
public void insertTask(int id, String description, int rank)
throws SQLException
{
Connection connection = getConnection();
PreparedStatement stmt= connection.prepareCall(
"insert into t_todo(todo_id, description, rank) "+
"values(?, ?, ?) ");
stmt.setInt(1,id);
stmt.setString(2,description);
stmt.setInt(3,rank);
stmt.execute();
stmt.close();
returnConnection(connection);
}
public int addNewTask(String task)
throws SQLException
{
int newId=getNextSequenceValue();
int newRank=1+getMaxRank();
insertTask(newId,task,newRank);
return newId;
}
private TodoBean resultSetToTodoBean(ResultSet resultSet)
throws SQLException
{
TodoBean o = new TodoBean();
o.setTodoId( resultSet.getInt(1));
o.setDescription( resultSet.getString(2));
o.setRank( resultSet.getInt(3));
return o;
}
private AttributeBean resultSetToAttributeBean(ResultSet resultSet)
throws SQLException
{
AttributeBean o = new AttributeBean();
o.setName( resultSet.getString(1));
o.setDisplayName( resultSet.getString(2));
return o;
}
private IdLabel resultSetToIdLabel(ResultSet resultSet)
throws SQLException
{
IdLabel o = new IdLabel();
o.setId( resultSet.getString(1));
o.setLabel( resultSet.getString(2));
return o;
}
private int resultSetToInt(ResultSet resultSet)
throws SQLException
{
return resultSet.getInt(1);
}
}
|