Name: cacd
URL: jdbc:microsoft:sqlserver:
//10.11.12.58:1433;user=sa;
password=cacd;
Driver ClassName:
com.microsoft.jdbc.sqlserver.SQLServerDriver
Initial Capacity: 3
Maximum Capacity: 10

Name: cacd
JNDI Name: cacd
Pool Name: cacd
(要与前面的相匹配！)

/*=============================*/

/* Table : techniquespec */

/*=============================*/

create table techniquespec
(
techniqueitem char(100) not null,
units char(10) null,
minvalue decimal(16,6) null,
maxvalue decimal(16,6) null,
types char(1) null,
signon char(1) null,
constraint PK_TECHNIQUESPEC
primary key (techniqueitem)
)

package cacdsystem;

import javax.ejb.*;
import java.util.*;

public interface TechniquespecHome
extends javax.ejb.EJBLocalHome
{
public Techniquespec create
(String techniqueitem) throws
CreateException;
public Collection findByTypes()
throws FinderException;
//添加的Finder方法
public Techniquespec
findByPrimaryKey(String techniqueitem)  
  throws FinderException;
}

package cacdsystem;

import javax.ejb.*;
import java.util.*;
import java.math.*;

public interface Techniquespec
extends javax.ejb.EJBLocalObject
{
public String getTechniqueitem();
public void setUnits(String units);
public String getUnits();
public void setMinvalue
(BigDecimal minvalue);
public BigDecimal getMinvalue();
public void setMaxvalue
(BigDecimal maxvalue);
public BigDecimal getMaxvalue();
public void setTypes(String types);
public String getTypes();
public void setSignon(String signon);
public String getSignon();
}

package cacdsystem;

import javax.ejb.*;

abstract public class
TechniquespecBean implements EntityBean
{
EntityContext entityContext;
public java.lang.String ejbCreate
(java.lang.String techniqueitem)  
throws CreateException
{
setTechniqueitem(techniqueitem);
return null;
}

public void ejbPostCreate
(java.lang.String techniqueitem)
throws CreateException
{
}

public void ejbRemove()
throws RemoveException
{
}

public abstract void setTechniqueitem
(java.lang.String techniqueitem);
public abstract void setUnits
(java.lang.String units);
public abstract void setMinvalue
(java.math.BigDecimal minvalue);
public abstract void setMaxvalue
(java.math.BigDecimal maxvalue);
public abstract void setTypes
(java.lang.String types);
public abstract void setSignon
(java.lang.String signon);
public abstract java.lang.String
getTechniqueitem();
public abstract java.lang.String
getUnits();
public abstract
java.math.BigDecimal getMinvalue();
public abstract
java.math.BigDecimal getMaxvalue();
public abstract
java.lang.String getTypes();
public abstract
java.lang.String getSignon();

public void ejbLoad()
{
}

public void ejbStore()
{
}

public void ejbActivate()
{
}

public void ejbPassivate()
{
}

public void unsetEntityContext()
{
this.entityContext = null;
}

public void setEntityContext
(EntityContext entityContext)
{
this.entityContext = entityContext;
}
}

package cacdsystem;

import javax.ejb.*;
import java.util.*;
import java.rmi.*;

public interface VocHome
extends javax.ejb.EJBHome
{
public Voc create() throws
CreateException, RemoteException;
}

package cacdsystem;

import javax.ejb.*;
import java.util.*;
import java.rmi.*;

public interface Voc extends
javax.ejb.EJBObject
{
public Collection getVocTechnique()
throws RemoteException;
}

package cacdsystem;

import javax.ejb.*;
import java.util.*;

public class VocBean
implements SessionBean
{
SessionContext sessionContext;

TechniquespecHome techniquespecHome;
public void ejbCreate()
throws CreateException
{
}

public void ejbRemove()
{
}

public void ejbActivate()
{
}

public void ejbPassivate()
{
}

public void setSessionContext
(SessionContext sessionContext)
{
this.sessionContext = sessionContext;
try
{
javax.naming.Context context =
new javax.naming.InitialContext();
techniquespecHome =
(TechniquespecHome)
context.lookup("Techniquespec");
}
catch (Exception ex)
{
System.out.println
("Techniquespecs调用出错！");
throw new EJBException(ex);
}
}

public java.util.Collection
getVocTechnique()
{
/**@todo Complete this method*/
/**
* 获得全部技术需求项函数！
*/
System.out.println("调用getVocTechnique()!");
java.util.Collection collection = null;
java.util.List results = new ArrayList();

try
{
collection= techniquespecHome.findByTypes();
if(collection.size() > 0)
{
System.out.println(collection.size());
Iterator iter = collection.iterator();
String tempStr = null;
Techniquespec techniqu = null;
while(iter.hasNext())
{
techniqu = (Techniquespec) iter.next();
tempStr = techniqu.getTechniqueitem();
tempStr = charASC.chinTOISO(tempStr);
results.add(tempStr);
}
}
}
catch (Exception ex)
{
ex.printStackTrace();
throw new EJBException(ex);
}
return results;
}
}

package cacdsystem;

public class charASC
{
static private String
results = null;
public charASC()
{
}

static public String
chinTOISO(String temp)
{
if(temp == null)
{
results = "";
}
else
{
try
{
results = new String
(temp.getBytes("ISO-8859-1"),"gb2312");
results = results.trim();
}
catch(Exception ee)
{
System.out.println("中文转换失败!");
}
}
return results;
}
}

<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.text.*" %>
<%@page import="java.util.*"%>
<%@page import="java.sql.*" %>
<%@page import="javax.naming.*" %>
<%@page import="java.lang.*" %>
<%@page import="javax.rmi.
PortableRemoteObject" %>
<%@page import="javax.ejb.* "%>
<%@page import="cacdsystem.*"%>

<html>
<head>
<title>产品技术需求提取</title>
<meta http-equiv="Content-Type"
content="text/html; charset=gb2312">
</head>
<body>
<form id=form name=form1 method=post>
<input type=hidden id=pageFlag
name=pageFlag value='input'>
<table cellSpacing=0 cellPadding=0
width="98%" border=0 align=center >
<tr height=30 class=titleFont>
<td><font color='#0058a5'>
您所在位置:产品技术需求提取</font></td>
</tr>
<tr height=1 class=titleFont>
<td></td>
</tr>
</table>

<table width="98%" border="0"
bgcolor='#999999' align=center>
<tr>
<td><b> <font color="#ffffff">
产品技术需求提取</font></b></td>
</tr>
</table>

<table width="98%" border="1"
align=center bgcolor="#f0f0f0"
bordercolor='#ffffff' cellspacing=0
cellpadding=0 class=titleFont>
<tr bgcolor='#e0e8f8'>
<td> </td>
</tr>

<%
InitialContext ctx =
new InitialContext();
VocHome vocHome =
(VocHome)PortableRemoteObject.narrow
(ctx.lookup("Voc"),VocHome.class);
Voc voc = vocHome.create();
Collection collection = voc.getVocTechnique();
if(collection.size() > 0)
{
Iterator iters = collection.iterator();
int i = 0;
while(iters.hasNext())
{
++i;
%>

<tr>
<td><input type='checkbox'
name=<%= "select"+i %>
value=<%= i %>><%=
(String)iters.next() %><br></td>
</tr>

<%
}
}
%>

<%
voc.remove();
%>

<tr bgcolor='#e0e8f8' align=middle>
<td>
<p align=left></p>
</td>
</tr>

<tr align=middle>
<td>
<input type=submit id=submit1
name=submit1 value="提 交">
<input type=reset id=submit1
name=submit value="重 置">
</td>
</tr>
</table>
</form>
</body>
</html>

<session>
<display-name>Voc</display-name>
<ejb-name>Voc</ejb-name>
<home>cacdsystem.VocHome</home>
<remote>cacdsystem.Voc</remote>
<ejb-class>cacdsystem.VocBean</ejb-class>
<session-type>Stateless</session-type>
<transaction-type>Container</transaction-type>
<ejb-local-ref>
//手工添加的配置描述符代码！
<description />
<ejb-ref-name>Techniquespec</ejb-ref-name>
<ejb-ref-type>Entity</ejb-ref-type>
<local-home>cacdsystem.
TechniquespecHome</local-home>
<local>cacdsystem.Techniquespec</local>
<ejb-link>Techniquespec</ejb-link>
</ejb-local-ref>
</session>