复制代码 代码如下:
contenttype=text/html;charset=gb2312 pageencoding=gb2312
%>
cdatasource ds=new cdatasource(); //数据联结bean实例
java.sql.connection conn=ds.getconnection();
java.sql.statement stmt=null;
java.sql.resultset rs=null;
cdatacheck dc=new cdatacheck();
%>
string sqlu=select t1.fno, t1.fname, t2.fname as fdept from tuser t1 left outer join tdept t2 on t1.fdept = t2.fno order by t2.fname;
stmt=conn.createstatement();
rs=stmt.executequery(sqlu);
%>
部门选择
人名选择