Connection con=cpManagement.getConnection();
Statement smt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=smt.executeQuery("select * from customerInfo where ID="+id);
if(rs.next())
{
rs.updateString("userName",c.getUserName());
rs.updateString("password",c.getPassword());
rs.updateString("realName",c.getRealName());
rs.updateInt("loginTimes",c.getLoginTimes());
rs.updateString("address",c.getAddress());
rs.updateString("visa",c.getVisa());
rs.updateString("phonenumber",c.getPhonenumber());
rs.updateString("email",c.getEmail());
rs.updateString("IDcard",c.getIDCard());
rs.updateRow();
success=true;
}
else
success=false;
运行后,有sqlexception:
SQL Exception: Feature not implemented: no details.
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
at org.apache.derby.impl.jdbc.Util.notImplemented(Util.java)
at org.apache.derby.impl.jdbc.EmbedResultSet20.updateString(EmbedResultSet20.java)
at rosa.systemClass.myDataManagement.updateCustomer(myDataManagement.java:157)
at rosa.systemClass.myDataManagement.main(myDataManagement.java:642)
谁帮我看看啊?别的类,以及数据库的表应该没有问题
Statement smt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=smt.executeQuery("select * from customerInfo where ID="+id);
if(rs.next())
{
rs.updateString("userName",c.getUserName());
rs.updateString("password",c.getPassword());
rs.updateString("realName",c.getRealName());
rs.updateInt("loginTimes",c.getLoginTimes());
rs.updateString("address",c.getAddress());
rs.updateString("visa",c.getVisa());
rs.updateString("phonenumber",c.getPhonenumber());
rs.updateString("email",c.getEmail());
rs.updateString("IDcard",c.getIDCard());
rs.updateRow();
success=true;
}
else
success=false;
运行后,有sqlexception:
SQL Exception: Feature not implemented: no details.
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java)
at org.apache.derby.impl.jdbc.Util.notImplemented(Util.java)
at org.apache.derby.impl.jdbc.EmbedResultSet20.updateString(EmbedResultSet20.java)
at rosa.systemClass.myDataManagement.updateCustomer(myDataManagement.java:157)
at rosa.systemClass.myDataManagement.main(myDataManagement.java:642)
谁帮我看看啊?别的类,以及数据库的表应该没有问题
怎么不是DriverManager
ResultSet rs=smt.executeQuery("select * from customerInfo where ID=‘"+id+"'");
就是ID要用单引号包起来
cpmanagement是连接池,没有问题,c.getUserName都可以打印出来的
我把改成select * from customerInfo都还是这个错误