₦airaland Forum

@subcareer n candylips

Thanks for the support, had to migrate to ubuntu linux,
took most of my time getting all my java stuff to run on it. Had to look for a way
getting a chm reader for linux. Now am back on track and ready to move on.

@subcareer

Thanks for the encouragement, these are my final codes after refactoring

[b]
// PawnTest class
package pieces;

public class PawnTest extends junit.framework.TestCase {

public void testCase() {

String firstPawnColor = Pawn.WHITE_PAWN;
Pawn whitePawn = new Pawn(firstPawnColor);
assertEquals(firstPawnColor, whitePawn.getColor());

String secondPawnColor = Pawn.BLACK_PAWN;
Pawn blackPawn = new Pawn(secondPawnColor);
assertEquals(secondPawnColor, blackPawn.getColor());

}
}

// Pawn class

package pieces;

public class Pawn {

public final static String BLACK_PAWN = "black";
public final static String WHITE_PAWN = "white";
private String color;


public Pawn(String color){
this.color = color;

}


public String getColor(){

return color;
}

}

//BoardTest class

import junit.framework.TestCase;
import java.util.*;
import pieces.*;

public class BoardTest extends TestCase {


private Board board;


public void setUp(){


board = new Board();


}

public void testCase(){

//Just testing to make sure, I have no pawn on the board
assertEquals(0,board.getNumberOfPieces());


}

public void testAddPawn(){


//create a piece of pawn and add it to the board

Pawn pawn1 = new Pawn(Pawn.BLACK_PAWN);
board.addPawn(pawn1);

//Check numbers of pawns on board
assertEquals(1,board.getNumberOfPieces());

//Test if the pawn is the first pawn added to the board,then test for the colour
assertEquals(pawn1, board.get(0));
assertEquals("black",board.getPawnColor(0));

//same test as for pawn1
Pawn pawn2 = new Pawn(Pawn.WHITE_PAWN);
board.addPawn(pawn2);
assertEquals(2, board.getNumberOfPieces());
assertEquals(pawn2, board.get(1));
assertEquals("white", board.getPawnColor(1));

//Testing with the Pawn getColor() to ensure the colour is as per expected.
assertEquals("black",pawn1.getColor());
assertEquals("white",pawn2.getColor());

}
}

//Board class
import java.util.*;
import pieces.Pawn;



public class Board {

//create an ArrayList of pawns to be added to the board
private List<Pawn> pawns = new ArrayList<Pawn>();


//Board constructor, this can be used to add new pawns
public Board(Pawn pawn){
pawn = new Pawn(Pawn.WHITE_PAWN);
}

public Board(){}


public void addPawn(Pawn pawn){
pawns.add(pawn);
}

public int getNumberOfPieces(){
return pawns.size();
}


public Pawn get(int index){

return pawns.get(index);
}


//Not too comfortable with this method,think there should be a better way
//to handle. Just getting a Pawn object from get(index) and calling it's
//getColor() to get the colour.

public String getPawnColor(int index){
return get(index).getColor();
}


}

[/b]

Hope to hear from you, just started chapter three today. Once more thanks

@subcareer

Finally, here is my solution for exercise two, but i strongly believe that the code can be better,
I will just post as per the requirements


[b]

// PawnTest class

public class PawnTest extends junit.framework.TestCase {

public void testCase() {

String firstPawnColor = "White";
Pawn whitePawn = new Pawn(firstPawnColor);
//String whitePawn = firstPawn.getColor();
assertEquals(firstPawnColor, whitePawn.getColor());

String secondPawnColor = "black";
Pawn blackPawn = new Pawn(secondPawnColor);
assertEquals(secondPawnColor, blackPawn.getColor());

//Pawn noClolor = new Pawn();


}
}

// Pawn class

public class Pawn {

private final static String BLACK_PAWN = "black";
private final static String WHITE_COLOR = "white";
private String color;

public Pawn() {
this.color = WHITE_COLOR;
}

public Pawn(String color){
this.color = color;

}


public String getColor(){

return color;
}

public void setColor(String color){
this.color = color;
}

}

//BoardTest class

import junit.framework.TestCase;
import java.util.*;




public class BoardTest extends TestCase {


private Board board;
private Pawn pawn;

public void setUp(){

pawn = new Pawn();
board = new Board(pawn);


}

public void testCase(){


// Pawn pawn = new Pawn();
//board = new Board();
assertEquals(0,board.getNumberOfPieces());
assertEquals("white",board.getPawnColor());

}

public void testAddPawn(){


pawn = new Pawn("black";
board = new Board(pawn);
board.addPawn(pawn);
assertEquals("black",board.getPawnColor());
assertEquals(1,board.getNumberOfPieces());


Pawn pawn2 = new Pawn("white";
board.addPawn(pawn2);
assertEquals("white", pawn2.getColor());
assertEquals(2, board.getNumberOfPieces());


assertEquals("black",pawn.getColor());
assertEquals("white",pawn2.getColor());

}
}


//Board class
import java.util.*;

public class Board {

//create an ArrayList of pawns to be added to the board
private ArrayList<Pawn> board = new ArrayList<Pawn>();

private Pawn pawn;

//Board constructor, this can be used to add new pawns
public Board(Pawn pawn){
this.pawn = pawn;
}


//public Board() {
// pawn = new Pawn();
//}


public void addPawn(Pawn pawn){
board.add(pawn);
}

public int getNumberOfPieces(){
return board.size();
}

public String getPawnColor(){
return pawn.getColor();
}


}

//AllTest.java

import junit.framework.*;

public class AllTest {

public static TestSuite suite() {
TestSuite suite = new TestSuite();

suite.addTestSuite(PawnTest.class);
suite.addTestSuite(BoardTest.class);

return suite;
}


}
[/b]

@candylips
Here are my codes for the personnel table. Am using the spring MVC framework

Personnel.java represents my personnel table

package com.navy.domain;

import java.io.Serializable;

/**
*
* @author Owner
*/
public class Personnel implements Serializable {
private int pid;
private String serviceNum;
private String name;
private String status;
private String addr1;
private String addr2;
private String city;
private String state;
private String zip;
private String phone;

/** Creates a new instance of Personnel */
public Personnel() {
}

public int getPid() {
return pid;
}

public void setPid(int pid) {
this.pid = pid;
}

public String getServiceNum() {
return serviceNum;
}

public void setServiceNum(String serviceNum) {
this.serviceNum = serviceNum;
}

public String getName() {
return name;
}

public void setName(String name) {
this.name = name;
}

public String getStatus() {
return status;
}

public void setStatus(String status) {
this.status = status;
}

public String getAddr1() {
return addr1;
}

public void setAddr1(String addr1) {
this.addr1 = addr1;
}

public String getAddr2() {
return addr2;
}

public void setAddr2(String addr2) {
this.addr2 = addr2;
}

public String getCity() {
return city;
}

public void setCity(String city) {
this.city = city;
}

public String getState() {
return state;
}

public void setState(String state) {
this.state = state;
}

public String getZip() {
return zip;
}

public void setZip(String zip) {
this.zip = zip;
}

public String getPhone() {
return phone;
}

public void setPhone(String phone) {
this.phone = phone;
}

}

DAO

package com.navy.dao;

import com.navy.domain.Personnel;
import java.util.Collection;

/**
*
* @author Owner
*/
public interface PersonelDao {
public Personnel getPersonnel(int pid);
public Collection<Personnel> getAllPersonnel();
}


My RowMapper class

package com.navy.dao.jdbc;

import com.navy.domain.Personnel;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.springframework.jdbc.core.RowMapper;

/**
*
* @author Owner
*/
public class PersonnelRowMapper implements RowMapper{

/** Creates a new instance of PersonnelRowMapper */
public PersonnelRowMapper() {
}

public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
Personnel pers = new Personnel();
pers.setPid(rs.getInt("PID");
pers.setServiceNum(rs.getString("SERVICENUM");
pers.setName(rs.getString("NAME");
pers.setStatus(rs.getString("STATUS");
pers.setAddr1(rs.getString("ADDR1");
pers.setAddr2(rs.getString("ADDR2");
pers.setCity(rs.getString("CITY");
pers.setState(rs.getString("STATE");
pers.setZip(rs.getString("ZIP");
pers.setPhone(rs.getString("PHONE");

return pers;

}


}

My JdbcDAO


package com.navy.dao.jdbc;

import com.navy.dao.PersonelDao;
import com.navy.domain.Personnel;
import java.sql.Types;
import java.util.ArrayList;
import java.util.Collection;
import java.util.List;
import javax.sql.DataSource;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.support.JdbcDaoSupport;

/**
*
* @author Owner
*/
public class PersonnelJdbcDao extends JdbcDaoSupport implements PersonelDao{

private PersonnelRowMapper rowMapper;

/** Creates a new instance of PersonnelJdbcDao */
public PersonnelJdbcDao() {
rowMapper = new PersonnelRowMapper();
}

public Personnel getPersonnel(int pid) {
Object result = getJdbcTemplate().queryForObject("select * from Personel where PID=?",
new Object[]{new Integer(pid)},
new int[]{Types.INTEGER}, rowMapper);

return (Personnel)result;
}

public Collection<Personnel> getAllPersonnel() {
Collection<Personnel> result = null;

List queryResults = getJdbcTemplate().query("select * from Personel", rowMapper);

if (queryResults != null) {
result = new ArrayList<Personnel>(queryResults.size());
for (Object o : queryResults) {
if (o instanceof Personnel) {
result.add((Personnel)o);
}
}
}

return result;
}


}

Service and DAO interfaces exposing the same methods.

package com.navy.dao;

import com.navy.domain.Personnel;
import java.util.Collection;

/**
*
* @author Owner
*/
public interface PersonelDao {
public Personnel getPersonnel(int pid);
public Collection<Personnel> getAllPersonnel();
}


service implementer


package com.navy.service;

import com.navy.dao.PersonelDao;
import com.navy.domain.Personnel;
import java.util.Collection;

/**
*
* @author Owner
*/
public class PersonnelServiceImpl implements PersonnelService{

private PersonelDao personelDao ;

/** Creates a new instance of PersonnelServiceImpl */
public PersonnelServiceImpl() {
}



public PersonelDao getPersonnelDao() {
return personelDao;
}

public void setPersonnelDao(PersonelDao personelDao) {
this.personelDao = personelDao;
}

public Personnel getPersonnel(int pid) {
return personelDao.getPersonnel(pid);
}

public Collection getAllPersonnel() {
return personelDao.getAllPersonnel();
}

}

Now the controller.

package com.navy.controller;

import com.navy.service.PersonnelService;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.springframework.web.servlet.ModelAndView;

/**
*
* @author Owner
*/
public class PersonnelController implements org.springframework.web.servlet.mvc.Controller{

private PersonnelService personnelService;

/** Creates a new instance of PersonnelController */
public PersonnelController() {
}

public ModelAndView handleRequest(HttpServletRequest request, HttpServletResponse response) throws Exception {

if (request.getParameter("pid" != null) {

int pid = new Integer(request.getParameter("pid").intValue();

return new ModelAndView("personnel.jsp", "personnel", getPersonnelService().getPersonnel(pid));
} else {

return new ModelAndView("personnels.jsp", "personnels", getPersonnelService().getAllPersonnel());
}
}

public PersonnelService getPersonnelService() {
return personnelService;
}

public void setPersonnelService(PersonnelService personnelService) {
this.personnelService = personnelService;
}



}

cofig files

applicationcontext.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">

<beans>

<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName">
<value>java:comp/env/jdbc/pms</value>
</property>
</bean>


<bean id="personnelDao" class="com.navy.dao.jdbc.PersonnelJdbcDao">
<property name="dataSource">
<ref local="dataSource"/>
</property>
</bean>

<bean id="personnelService" class="com.navy.service.PersonnelServiceImpl">
<property name="personnelDao">
<ref local="personnelDao"/>
</property>
</bean>
</beans>

personnel-servlet.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<!-- Create a mapping of URI's to Controller -->
<bean id="urlMapping" class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping">
<property name="mappings">
<props>
<prop key="/personnels.do">personnelController</prop>
<prop key="/personnel.do">personnelController</prop>
</props>
</property>
</bean>

<!-- Provide the ProductController with access to an implementation of the
ProductService. The ProductService is defined in applicationcontext.xml -->
<bean id="personnelController" class="com.navy.controller.PersonnelController">
<property name="personnelService">
<ref bean="personnelService"/>
</property>
</bean>
</beans>

context.xml

<?xml version="1.0" encoding="UTF-8"?>
<Context path="/PMS">
<Resource auth="Container" driverClassName="org.apache.derby.jdbc.ClientDriver" factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" name="jdbc/pms" password="admin" type="javax.sql.DataSource" url="jdbc:derby://localhost/pms" username="admin"/>
</Context>


web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
<description>PMS</description>
<display-name>PMS</display-name>
<distributable/>
<context-param>
<description>Spring Application Context</description>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/classes/applicationcontext.xml</param-value>
</context-param>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<servlet>
<servlet-name>personnel</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>personnel</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
<session-config>
<session-timeout>
30
</session-timeout>
</session-config>
<welcome-file-list>
<welcome-file>
index.jsp
</welcome-file>
</welcome-file-list>
<resource-ref>
<res-ref-name>jdbc/pms</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
</web-app>

Whao, hope not too much of stress, my question again, I still have to more tables for courses and signon, do i have
to have a diff controller for each or can i boundle all the logic in the personnel controller ?
Thanks for the guide, just learning.

@candylips
Thanks for your contribution. As earlier mentioned, you just forced me into the spring circle. But come to
think of it, despite the simplicity of the spring framework, i still feel that there are some situation where it might not
be appropriate to use spring, infact I am currently reading a book on EJB 3.0, nice book - Mastering EJB 3.0, it has a free
pdf version that can be downloaded for free @http://www.theserverside.com/tt/articles/index.tss, try and get
it, all you need is just register and the book and many more are yours.

Ok on my project, i strongly believe the best way to learn new technology is by trying it out. I am using netbean,
with a derby database. I just want to create say a Personnel Management System using the Spring framework.
I have Personnel table that holds each personnel data, Course table for courses attended by a particular personnel
and finally user table that holds user name and password. I have a class the represent that represent each table, DAO
and it's implementer class for each table, my question is do i need to create a controller servlet for each class -- ie table ?

Hey guys,
Never mind, i understand how much you people want to get on with Linux based systems.
For now i never thought my last post will take me this far, my Promise is to contribute to my old
pal's thread on Linux based system. Pls am preparing a little note on that, which i hope to post
by weekend. Please stay close and tight.

@adewaleafola
I must tell you the truth, java was design to be easy but that's far from it. With the new drag and drop
ide like neatbean, you can actually develop your application with minimum understand of java, i run a java
training thread on this site, purely basic concept of the language, so i intend to bring to bear on mobile
programming in java. Stay glue.i

@candylips
Hey I tend to agree with you, but come to think of it, why would you want to develop an enterprise application,
you must need a java ee environment to deploy you application. The java ee design pattern is the basic pattern which all other
pattern must meet to be java e e compliant.

Hi guys,
This man call skima appear to real o. Seun, please allow this post for once. We are not English
people. This skima of a guy was chasesd by a cheater yesterday, the cheater pursue am so
ta, the cheater come tire, just because of Ubuntu cds, and him come land me
one, make una help me hail am. The guy na real man.