\自己找点jdbc的资料看不就明白了..还浪费分..
解决方案 »
- 关于lucene的BooleanQuery问题,请解决~
- struts2+ejb3.0 java.lang.ClassCastException
- 关于xfire的webservice的客户端
- WebSphere Studio application developer 开发
- 紧急求救!!!!!关于Hibernate3.0 使用clob的问题,以及引发的页面错误!!
- java如何操作pdf
- 为什么我的SSH项目在没有网络的情况下启动服务器会报错
- ant编译时可否将一个目录下的jar全部做为classpath
- Spring框架调用Web Service冒错什么原因?
- 怎么用Jbuilder9装入一个已经存在的Struts源程序
- 请问STRUTS里Tiles标签与template标签的区别?
- 新手向高手请教:jsp中的问题!
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.SQLException;/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2005</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class TCall {
public TCall() {
} public static String[] getSjdwStr(String dwdm,
Connection cnn) {
String dwStr[] = {"",""};
try {
CallableStatement st = cnn.prepareCall("{call oa_qx.p_sjdw(?,?,?)}");
st.setString(1, dwdm);
st.registerOutParameter(2,java.sql.Types.VARCHAR);
st.registerOutParameter(3,java.sql.Types.VARCHAR);
st.executeQuery();
dwStr[0] = st.getString(2);
dwStr[1] = st.getString(3);
st.close();
cnn.close(); } catch (SQLException e) {
System.out.println("无法检索数据!");
e.printStackTrace();
} finally {
try {
cnn.close();
} catch (SQLException e) {
System.out.println("无法关闭数据库连接!");
e.printStackTrace();
}
}
return dwStr;
}
public static String[] getSqlNeedStr(String dwdm,
Connection cnn) {
String[] dwStr = getSjdwStr(dwdm,cnn);
StringBuffer dwdmSb = new StringBuffer("");
StringBuffer dwmcSb = new StringBuffer("");
String[] s = dwStr[0].split(",");
for (int i = 0; i < s.length; i++) {
if (i < s.length - 1) {
dwdmSb.append("'").append(s[i]).append("',");
} else {
dwdmSb.append("'").append(s[i]).append("'");
} }
s = dwStr[1].split(",");
for (int i = 0; i < s.length; i++) {
if (i < s.length - 1) {
dwmcSb.append("'").append(s[i]).append("',");
} else {
dwmcSb.append("'").append(s[i]).append("'");
} }
String rtn[] = {dwdmSb.toString(), dwmcSb.toString()};
return rtn;
}
public static void main(String args[]) {
String dbUrl = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
String dbUserId = "aerooa";
String dbPasswd = "aerooa";
String dbDriver = "oracle.jdbc.driver.OracleDriver"; try {
Class.forName(dbDriver);
} catch (Exception e) {
System.out.println("Unable to load driver: " + e.getMessage());
System.exit(1);
} try {
Connection con = DriverManager.getConnection(dbUrl, dbUserId,
dbPasswd);
String[] sjdwdmStr = TCall.getSqlNeedStr("02", con); System.out.println(sjdwdmStr[0]);
System.out.println(sjdwdmStr[1]); con.close();
} catch (Exception e) {
e.printStackTrace();
} }
}