at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1383)
at com.mysql.jdbc.DatabaseMetaData.getCallStmtParameterTypes(DatabaseMetaData.java:1581)
at com.mysql.jdbc.DatabaseMetaData.getProcedureOrFunctionColumns(DatabaseMetaData.java:4120)
at com.mysql.jdbc.DatabaseMetaData.getProcedureColumns(DatabaseMetaData.java:4057)
at com.mysql.jdbc.CallableStatement.determineParameterTypes(CallableStatement.java:809)
at com.mysql.jdbc.CallableStatement.<init>(CallableStatement.java:609)
at com.mysql.jdbc.JDBC4CallableStatement.<init>(JDBC4CallableStatement.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.CallableStatement.getInstance(CallableStatement.java:505)
at com.mysql.jdbc.ConnectionImpl.parseCallableStatement(ConnectionImpl.java:3881)
at com.mysql.jdbc.ConnectionImpl.prepareCall(ConnectionImpl.java:3965)
at com.mysql.jdbc.ConnectionImpl.prepareCall(ConnectionImpl.java:3939)
at org.glaway.jdbc.PsTest.ps(PsTest.java:37)
at org.glaway.jdbc.PsTest.main(PsTest.java:24)
这是源程序:
/*
* 文件名:PsTest.java
* 版权:Copyright by www.glaway.com
* 描述:
* 修改人:DELL
* 修改时间:2016年7月13日
* 跟踪单号:
* 修改单号:
* 修改内容:
*/
package org.glaway.jdbc;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.Date;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;
public class PsTest{
public static void main(String[] args) throws SQLException
{
ps();
}
public static void ps() throws SQLException{
Connection conn=null;
CallableStatement cs=null;
ResultSet rs=null;
try
{
//建立连接
conn=JdbcUtils.getConnection();
//创建语句
String sql="{call addUser(?,?,?,?)}";
cs=conn.prepareCall(sql);
cs.setString(1, "ps name");
cs.setDate(2, new Date(System.currentTimeMillis()));
cs.setFloat(3, 3000f);
cs.registerOutParameter(4, Types.INTEGER);
cs.executeUpdate();
int id=cs.getInt(4);
System.out.println("id="+id);
}
finally{
JdbcUtils.free(rs, cs, conn);
}
}
}
这是mysql存储过程的创建:
DELIMITER $$
DROP PROCEDURE IF EXISTS `yaolin`.`addUser` $$
CREATE PROCEDURE `addUser`(in pname varchar(45),in birthday date,in money float,out pid int)
BEGIN
insert into user(name,birthday,money) values(pname,birthday,money);
select last_insert_id() into pid;
END $$
DELIMITER ;