接口:ClazzManage
package test.ejb.work;
public interface ClazzManage {
public int stdCount();
}
实现类:ClazzManageImpl
package test.ejb.work;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.ejb.Remote;
import javax.ejb.Stateless;
import test.ejb.dbconn.DBConn;
@Stateless(mappedName = "ClazzManageImpl")
@Remote({ ClazzManage.class })
public class ClazzManageImpl implements ClazzManage {
private DBConn dbc;
public ClazzManageImpl() {
dbc = new DBConn();
}
@Override
public int stdCount() {
int stdCount = 0;
String sql = "select sum(std_count) from clazz";
ResultSet rs = dbc.dbQuery(sql);
try {
if (rs.next()) {
stdCount = rs.getInt("sum(std_count)");
}
} catch (SQLException e) {
e.printStackTrace();
}
return stdCount;
}
public static void main(String[] args) {
ClazzManageImpl cmi = new ClazzManageImpl();
System.out.println(cmi.stdCount());
}
}
客户端:
package test.ejb.client;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import test.ejb.work.ClazzManage;
public class TestClient {
public static void main(String[] args) throws NamingException {
java.util.Properties prop = new java.util.Properties();
prop.setProperty(javax.naming.Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory");
prop.setProperty(javax.naming.Context.PROVIDER_URL, "t3://192.168.146.135:7001");
InitialContext ic = new InitialContext(prop);
ClazzManage cm = (ClazzManage) ic.lookup("ClazzManageImpl#test.ejb.work.ClazzManage");
System.out.println("Student's count is :" + cm.stdCount());
}
}