FloatWindowContent.jsp
3.23 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="weaver.conn.ConnStatement"%>
<%@ page import="oracle.sql.CLOB"%>
<%@ page import="java.io.*" %>
<jsp:useBean id="rs_DocContent" class="weaver.conn.RecordSet" scope="page" />
<LINK href="/css/Weaver_wev8.css" type=text/css rel=STYLESHEET>
<SCRIPT language="javascript" src="/js/jquery/jquery_wev8.js"></script>
<script type="text/javascript" language="javascript" src="/FCKEditor/FCKEditorExt_wev8.js"></script>
<script type="text/javascript" language="javascript" src="/FCKEditor/swfobject_wev8.js"></script>
<style>
#spanContent A {
COLOR: blue; TEXT-DECORATION: underline
}
#spanContent A:hover {
COLOR: red; TEXT-DECORATION: underline
}
#spanContent A:link {
COLOR: blue; TEXT-DECORATION: underline
}
#spanContent A:visited {
TEXT-DECORATION: underline}
</style>
<table width="100%">
<tr>
<td> </td>
<td>
<span id="spanContent">
<%
int floatid=Util.getIntValue(request.getParameter("docid"),0);
String strSql_DocContent="";
String floatContent="";
ConnStatement statement=null;
try{
statement=new ConnStatement();
if(("oracle").equals(rs_DocContent.getDBType())){
strSql_DocContent="select doccontent from docdetail d1,docdetailcontent d2 where d1.id=d2.docid and d1.id="+floatid;
statement.setStatementSql(strSql_DocContent, false);
statement.executeQuery();
if(statement.next()) {
CLOB theclob = statement.getClob("doccontent");
String readline = "";
StringBuffer clobStrBuff = new StringBuffer("");
BufferedReader clobin = new BufferedReader(theclob.getCharacterStream());
while ((readline = clobin.readLine()) != null) clobStrBuff = clobStrBuff.append(readline);
clobin.close() ;
floatContent = clobStrBuff.toString();
}
} else if(("mysql").equals(rs_DocContent.getDBType())){
strSql_DocContent="select doccontent from docdetail d1,docdetailcontent d2 where d1.id=d2.docid and d1.id="+floatid;
statement.setStatementSql(strSql_DocContent, false);
statement.executeQuery();
if(statement.next()) {
CLOB theclob = statement.getClob("doccontent");
String readline = "";
StringBuffer clobStrBuff = new StringBuffer("");
BufferedReader clobin = new BufferedReader(theclob.getCharacterStream());
while ((readline = clobin.readLine()) != null) clobStrBuff = clobStrBuff.append(readline);
clobin.close() ;
floatContent = clobStrBuff.toString();
}
}else{
strSql_DocContent="select doccontent from docdetail where id="+floatid;
statement.setStatementSql(strSql_DocContent, false);
statement.executeQuery();
if(statement.next()) floatContent=statement.getString("doccontent");
}
}catch (Exception e){
e.printStackTrace();
}finally {
if(statement!=null){
statement.close();
}
}
if(!"".equals(floatContent)){
String disptmp = "";
int tmppos = floatContent.indexOf("!@#$%^&*");
if(tmppos!=-1) {
floatContent = floatContent.substring(tmppos+8);
}
}
if(!"".equals(floatContent)){
out.println(floatContent);
}
%>
</span>
</td>
</tr>
</table>
<script>
$(document).ready(function(){
$("a[target='_self']").attr("target","_blank")
});
</script>