实战JBuilder7+WebLogic7存取MS SQL Server2000(一)
刘晓巍: [email protected] 第一次写文章,希望大家多多捧场,本文完全根据我的个人经验所写,如有错误,恳请大家指正!JBuilder7+WebLogic7 的配置
假设Jbuilder7和WebLogic7安装完毕,操作系统为:windows2000 server(SP2),数据库为: SQLServer2000(SP2)。 JBuilder7的配置:1. 修改环境变量TEMP和TMP 为不带空格的目录如:E:\winnt\temp2. 启动Jbuilder7,选择:Tools->Configure Servers3. 选中左侧的Weblogic Application Server 6.x+,选中右边的Enable Server4. 将General->Home Directory设为WebLogic7的Home Directory如:E:/bea/weblogic700/server,正常的话Jbuilder7将自动为你添好其他的项。5. 将Custom->JDK Installation Directory设为 JDK的安装目录,如:E:/bea/jdk131_026. 将Custom->BEA Home Directory设为WebLogic7的Home Director,如:E:/bea7. 将Custom->Domain Directory设为你的域目录,如:E:/bea/user_projects/mydomain8. 添好User name, Password ,Domain name, Server name后,单击OK退出。9. 选择:Tools->Enterprise Setup,单击CORBA页上的New, 按下表填写相应信息:Name for this configuration = WelLogic 7.0Path for ORB Tools = E:/bea/weblogic700/serverLibrary for Projects = WebLogic 6.x+ DeployIDL compiler command = idlj.exeCommnad option for output directory = E:\CORBAOutput(任意目录,不要有空格)单击OK退出。 10.选择Project->Default Project properties在Path页的Required libraries中将会看到WebLogic 6.x+ Client和WebLogic 6.x+ Deploy两项,如果没有,请检查以上步骤是否正确。 11.选择Server页,单击Single services for all service in project 在下拉列表中选择WebLogic Application Server 6.x+,但击OK退出,配置完毕。 WebLogic7的配置:1. 启动WebLogic72. 打开IE6,在地址栏中输入:http://localhost:7001/console3. 输入用户名和密码4. 在左边的目录树中选中Services->JDBC->Connection Pools,单击右侧的Configure a new JDBC Connection Pool.,输入以下信息:Configuration->General页:Name = SQL Server Connection PoolURL = jdbc:weblogic:mssqlserver4:northwind@localhostDriver classname = weblogic.jdbc.mssqlserver4.DriverProperties : user = sa Password = “” <- sa的密码单击Create建立连接池。Targets->Server页:将myserver(服务器名称)移至右侧的列表中,但击单击Apply5. 在左边的目录树中选中Services->JDBC->Data Sources(或者TXData Sources),单击右侧的Configure a new JDBC Connection Pool.,输入以下信息:Configuration->General页:Name = SQLServer Tx Data SourceJNDI Name = SQLServerPool Name = SQL Server Connection Pool选中Emulate Two-Phase Commit for non-XA Driver和Row Prefetch Enabled单击Create建立数据源。Targets->Server页:将myserver(服务器名称)移至右侧的列表中,但击单击Apply,配置完毕。实战1:连接SQLServer2000
1. 打开JBuilder7选择File->New project在Name栏中输入SQLServerDemo,Directory栏中输入存放路径(不要有空格),其他不变,单击Finish。2. 选择File->New,选择General->Application,单击OK。第一步,第二步和第三步都不用更改,直接Finish即可。3. 回到JBuilder7的集成开发环境中,单击右侧的Designer页设计窗体,在窗体中放入一个JscrollPane 和JtextArea 及三个按钮,双击第一个按钮输入以下代码: try { Class.forName("weblogic.jdbc.mssqlserver4.Driver"); Connection con = DriverManager.getConnection("jdbc:weblogic:mssqlserver4:northwind@localhost","sa","");//此处根据你的SQLServer帐户而定。 Statement st = con.createStatement(); ResultSet res = st.executeQuery("select * from employees"); String line = ""; while (res.next()) line = line + res.getString("title")+"\n"; jTextArea1.setText(line); con.close(); } catch (Exception ex) { jTextArea1.setText("error : "+ex.getMessage());}双击第二个按钮输入以下代码 Hashtable ht = new Hashtable(); ht.put(Context.INITIAL_CONTEXT_FACTORY,"weblogic.jndi.WLInitialContextFactory"); ht.put(Context.PROVIDER_URL,"t3://localhost:7001"); try { Context ctx = new InitialContext(ht); DataSource ds = (DataSource)ctx.lookup("SQLServer"); Connection con = ds.getConnection("system","12345678");//此处是WebLogic7的域用户和密码 Statement st = con.createStatement(); ResultSet res = st.executeQuery("select * from employees"); String line = ""; while (res.next()) line = line + res.getString("notes")+"\n"; jTextArea1.setText(line); con.close(); } catch (Exception ex) { jTextArea1.setText("error : "+ex.getMessage()); }运行WebLogic7,运行程序单击第一个按钮使用JDBC直接连接SQLServer并获取数据,单击第二个按钮使用DataSource连接SQLServer并获取数据。实战2:Session Bean
建立一个简单的Bean:1. 关闭所有工程:File->Close Projects2. 选择File->New project 在Name栏中输入HelloDemo,Directory栏中输入存放路径(不要有空格),其他不变,单击Finish。3. 选择File->New->Enterprise->EJB 2.0 Designer单击OK。在弹出的对话框中单击new建立一个Moudle,在Name中输入HelloMoudle单击OK关闭当前对话框,再次单击OK关闭对话框。4. 在右侧的工作区中单击右键选择:Create EJB->Session Bean,将Bean Name改为HelloBean5. 右键单击代表HelloBean的长方形,选择Add->Method按如下填写:Method Name = SayHelloReturn Type = java.lang.StringInput parameter 不添Interface = remote 6. 右键单击代表HelloBean的长方形,选择 View Bean Source 按如下填写SayHello(): public java.lang.String SayHello() { /**@todo Complete this method*/ return new String(“Hello World “); }7.按F9运行,在弹出的对话框中选择Run页,单击New,在configure name处填写Server Runtime Configuration,再选择Run->Server,单击OK关闭当前对话框,单击OK开始编译运行。运行起来之后在左上角的目录树中右键单击HelloModule选择:Deploy options for “HelloModule.jar”->Deploy来发布Bean。建立客户端:1. 选择File->New->Enterprise->EJB Test Client单击OK。选中Genrate method for Default remote interface calls with default arguments单击OK。2. 按如下填写main(): public static void main(String[] args) { HelloBeanTestClient1 client = new HelloBeanTestClient1(); // Use the client object to call one of the Home interface wrappers // above, to create a Remote interface reference to the bean. // If the return value is of the Remote interface type, you can use it // to access the remote interface methods. You can also just use the // client object to call the Remote interface wrappers. client.create(); System.out.println(client.SayHello()); } 选择Run->Run “HelloBeanTestClient1.java” using defaults运行。
刘晓巍: [email protected] 第一次写文章,希望大家多多捧场,本文完全根据我的个人经验所写,如有错误,恳请大家指正!JBuilder7+WebLogic7 的配置
假设Jbuilder7和WebLogic7安装完毕,操作系统为:windows2000 server(SP2),数据库为: SQLServer2000(SP2)。 JBuilder7的配置:1. 修改环境变量TEMP和TMP 为不带空格的目录如:E:\winnt\temp2. 启动Jbuilder7,选择:Tools->Configure Servers3. 选中左侧的Weblogic Application Server 6.x+,选中右边的Enable Server4. 将General->Home Directory设为WebLogic7的Home Directory如:E:/bea/weblogic700/server,正常的话Jbuilder7将自动为你添好其他的项。5. 将Custom->JDK Installation Directory设为 JDK的安装目录,如:E:/bea/jdk131_026. 将Custom->BEA Home Directory设为WebLogic7的Home Director,如:E:/bea7. 将Custom->Domain Directory设为你的域目录,如:E:/bea/user_projects/mydomain8. 添好User name, Password ,Domain name, Server name后,单击OK退出。9. 选择:Tools->Enterprise Setup,单击CORBA页上的New, 按下表填写相应信息:Name for this configuration = WelLogic 7.0Path for ORB Tools = E:/bea/weblogic700/serverLibrary for Projects = WebLogic 6.x+ DeployIDL compiler command = idlj.exeCommnad option for output directory = E:\CORBAOutput(任意目录,不要有空格)单击OK退出。 10.选择Project->Default Project properties在Path页的Required libraries中将会看到WebLogic 6.x+ Client和WebLogic 6.x+ Deploy两项,如果没有,请检查以上步骤是否正确。 11.选择Server页,单击Single services for all service in project 在下拉列表中选择WebLogic Application Server 6.x+,但击OK退出,配置完毕。 WebLogic7的配置:1. 启动WebLogic72. 打开IE6,在地址栏中输入:http://localhost:7001/console3. 输入用户名和密码4. 在左边的目录树中选中Services->JDBC->Connection Pools,单击右侧的Configure a new JDBC Connection Pool.,输入以下信息:Configuration->General页:Name = SQL Server Connection PoolURL = jdbc:weblogic:mssqlserver4:northwind@localhostDriver classname = weblogic.jdbc.mssqlserver4.DriverProperties : user = sa Password = “” <- sa的密码单击Create建立连接池。Targets->Server页:将myserver(服务器名称)移至右侧的列表中,但击单击Apply5. 在左边的目录树中选中Services->JDBC->Data Sources(或者TXData Sources),单击右侧的Configure a new JDBC Connection Pool.,输入以下信息:Configuration->General页:Name = SQLServer Tx Data SourceJNDI Name = SQLServerPool Name = SQL Server Connection Pool选中Emulate Two-Phase Commit for non-XA Driver和Row Prefetch Enabled单击Create建立数据源。Targets->Server页:将myserver(服务器名称)移至右侧的列表中,但击单击Apply,配置完毕。实战1:连接SQLServer2000
1. 打开JBuilder7选择File->New project在Name栏中输入SQLServerDemo,Directory栏中输入存放路径(不要有空格),其他不变,单击Finish。2. 选择File->New,选择General->Application,单击OK。第一步,第二步和第三步都不用更改,直接Finish即可。3. 回到JBuilder7的集成开发环境中,单击右侧的Designer页设计窗体,在窗体中放入一个JscrollPane 和JtextArea 及三个按钮,双击第一个按钮输入以下代码: try { Class.forName("weblogic.jdbc.mssqlserver4.Driver"); Connection con = DriverManager.getConnection("jdbc:weblogic:mssqlserver4:northwind@localhost","sa","");//此处根据你的SQLServer帐户而定。 Statement st = con.createStatement(); ResultSet res = st.executeQuery("select * from employees"); String line = ""; while (res.next()) line = line + res.getString("title")+"\n"; jTextArea1.setText(line); con.close(); } catch (Exception ex) { jTextArea1.setText("error : "+ex.getMessage());}双击第二个按钮输入以下代码 Hashtable ht = new Hashtable(); ht.put(Context.INITIAL_CONTEXT_FACTORY,"weblogic.jndi.WLInitialContextFactory"); ht.put(Context.PROVIDER_URL,"t3://localhost:7001"); try { Context ctx = new InitialContext(ht); DataSource ds = (DataSource)ctx.lookup("SQLServer"); Connection con = ds.getConnection("system","12345678");//此处是WebLogic7的域用户和密码 Statement st = con.createStatement(); ResultSet res = st.executeQuery("select * from employees"); String line = ""; while (res.next()) line = line + res.getString("notes")+"\n"; jTextArea1.setText(line); con.close(); } catch (Exception ex) { jTextArea1.setText("error : "+ex.getMessage()); }运行WebLogic7,运行程序单击第一个按钮使用JDBC直接连接SQLServer并获取数据,单击第二个按钮使用DataSource连接SQLServer并获取数据。实战2:Session Bean
建立一个简单的Bean:1. 关闭所有工程:File->Close Projects2. 选择File->New project 在Name栏中输入HelloDemo,Directory栏中输入存放路径(不要有空格),其他不变,单击Finish。3. 选择File->New->Enterprise->EJB 2.0 Designer单击OK。在弹出的对话框中单击new建立一个Moudle,在Name中输入HelloMoudle单击OK关闭当前对话框,再次单击OK关闭对话框。4. 在右侧的工作区中单击右键选择:Create EJB->Session Bean,将Bean Name改为HelloBean5. 右键单击代表HelloBean的长方形,选择Add->Method按如下填写:Method Name = SayHelloReturn Type = java.lang.StringInput parameter 不添Interface = remote 6. 右键单击代表HelloBean的长方形,选择 View Bean Source 按如下填写SayHello(): public java.lang.String SayHello() { /**@todo Complete this method*/ return new String(“Hello World “); }7.按F9运行,在弹出的对话框中选择Run页,单击New,在configure name处填写Server Runtime Configuration,再选择Run->Server,单击OK关闭当前对话框,单击OK开始编译运行。运行起来之后在左上角的目录树中右键单击HelloModule选择:Deploy options for “HelloModule.jar”->Deploy来发布Bean。建立客户端:1. 选择File->New->Enterprise->EJB Test Client单击OK。选中Genrate method for Default remote interface calls with default arguments单击OK。2. 按如下填写main(): public static void main(String[] args) { HelloBeanTestClient1 client = new HelloBeanTestClient1(); // Use the client object to call one of the Home interface wrappers // above, to create a Remote interface reference to the bean. // If the return value is of the Remote interface type, you can use it // to access the remote interface methods. You can also just use the // client object to call the Remote interface wrappers. client.create(); System.out.println(client.SayHello()); } 选择Run->Run “HelloBeanTestClient1.java” using defaults运行。
解决方案 »
- 求二进制数据给对象付值
- 用Struts2开发购物车,当用do文件时打不开,但系统显示有添加。。。
- 关于struts1表单验证问题
- 从jndi名称空间中获得一个数据源,出 Unable to get connection, DataSource invalid: "java.sql.SQLException: No suitable driver"
- myeclipse6.0能用weblogic8 吗
- 求助:HIBERNATE中如何从OBJECT里取数据???
- 一个部署时的问题
- java调用执行传参shell脚本的问题
- 请大家帮忙
- sts 创建springboot
- 今天是被HelloWorld把头弄大了!
- 在weblogic中建立连接池出现的问题,请相助
实战3:Entity Bean
配置Weblogic for SQL Server JDBC Driver :1. 选择:Tools->Enterprise Setup,单击Database Drivers页上的Add, 在弹出的对话框中单击New,. 在弹出的对话框中填写Name为WebLogic for SQL Server, Location选择User Home,单击Add按钮,选择weblogic.jar,例如:F:\bea\weblogic700\server\lib\weblogic.jar, 单击OK关闭当前对话框,可以看到WebLogic for SQL Server已被加入,单击OK关闭当前对话框,再次单击OK,配置完成。重起Jbuilder 7。 建立一个简单的CMP Entity Bean :1. 关闭所有工程:File->Close Projects2. 选择File->New project 3. 在Name栏中输入CMPDemo,Directory栏中输入存放路径(不要有空格),其他不变,单击Finish。4. 选择File->New->Enterprise->EJB Module单击OK。在弹出的对话框中,在Name中输入CMPMoudle, Version选择:EJB2.0 Compliant其余不变,单击OK关闭当前对话框。5. 右键单击屏幕左下角的DataSources,选择Import Schema From Database,在弹出的对话框中,按如下填写:选中 All Schemas和ViewsDriver选择weblogic.jdbc.mssqlserver4.DriverURL= jdbc:weblogic:mssqlserver4:northwind@localhost:1433UserName=saPassword=”” / /此处为sa密码JNDI Name= SQLServer单击OK,如果设置正缺的话,DataSources下将会出现名为SQLServer的Datasource6. 单击名为SQLServer的Datasource左边的加号将其展开,将会看到所有的表和视图。7. 右键单击Employees表,选择Create CMP 2.0 Entity Bean8. 单击代表Employees表的长方形顶部的Employees,在右侧弹出的面板中将Interfaces选为local/remote,选择File->Save All保存全部项目。9. 选择Project->Make ”CMPModule”, 编译成功后,右键单击左上角的CMPModule选择Deploy Options for ”CMPModule.jar”->Deploy,将其发布至Weblogic。 建立客户端:1. 选择File->New->Enterprise->EJB Test Client单击OK。选中Genrate method for Default remote interface calls with default arguments单击OK。3. 按如下填写main(): public static void main(String[] args) { EmployeesTestClient1 client = new EmployeesTestClient1(); client.findByPrimaryKey(new Integer(1)); if (client.employeesRemote == null) { System.out.println("Error in testRemoteCallsWithDefaultArguments(): " + ERROR_NULL_REMOTE); return ; } client.getEmployeeID(); client.getLastName(); client.getFirstName(); client.getTitle(); client.getTitleOfCourtesy(); client.getBirthDate(); client.getHireDate(); client.getAddress(); client.getCity(); client.getRegion(); client.getPostalCode(); client.getCountry(); client.getHomePhone(); client.getExtension(); client.getPhoto(); client.getNotes(); client.getReportsTo(); client.getPhotoPath(); }选择Run->Run “EmployeesBeanTestClient1.java” using defaults运行。------------------
实战JBuilder7+WebLogic7存取MS SQL Server2000(一)
刘晓巍: [email protected]
第二个是把多个包文件放在一起,如果你程序中需要,你可以在project的require lib中加入你需要的包