package cn.nagasoft.cms.total.action;

?

import java.sql.CallableStatement;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

?

?

public class T {

public static Connection getConnection() throws ClassNotFoundException, SQLException{

String url="jdbc:mysql://localhost:3306/cloud_record";

Class.forName("com.mysql.jdbc.Driver");

String a="root";String b="root";

Connection con=DriverManager.getConnection(url,a,b);

return con;

}

?

/**

* @param args

*/

public static void main(String[] args) {

? ?String sql = "{call firstPro(?,?)}";

? ?//获得连接

? ?Connection conn = null;

? ?CallableStatement stmt = null;

? ?//构造语句对象,传递过程及参数,返回结果

? ?try{

? ? ?conn = T.getConnection();// 工具类获得连接

? ? ?stmt = conn.prepareCall(sql);

? ? ?//输入参数,

? ? ?stmt.setInt(1, 1);

? ? ?//执行

? ? ?stmt.execute();

? ? ?//取出过程运行的结果,指定输出参数的位置

// ? ? ?String in = stmt.getString(1);

? ? ?String name = stmt.getString(2);

// ? ? ?System.out.println(in);

? ? ?System.out.println(name);

? ?}catch(Exception e){

? ? ?e.printStackTrace();

? ?}finally{

? ?//关闭资源

}

?

}

?

}

?