实战 php调用java类由java类读数据库完成相关操作(Inber Write)
实战 php调用java类由java类读数据库完成相关操作(Inber Write) 1 建立系统ODBC 数据源photo(本次使用的是Oracle 9i,详细配置如有不懂这处再和我联系)
2 编译DataBaseConnection.java文件 将其编译文件放入到PHP支持的类文件目录中
package com.inberkong.util;
/*******************************************************
* Programe File :复件缓冲池DataBaseConnection.java
* Creat Date :3/28/2005(MM-DD-YYYY)
* Creat By :InberKong(GongYingBin)
* LastModifyDate :3/28/2005(MM-DD-YYYY)
* ModifyBy :InberKong(GongYingBin)
* Function :Get the Oracle DataBaseConnectionPool
//一个用于查找数据源的工具类。
*******************************************************/
import java.sql.*;
//连接数据库的工具类。
public class DataBaseConnection
{
/**
*一个静态方法，返回一个数据库的连接。
*/
public static Connection getConnection()
{
Connection con=null;
try
{
Class.forName('sun.jdbc.odbc.JdbcOdbcDriver');
con=DriverManager.getConnection('jdbc:odbc:photo','photo','inberkong');//数据源连接信息
}
catch(Exception e)
{
e.printStackTrace();
}
return con;
}
}
3 编译读数据表的处理类同样将处理类放入PHP调用的Java类目录
这是一个读取用户角色表 返回用户与角色间关系的JS数组的处理类 GetUserRolseArray.java
注：读程序时不需要关心相关的表结构，可只关心整个调用的处理过程。
package com.inberkong.processBean;
import java.lang.*;
import java.sql.*;
import java.util.*;
import java.io.*;
import com.inberkong.util.DataBaseConnection;
public class GetUserRolseArray
{
private Connection conss;
private Statement stmtsss=null;
private Statement stmt2=null,stmt3=null;
private ResultSet rstsss=null;
private ResultSet rst2=null,rst3=null;
private String sqlss='';
private String sql2='',sql3='';
private String rString='';
private String ID,ID2;
private String NAME;
private int i=0;
public GetUserRolseArray()
{
try
{
this.conss=DataBaseConnection.getConnection();
}
catch(Exception e)
{
}
//DataBaseConnection.getConnection();
}
protected void finalize() throws Throwable
{
//
//super.finalize();
//System.out.println('inberkong');
closeCON();
}
public String getUserRolseArray() throws Exception
{
//exePtempfunction();
sqlss='SELECT ID,NAME FROM ADMIN WHERE 1=1 AND STATE!=0 AND USERTYPE!='0'
ORDER BY ID DESC';
//外部用户不参于后加角色管理
stmtsss=conss.createStatement();
rstsss=stmtsss.executeQuery(sqlss);
while (rstsss.next())
{
ID=rstsss.getString('ID');
ID2=ID;
NAME=rstsss.getString('NAME');
rString=rString+'\n'+'arr['+i+']=new BDSort
(''+ID+'','00',''+NAME+'','');';
i++;
sql3='select ID,NAME from ROLE_MANAGE where ID in( select ROLSEID
from USER_ROLSE_LINK where USERID='+ID2+') order by ID asc ';
stmt3=conss.createStatement();
rst3=stmt3.executeQuery(sql3);
while(rst3.next())
{
ID=rst3.getString('ID');
NAME=rst3.getString('NAME');
rString=rString+'\n'+'arr['+i+']=new BDSort
(''+ID+'',''+ID2+'',''+NAME+'','y');';
i++;
}
sql2='select ID,NAME from ROLE_MANAGE where ID not in(select
ROLSEID from USER_ROLSE_LINK where USERID='+ID2+') order by ID asc ';
stmt2=conss.createStatement();
rst2=stmt2.executeQuery(sql2);
while(rst2.next())
{
ID=rst2.getString('ID');
NAME=rst2.getString('NAME');
rString=rString+'\n'+'arr['+i+']=new BDSort
(''+ID+'',''+ID2+'',''+NAME+'','n');';
i++;
}
}
rstsss=null;
return rString;
}
public static void main(String[] args){
//测试如下
GetUserRolseArray obj1 = new GetUserRolseArray();
try
{
System.out.println(obj1.getUserRolseArray());
}
catch(Exception e)
{
//System.out.println(e);
}
return;
}
public void closeStmtSSS()throws Exception
{
stmtsss.close();
}
public void closeCON() throws Exception
{
if(!(conss.isClosed()))
conss.close();
}
}
4 PHP调用
testjava.php
<?php
$b=new Java('com.inberkong.processBean.GetUserRolseArray');
$x=$b->getUserRolseArray();
echo $x;
?>
调用结果：
arr[0]=new BDSort('186','00','dp2','');
arr[1]=new BDSort('44','186','店铺管理员','y');
arr[2]=new BDSort('42','186','超级管理员','n');
arr[3]=new BDSort('43','186','公告管理员','n');
arr[4]=new BDSort('87','186','测试普通管理员','n');
arr[5]=new BDSort('106','186','普通超管','n');
arr[6]=new BDSort('185','00','dp1','');
arr[7]=new BDSort('44','185','店铺管理员','y');
arr[8]=new BDSort('42','185','超级管理员','n');
arr[9]=new BDSort('43','185','公告管理员','n');
arr[10]=new BDSort('87','185','测试普通管理员','n');
arr[11]=new BDSort('106','185','普通超管','n');
arr[12]=new BDSort('146','00','chayue','');
arr[13]=new BDSort('44','146','店铺管理员','y');
arr[14]=new BDSort('42','146','超级管理员','n');
arr[15]=new BDSort('43','146','公告管理员','n');
arr[16]=new BDSort('87','146','测试普通管理员','n');
arr[17]=new BDSort('106','146','普通超管','n');
arr[18]=new BDSort('145','00','temp2','');
arr[19]=new BDSort('87','145','测试普通管理员','y');
arr[20]=new BDSort('42','145','超级管理员','n');
arr[21]=new BDSort('43','145','公告管理员','n');
arr[22]=new BDSort('44','145','店铺管理员','n');
arr[23]=new BDSort('106','145','普通超管','n');
arr[24]=new BDSort('20','00','cnbadmin','');
arr[25]=new BDSort('42','20','超级管理员','y');
arr[26]=new BDSort('43','20','公告管理员','n');
arr[27]=new BDSort('44','20','店铺管理员','n');
arr[28]=new BDSort('87','20','测试普通管理员','n');
arr[29]=new BDSort('106','20','普通超管','n');
arr[30]=new BDSort('1','00','inber','');
arr[31]=new BDSort('106','1','普通超管','y');
arr[32]=new BDSort('42','1','超级管理员','n');
arr[33]=new BDSort('43','1','公告管理员','n');
arr[34]=new BDSort('44','1','店铺管理员','n');
arr[35]=new BDSort('87','1','测试普通管理员','n');