Ola pessoal sera que alguem poderia me ajudar com um erro que esta dano na minha aplicação?
Vou postar minhas classes o erro
[code]package br.com.devmedia.completeswingapp.dao;
import java.sql.ResultSet;
import java.sql.SQLException;
import br.com.devmedia.completeswingapp.entity.User;
public class UserDAO extends GenericDAO {
public int addUser(User usr) throws SQLException{
usr.setId(getNextId("users"));
String query = "insert into users (id, name, login, password) values (?, ?, ?, ?)";
executeCommand(query,usr.getId(), usr.getName(), usr.getLogin(), usr.getPassword());
return usr.getId();
}
public void removeUser(int idUser) throws SQLException{
executeCommand("delete from users where id = ?", idUser);
}
public void updateUser(User usr) throws SQLException{
String query = "update users set name =?, login =?, password =? where id =?";
executeCommand(query,usr.getName(), usr.getLogin(), usr.getPassword(), usr.getId());
}
public User getUser(int idUser) throws SQLException{
ResultSet rs = executeQuery("select * from users where id =?", idUser);
User usr = null;
if(rs.next()){
usr = populateUserInfo(rs);
}
rs.close();
return usr;
}
private static User populateUserInfo(ResultSet rs) throws SQLException {
User toReturn = new User();
toReturn.setId(rs.getInt("id"));
toReturn.setLogin(rs.getString("login"));
toReturn.setName(rs.getString("name"));
toReturn.setPassword(rs.getString("password"));
return toReturn;
}
}
[/code]
Classe para fazer o teste na UserDAO
[code]/**
*
*/
package br.com.devmedia.completeswingapp.dao;
import static org.junit.Assert.*;
import org.junit.After;
import org.junit.AfterClass;
import org.junit.Before;
import org.junit.BeforeClass;
import org.junit.Test;
import br.com.devmedia.completeswingapp.entity.User;
/**
- @author Renato
*/
public class UserDAOTest {
public static Integer idOfUser =0;
/**
* @throws java.lang.Exception
*/
@BeforeClass
public static void setUpClass() throws Exception {
}
/**
* @throws java.lang.Exception
*/
@AfterClass
public static void tearDownClass() throws Exception {
}
/**
* @throws java.lang.Exception
*/
@Before
public void setUp() throws Exception {
}
/**
* @throws java.lang.Exception
*/
@After
public void tearDown() throws Exception {
}
/**
* Test method for {@link br.com.devmedia.completeswingapp.dao.UserDAO#addUser(br.com.devmedia.completeswingapp.entity.User)}.
*/
@Test
public void testAddUser() throws Exception {
System.out.println("addUser");
User usr = new User();
usr.setName("Test User");
usr.setLogin("test");
usr.setPassword("test123");
UserDAO instance = new UserDAO();
idOfUser = instance.addUser(usr);
User result = instance.getUser(idOfUser);
assertEquals(idOfUser, result.getId());
}
/**
* Test method for {@link br.com.devmedia.completeswingapp.dao.UserDAO#getUser(int)}.
*/
@Test
public void testGetUser() throws Exception{
System.out.println("getUser");
int idUser = idOfUser;
UserDAO instance = new UserDAO();
Integer expResult = idOfUser;
User result = instance.getUser(idUser);
assertEquals(expResult, result.getId());
}
/**
* Test method for {@link br.com.devmedia.completeswingapp.dao.UserDAO#updateUser(br.com.devmedia.completeswingapp.entity.User)}.
*/
@Test
public void testUpdateUser() throws Exception{
System.out.println("updateUser");
UserDAO instance = new UserDAO();
User usr = instance.getUser(idOfUser);
usr.setName("Test Test NOW");
instance.updateUser(usr);
usr = instance.getUser(idOfUser);
assertEquals(usr.getName(), "Test Test NOW");
}
/**
* Test method for {@link br.com.devmedia.completeswingapp.dao.UserDAO#removeUser(int)}.
*/
@Test
public void testRemoveUser() throws Exception{
System.out.println("removeUser");
UserDAO instance = new UserDAO();
instance.removeUser(idOfUser);
}
}
[/code]
e agora o erro que esta dano
com.microsoft.sqlserver.jdbc.SQLServerException: Nome de objeto ‘users’ inválido.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:156)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1373)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:371)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:322)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4003)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1550)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:160)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:133)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:265)
at br.com.devmedia.completeswingapp.dao.GenericDAO.executeQuery(GenericDAO.java:42)
at br.com.devmedia.completeswingapp.dao.GenericDAO.getNextId(GenericDAO.java:56)
at br.com.devmedia.completeswingapp.dao.UserDAO.addUser(UserDAO.java:11)
at br.com.devmedia.completeswingapp.dao.UserDAOTest.testAddUser(UserDAOTest.java:61)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:45)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:42)
at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:30)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:263)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:68)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:47)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:231)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:60)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:229)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:50)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:222)
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:30)
at org.junit.runners.ParentRunner.run(ParentRunner.java:300)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)