Java EE WEB工程师培训_7

《Java EE WEB工程师培训_7》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、JavaEEWEB工程师培训发表于2009-6-621:56

2、来自51CTO网页[只看他]–调用有输入、输出参数的存储过程################Michael分割线####################•CallableStatement简介–CallableStatement继承PreparedStatement–提供了调用存储过程的能力•调用简单的存储过程先创建一个存储过程createprocedureall_user()select*fromUserTbl调用存储过程callall

3、_user();F5刷新ConnectionUtil.javapackagecom.michael.jdbc;importjava.sql.Connection;importjava.sql.DriverManager;importjava.util.Properties;publicclassConnectionUtil{第一种方法publicConnectiongetConnection(){Connectionconn=null;try{Class.forName加载驱动Class.forNa

4、me(com.mysql.jdbc.Driver);DriverManager获水草玛瑙mnwg.net得连接conn=DriverManager.getConnection(jdbc:mysql:localhost:3306jdbc_db,root,mysqladminreturnconn;}catch(Exceptione){e.printStackTrace();}returnnull;}第二种方法publicConnectiongetConnection(Stringdriver,Strin

5、gurl,Stringuser,Stringpassword){Connectionconn=null;try{Class.forName加载驱动Class.forName(driver);DriverManager获得连接conn=DriverManager.getConnection(url,user,password);returnconn;}catch(Exceptione){e.printStackTrace();}returnnull;}第三种方法publicConnectionopen

6、Connection(){Stringdriver=Stringurl=Stringuser=Stringpassword=Propertiesprop=newProperties();Connectionconn=null;try{加载属性文件prop.load(this.getClass().getClassLoader().getResourceAsStream(DBConfig.properties));driver=prop.getProperty(driver);url=prop.get

7、Property(url);user=prop.getProperty(user);password=prop.getProperty(password);Class.forName加载驱动Class.forName(driver);DriverManager获得连接conn=DriverManager.getConnection(url,user,password);returnconn;}catch(Exceptione){e.printStackTrace();}returnnull;}}Te

8、stCallableStatement.javapackagecom.michael.jdbc;importjava.sql.CallableStatement;importjava.sql.Connection;importjava.sql.ResultSet;importjava.sql.SQLException;publicclassTestCallableStatement{publicstaticvoidcall(){Connectionconn=newConnectionUtil().o

9、penConnection();try{CallableStatementcstmt=conn.prepareCall({callall_user()});ResultSetrs=cstmt.executeQuery();while(rs.next()){intid=rs.getInt(1);Stringuser=rs.getString(2);Stringpassword=rs.getString(3);intage=rs.getInt(4);System.out.