表格中13处缺少in或out参数_索引中丢失 in 或 out 参数 1是什么错误

publicintinsert(MessageBeanmb){//MessageBeanmb=newMessageBean();Stringid=CreateId.getStringId();inti=0;Strings1="insertintoq_messagevalues(?,?,?)";try{con=ConnectionDB.ge...

public int insert(MessageBean mb) {

//MessageBean mb=new MessageBean();

String id = CreateId.getStringId();

int i = 0;

String s1 = "insert into q_message values(?,?,?)";

try {

con = ConnectionDB.getConnectionDB();

sql = con.prepareStatement(s1);

System.out.println("fjhf");

rs = sql.executeQuery();

System.out.println("gsdf");

sql.setString(1, id);

sql.setString(2,mb.getMsend());

sql.setString(3, mb.getMcontent());

i = sql.executeUpdate();

con.close();

}

catch (Exception e) {

e.printStackTrace();

}

return i;

}

这是dao层 显示的是rs = sql.executeQuery();有错，

java.sql.SQLException: 索引中丢失 IN 或 OUT 参数:: 1

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)

at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1680)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3279)

at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3328)

at dao.MessageDao.insert(MessageDao.java:36)

at action.MessageAction.insert(MessageAction.java:38)

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)

展开