代码如下:
/////////////////////////////////////////////////////////////////////////////////
conn.javapackage mylib.test.ejb.connDB;import javax.ejb.*;
import java.sql.*;
import java.rmi.*;
public interface conn extends EJBObject { public ResultSet sqlQuery(String sqlStr) throws RemoteException,SQLException;}
/////////////////////////////////////////////////////////////////////////////////connHome.javapackage mylib.test.ejb.connDB;import java.rmi.*;
import javax.ejb.*;
public interface connHome extends EJBHome{ conn create() throws RemoteException,CreateException;}/////////////////////////////////////////////////////////////////////////////////connBean.javapackage mylib.test.ejb.connDB;import java.sql.*;
import mylib.util.db.*;
import javax.ejb.*;
public class connBean implements SessionBean { public connBean() {
}
public void ejbCreate(){}
public void ejbRemove(){}
public void ejbPassivate(){}
public void ejbActivate(){}
public void setSessionContext(SessionContext sc){} public ResultSet sqlQuery(String sqlStr) throws SQLException {
ResultSet rs ;
ConnectionParam cparam = new ConnectionParam("oracle.jdbc.driver.OracleDriver",
"jdbc:oracle:thin:@192.168.168.18:1521:orcl",
"user01",
"pwd01"
);
ConnectionFactory factory = null;
Connection conn = null;
try{
factory = new ConnectionFactory(cparam,new FactoryParam());
conn = factory.getFreeConnection();
}catch(Exception e){
e.printStackTrace();
} Statement stmp = conn.createStatement();
rs = stmp.executeQuery(sqlStr);
//stmp.close();
//factory.close();
return rs;
}}
/////////////////////////////////////////////////////////////////////////////////
conn.javapackage mylib.test.ejb.connDB;import javax.ejb.*;
import java.sql.*;
import java.rmi.*;
public interface conn extends EJBObject { public ResultSet sqlQuery(String sqlStr) throws RemoteException,SQLException;}
/////////////////////////////////////////////////////////////////////////////////connHome.javapackage mylib.test.ejb.connDB;import java.rmi.*;
import javax.ejb.*;
public interface connHome extends EJBHome{ conn create() throws RemoteException,CreateException;}/////////////////////////////////////////////////////////////////////////////////connBean.javapackage mylib.test.ejb.connDB;import java.sql.*;
import mylib.util.db.*;
import javax.ejb.*;
public class connBean implements SessionBean { public connBean() {
}
public void ejbCreate(){}
public void ejbRemove(){}
public void ejbPassivate(){}
public void ejbActivate(){}
public void setSessionContext(SessionContext sc){} public ResultSet sqlQuery(String sqlStr) throws SQLException {
ResultSet rs ;
ConnectionParam cparam = new ConnectionParam("oracle.jdbc.driver.OracleDriver",
"jdbc:oracle:thin:@192.168.168.18:1521:orcl",
"user01",
"pwd01"
);
ConnectionFactory factory = null;
Connection conn = null;
try{
factory = new ConnectionFactory(cparam,new FactoryParam());
conn = factory.getFreeConnection();
}catch(Exception e){
e.printStackTrace();
} Statement stmp = conn.createStatement();
rs = stmp.executeQuery(sqlStr);
//stmp.close();
//factory.close();
return rs;
}}
解决方案 »
- 使用hibernate注解生成Oracle的sequence如何在javabean中获得最新生成的序列
- Myeclipse 无法更新部署 发布过的文件和第一次加载进的一样
- Ext JS 中怎么设置前后两个日期相差一年时间?(如下代码中)
- struts2 上传类型
- freemark 关于取相对路径的问题
- 求J2EE高手!
- html 或是 jsp 页面有二级下拉菜单 想做成缓慢展开并且闭合的 求解!!!!
- 各位大虾,在树中能找到节点的第一个子节点吗????帮帮忙了,急!!!!!!!!!!!!回答立即结贴
- 30*24*60*60*1000等于多少
- ms_jdbc_setup.exe哪们提供一下载地址.不要从MS可SUM的很慢打不开
- weblogic服务器里面出现的问题!
- 哪位大虾能给我讲讲struts
index.jsp<%@ page language="java" contentType = "text/html;charset=gb2312"%>
<%@ page import="mylib.test.ejb.connDB.conn"%>
<%@ page import="mylib.test.ejb.connDB.connHome"%>
<%@ page import="java.sql.*,javax.ejb.*,javax.rmi.*,java.rmi.*,javax.naming.*"%><%
if(request.getMethod().equals("POST")){
conn conn1 = null;
try{
InitialContext ic = new InitialContext();
Object objRef = ic.lookup("java:comp/env/ejb/MyConnOracle");
connHome home = (connHome)PortableRemoteObject.narrow(objRef, connHome.class);
conn1 = home.create();
}catch(Exception e){
out.println(e.toString());
} String sqlStr = request.getParameter("sqlStr");
ResultSet rs = conn1.sqlQuery(sqlStr);
while(rs.next()){
out.println(rs.getString("com_reg_no"));
}}else{
%>
<form name="form1" action="./index.jsp" method="POST">
<input type="text" name="sqlStr" value="" size="100"><br><br><input type="submit" name="Submit" value="提 交">
</form>
<%
}
%>
http://java.sun.com/docs/books/tutorial/security1.2/index.html