String str = "";
conn = DBHelper.getConn();
try
{
ps = conn.prepareStatement("select (select b.Name from Permission b where b.ID=a.PermissionID) name from UserAccountXPermission a where a.UserAccountID = (select ID from UserAccount where UserName=?)");
ps.setString(1, ua.getUsername());
rs = ps.executeQuery();
str = rs.getString("name");
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
DBHelper.close(conn, ps, rs);
}
return str;为什么执行这条语句会报错 不能执行这么长的吗?还是其他方法
conn = DBHelper.getConn();
try
{
ps = conn.prepareStatement("select (select b.Name from Permission b where b.ID=a.PermissionID) name from UserAccountXPermission a where a.UserAccountID = (select ID from UserAccount where UserName=?)");
ps.setString(1, ua.getUsername());
rs = ps.executeQuery();
str = rs.getString("name");
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
DBHelper.close(conn, ps, rs);
}
return str;为什么执行这条语句会报错 不能执行这么长的吗?还是其他方法
换成
select name from UserAccountXPermission a where a.UserAccountID = (select ID from UserAccount where UserName=?)
试试
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:720)
at com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:5624)
at com.mysql.jdbc.ResultSet.getString(ResultSet.java:5544)
at com.mysql.jdbc.ResultSet.getString(ResultSet.java:5584)
at Handler.UserAccountHandler.checkUser(UserAccountHandler.java:48)
at UI.LoginUI$Monitor.actionPerformed(LoginUI.java:72)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$200(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
while(rs.next()){
str = rs.getString("name");
}跟sql没关系么,虽然sql写法有点
结果集一行的话,
直接
rs = ps.executeQuery();
rs.next();//加上这一句
str = rs.getString("name");多行就像上面一样,用while
结果集一行的话,
直接
rs = ps.executeQuery();
rs.next();//加上这一句
str = rs.getString("name");多行就像上面一样,用while
我指的是那个sql语句啊~
sql= select Name from Permission where ID=(select PermissionID from serAccountXPermission where UserAccountID=(select ID from UserAccount where UserName=?))
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
rs = ps.executeQuery();
rs.next();
str = rs.getString("name");