java操作mysql存储过程的例子.doc

java操作mysql存储过程的例子 下面是我从网上找的几个用java操作mysql存储过程的例子: 例子一： 1、新建表testcreate table test(field1 int not null)TYPE=MyISAM ;insert into test(field1) values(1); 2、删除已存在的存储过程-- 删除储存过程delimiter // -- 定义结束符号drop procedure p_test;// 3、mysql存储过程定义create procedure p_test()begindeclare temp int;set temp = 0; update test set field1 =temp;end// 4、调用方法call p_test();import java.sql.*; public class Test Conn{ private Connection getConn(){Connection conn = null;try {?? Class.forName(org.gjt.mm.mysql.Driver);?? try {??? conn = DriverManager.getConnection(jdbc:mysql://:3306/test?useUnicode=true??? characterEncoding=GBK,root,ntsky);?? } catch (SQLException e1) {??? e1.printStackTrace();?? }}catch (ClassNotFoundException e) {?? e.printStackTrace();}return conn; } public void testC() {Connection conn = getConn();ResultSet rs = null;CallableStatement cs = null;String a = null;try {?? CallableStatement cStmt = conn.prepareCall({call p_test()});?? cStmt.executeUpdate();} catch (Exception e) {?? System.out.println(hahad + e.getMessage());} finally {?? try {??? conn.close();?? } catch (Exception ex) {??? System.out.println(ex : + ex.getMessage());?? }} } public static void main(String[] args) {new TestConn().testC();}} 例子二： 一、创建MySQL存储过程示例 --选择数据库 mysql use test; Database changed --创建示例用表 mysql create table zzm( - id int primary key auto_increment, - name varchar(10) - ); Query OK, 0 rows affected (0.20 sec) mysql insert into zzm(name) values(zhang); Query OK, 1 row affected (0.08 sec) mysql insert into zzm(name) values(zeng); Query OK, 1 row affected (0.05 sec) mysql insert into zzm(name) values(ming); Query OK, 1 row affected (0.05 sec) mysql select * from zzm; +----+-------+ | id | name | +----+-------+ | 1 | zhang | | 2 | zeng | | 3 | ming | +----+-------+ 3 rows in set (0.00 sec) --更改命令结束符（因为在procedure中经常要用到默认的命令结束符--分号(;) --所以在创建procedure的时候需要定义新的结束符以说明创建procedure的命令结束） --这里将结束符号改成美元符号--$ mysql delimiter $ --创建存储过程p