<%@ page import="java.util.Date,yava.fileapp.*,java.sql.*;" 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); %> |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-29 15:23 , Processed in 0.178220 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.