import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import lrapi.lr;
/**
* 注意JDK版本为1.6才可以
* classpath环境变量配置
*
*/
public class Actions
{
public static final String userName = "osoadata"; // 数据库用户名
public static final String pwd = "osoadata"; // 数据库密码
public static final String url = "jdbc:oracle:thin:@192.168.5.82:1521:orcl"; // 数据库连接地址
public static final String dirver = "oracle.jdbc.driver.OracleDriver"; // 数据库驱动
public static Connection connt=null; // 数据库连接对象
public static CallableStatement callStmt=null;
//数据库的连接加载放到init函数里面
public int init() throws Throwable {
try {
System.out.println("-------测试开始啦,宝贝们!!!");
Class.forName(dirver);
connt = DriverManager.getConnection(url, userName, pwd);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
throw new ClassNotFoundException("数据库驱动加载异常!");
} catch (SQLException e) {
throw new SQLException("数据库连接异常!");
}
return 0;
}//end of init
//主要执行数据库调用的代码逻辑
public int action() throws Throwable {
try {
callStmt = connt.prepareCall("{call TEST_MICHAEL_NOOUT(?,?,?,?)}");
// 参数index从1开始,依次 1,2,3...
callStmt.setString(1, "xiucaihua");
callStmt.setString(2, "xiucaihua");
callStmt.setDouble(3, 5000);
callStmt.setString(4, "www.baidu.com");
callStmt.execute();
System.out.println("-------测试结束,宝贝们!!!");
}catch (Exception e){
throw new Exception("数据库执行异常!!!");
}
return 0;
}//end of action
//end函数中存放关闭连接的操作
public int end() throws Throwable {
try {
if(connt!=null){
connt.close();
}
} catch (Exception e) {
e.printStackTrace();
}
try {
if(callStmt!=null){
callStmt.close();
}
} catch (Exception e) {
e.printStackTrace();
}
return 0;
}//end of end
}