请大神们看看这个异常怎么处理

Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION addUser does not exist
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 ;


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值