import java.sql.Date;
import java.sql.Types;
import com.mysql.jdbc.CallableStatement;
import com.mysql.jdbc.Connection;
public class JavaStoredProcedure {
public static void main(String[] args) throws Exception {
String jdbcURL = "jdbc:mysql://172.18.11.37:3306/tracker_test";
String userName = "tracker";
String password = "tracker";
Class.forName("com.mysql.jdbc.Driver");
// 获得连接
Connection conn = (Connection) DriverManager.getConnection(jdbcURL,
userName, password);
System.out.println("conn: "+conn);
// 创建函数
CallableStatement c = (CallableStatement) conn
.prepareCall("{?=call getdate(?)}");
/*
* 如果是调用存储过程 取入参和出参
* */
c.registerOutParameter(2, Types.DATE);
// 给存储过程的参数设置值
c.setDate(2, new Date(1000000000)); //
// 执行存储过程
c.execute();
//去除参数
System.out.println("c.getString(1) "+c.getString(1));
conn.close();
}
}