java空指针异常SQL准备语句 [英] java null pointer exception SQL prepared statement
问题描述
我有以下SQL查询:
private static final String SQL_LIST_ALL =
"SELECT DISTINCT * "
+ "FROM usuarios WHERE NOT EXISTS (SELECT * FROM usuarios_grupos WHERE usuarios_grupos.id_grupo = ? AND usuarios_grupos.id_usuario = usuarios.id_usuario)";
驻留在我的list()方法中:
which resides in my list() method:
public List<Usuarious> list() throws DAOExceptions {
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
List<Usuarious> users = new ArrayList<Usuarious>();
try {
connection = daoFactory.getConnection();
preparedStatement = connection.prepareStatement(SQL_LIST_ALL);
preparedStatement.setInt(1,groups.getId_grupo());
resultSet = preparedStatement.executeQuery();
while (resultSet.next()) {
users.add(mapUser(resultSet));
}
} catch (SQLException e) {
throw new DAOExceptions(e);
} finally {
close(connection, preparedStatement, resultSet);
}
return users;
}
运行程序时出现空指针异常.它发生在这里:
I got a null pointer exception when I run my program. It happens here:
preparedStatement = connection.prepareStatement(SQL_LIST_ALL);
preparedStatement.setInt(1,groups.getId_grupo());
我的结果集方法:
private static Usuarious mapUser(ResultSet rs) throws SQLException {
Usuarious user = new Usuarious(rs.getInt("id_usuario"), rs.getString("nome"), rs.getString("setor"),
rs.getString("senha"), rs.getString("email"), rs.getString("bloquear"), rs.getString("admin"));
return user;
}
我正在尝试将id_grupo传递给?"在我的SQL语句上.但是,这些方法在我的UserDAO中.因此,我在DAO中创建了一个新的组对象以检索id_grupo.
I am trying to pass the id_grupo into the "?" on my SQL statement. However, these methods are in my UserDAO. So, I created a new group object in the DAO to retrieve the id_grupo.
有人可以告诉我这是怎么回事吗?
Can anyone tell me what is wrong here?
我的堆栈跟踪:
javax.el.ELException: /index.xhtml @43,78 value="#{usuariousGruposBean.listOfUsuarios}": Error reading 'listOfUsuarios' on type br.view.UsuariousGruposBean
at com.sun.faces.facelets.el.TagValueExpression.getValue(TagValueExpression.java:114)
at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:194)
at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:182)
at javax.faces.component.UIData.getValue(UIData.java:731)
at javax.faces.component.UIData.getDataModel(UIData.java:1798)
at javax.faces.component.UIData.getRowCount(UIData.java:356)
at org.primefaces.component.datatable.DataTableRenderer.encodeTbody(DataTableRenderer.java:456)
at org.primefaces.component.datatable.DataTableRenderer.encodeRegularTable(DataTableRenderer.java:201)
at org.primefaces.component.datatable.DataTableRenderer.encodeMarkup(DataTableRenderer.java:180)
at org.primefaces.component.datatable.DataTableRenderer.encodeEnd(DataTableRenderer.java:85)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1763)
at javax.faces.render.Renderer.encodeChildren(Renderer.java:168)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:845)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1756)
at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1759)
Caused by: java.lang.NullPointerException
at br.dao.UsuariousDAO.list(UsuariousDAO.java:93)
at br.view.UsuariousGruposBean.getListOfUsuarios(UsuariousGruposBean.java:47)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
好吧,我刚刚创建了一个Group对象.它显示在这里:
Well, I just created a Group object. It is shown here:
public class UsuariousDAO {
private static final String SQL_LIST_ALL =
"SELECT DISTINCT * "
+ "FROM usuarios WHERE NOT EXISTS (SELECT * FROM usuarios_grupos WHERE usuarios_grupos.id_grupo = ? AND usuarios_grupos.id_usuario = usuarios.id_usuario)";
private DAOFactory daoFactory;
Grupos groups = new Grupos();
推荐答案
检查该代码 groups.getId_grupo()
组是一个空对象. 您的函数必须具有一个 groups 类型的对象,例如参数.
groups is an null object. You function must have one object of type groups like parameter.
这篇关于java空指针异常SQL准备语句的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!