⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 0198.htm

📁 精通struts源码,孙卫琴.经过更新后的,请查收,
💻 HTM
字号:
🔍 
<html>

<head>
<title>新时代软件教程:操作系统 主页制作 服务器 设计软件 网络技术 编程语言 文字编辑</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>
<!--
body, table {font-size: 9pt; font-family: 宋体}
a {text-decoration:none}
a:hover {color: red;text-decoration:underline}
.1  {background-color: rgb(245,245,245)}
-->
</style>
</head>
<p align="center"><script src="../../1.js"></script></a>
<p align="center"><big><strong>jsp留言板源代码四</strong></big></p>
<div align="right">---&nbsp;（文/皮蛋）</div>

<br>opDb.java&nbsp; <br>
============================================&nbsp; <br>
package&nbsp; ymbean;&nbsp; <br>
<br>
import&nbsp; java.sql.*;&nbsp; <br>
import&nbsp; java.util.*;&nbsp; <br>
import&nbsp; java.text.*;&nbsp; <br>
import&nbsp; com.chinazjj.sql.dsql;&nbsp; <br>
import&nbsp; com.chinazjj.util.dutil;&nbsp; <br>
<br>
//其他的包dsql,dutil中的内容我就不再贴了,在本文件中用到的两个函数都很简&nbsp; <br>
<br>
单&nbsp; <br>
public&nbsp; class&nbsp; opDb&nbsp; {&nbsp; <br>
<br>
private&nbsp; String&nbsp; inquire_value="",inquire_item="",disptype="",inqtyp&nbsp; <br>
<br>
e="";&nbsp; <br>
private&nbsp; String&nbsp; inquire_num="",inquire_addr="",inquire_name="";&nbsp; <br>
private&nbsp; dutil&nbsp; ldutil=new&nbsp; dutil();&nbsp; <br>
public&nbsp; opDb()&nbsp; {&nbsp; <br>
<br>
}&nbsp; <br>
<br>
public&nbsp; void&nbsp; setinquire_item(String&nbsp; name)&nbsp; {&nbsp; inquire_item=&nbsp; name&nbsp; <br>
<br>
;}&nbsp; <br>
public&nbsp; void&nbsp; setinquire_value(&nbsp; String&nbsp; name&nbsp; )&nbsp; {&nbsp; inquire_value&nbsp; =&nbsp; ldut&nbsp; <br>
<br>
il.chineseToUnicode(name);}&nbsp; <br>
public&nbsp; void&nbsp; setdisptype(String&nbsp; name)&nbsp; {&nbsp; disptype=name;}&nbsp; <br>
public&nbsp; void&nbsp; setinqtype(String&nbsp; name)&nbsp; {&nbsp; inqtype=name;}&nbsp; <br>
<br>
public&nbsp; void&nbsp; setinquire_num(&nbsp; String&nbsp; name&nbsp; )&nbsp; {&nbsp; inquire_num&nbsp; =&nbsp; ldutil.c&nbsp; <br>
<br>
hineseToUnicode(name);}&nbsp; <br>
public&nbsp; void&nbsp; setinquire_addr(&nbsp; String&nbsp; name&nbsp; )&nbsp; {&nbsp; inquire_addr&nbsp; =&nbsp; ldutil&nbsp; <br>
<br>
.chineseToUnicode(name);}&nbsp; <br>
public&nbsp; void&nbsp; setinquire_name(&nbsp; String&nbsp; name&nbsp; )&nbsp; {&nbsp; inquire_name&nbsp; =&nbsp; ldutil&nbsp; <br>
<br>
.chineseToUnicode(name);}&nbsp; <br>
<br>
public&nbsp; String&nbsp; getinquire_dndata()&nbsp; <br>
{&nbsp; <br>
return&nbsp; "";&nbsp; <br>
}&nbsp; <br>
<br>
public&nbsp; ResultSet&nbsp; executeQuery(String&nbsp; sql)&nbsp; <br>
{&nbsp; <br>
ResultSet&nbsp; rs&nbsp; =&nbsp; null;&nbsp; <br>
Statement&nbsp; lstmt&nbsp; =&nbsp; null;&nbsp; <br>
try&nbsp; {&nbsp; <br>
lstmt&nbsp; =&nbsp; connectdb();&nbsp; <br>
rs&nbsp; =&nbsp; lstmt.executeQuery(sql);&nbsp; <br>
System.out.println("executeQuery:&nbsp; "+sql);&nbsp; <br>
}&nbsp; catch(SQLException&nbsp; ex)&nbsp; {&nbsp; System.err.println("executeQuery:&nbsp; "&nbsp; +&nbsp; <br>
<br>
ex.getMessage());}&nbsp; <br>
return&nbsp; rs;&nbsp; <br>
}&nbsp; <br>
<br>
public&nbsp; Statement&nbsp; getStmt()&nbsp; <br>
{&nbsp; <br>
Statement&nbsp; lstmt&nbsp; =&nbsp; null;&nbsp; <br>
lstmt&nbsp; =&nbsp; connectdb();&nbsp; <br>
return&nbsp; lstmt;&nbsp; <br>
}&nbsp; <br>
<br>
public&nbsp; String&nbsp; executeUpdate(String&nbsp; sql)&nbsp; <br>
{&nbsp; <br>
ResultSet&nbsp; rs&nbsp; =&nbsp; null;&nbsp; <br>
Statement&nbsp; lstmt&nbsp; =&nbsp; null;&nbsp; <br>
try&nbsp; {&nbsp; <br>
lstmt&nbsp; =&nbsp; connectdb();&nbsp; <br>
lstmt.executeUpdate(sql);&nbsp; <br>
System.out.println("executeUpdate:&nbsp; "+sql);&nbsp; <br>
lstmt.executeUpdate("commit");&nbsp; <br>
}&nbsp; <br>
catch(SQLException&nbsp; ex)&nbsp; {&nbsp; System.err.println("executeQuery:&nbsp; "&nbsp; +&nbsp; e&nbsp; <br>
<br>
x.getMessage());&nbsp; <br>
return(ex.getMessage());&nbsp; <br>
}&nbsp; <br>
return("executeUpdate&nbsp; ok");&nbsp; <br>
}&nbsp; <br>
<br>
public&nbsp; Statement&nbsp; connectdb()&nbsp; <br>
{&nbsp; <br>
<br>
Statement&nbsp; lstmt=null;&nbsp; <br>
Connection&nbsp; conn=null;&nbsp; <br>
<br>
final&nbsp; String&nbsp; connect_string="jdbc:oracle:thin:scott/tiger@192.168.&nbsp; <br>
<br>
0.1:1521:clubdb";&nbsp; <br>
final&nbsp; String&nbsp; driver_string="oracle.jdbc.driver.OracleDriver";&nbsp; <br>
dsql&nbsp; mysql=new&nbsp; dsql();&nbsp; <br>
lstmt=mysql.dconnectdb(driver_string,connect_string);&nbsp; <br>
return&nbsp; lstmt;&nbsp; <br>
}&nbsp; <br>
<br>
public&nbsp; Statement&nbsp; connectdb(String&nbsp; connect_string)&nbsp; <br>
{&nbsp; <br>
Statement&nbsp; lstmt=null;&nbsp; <br>
Connection&nbsp; conn=null;&nbsp; <br>
<br>
final&nbsp; String&nbsp; driver_string="oracle.jdbc.driver.OracleDriver";&nbsp; <br>
dsql&nbsp; mysql=new&nbsp; dsql();&nbsp; <br>
lstmt=mysql.dconnectdb(driver_string,connect_string);&nbsp; <br>
return&nbsp; lstmt;&nbsp; <br>
}&nbsp; <br>
<br>
<br>
//=========other&nbsp; function&nbsp; ===================================&nbsp; <br>
<br>
public&nbsp; String&nbsp; getCurrentDate(String&nbsp; ldateform)&nbsp; <br>
{&nbsp; <br>
return(new&nbsp; SimpleDateFormat(ldateform).format(new&nbsp; java.util.Date(&nbsp; <br>
<br>
)));&nbsp; <br>
}&nbsp; <br>
<br>
//========"/n"&nbsp; to&nbsp; "&lt;br>"&nbsp; =====================================&nbsp; <br>
//去掉奇怪的：&nbsp; <br>
public&nbsp; String&nbsp; removeComment(String&nbsp; Content){&nbsp; <br>
String&nbsp; makeContent=new&nbsp; String();&nbsp; <br>
StringTokenizer&nbsp; strToken=new&nbsp; StringTokenizer(Content,"\n");&nbsp; <br>
String&nbsp; tempToken=null;&nbsp; <br>
<br>
while(strToken.hasMoreTokens()){&nbsp; <br>
tempToken=strToken.nextToken();&nbsp; <br>
if(tempToken.indexOf(":")!=0)&nbsp; <br>
makeContent=makeContent+tempToken+"\n";&nbsp; <br>
}&nbsp; <br>
return&nbsp; makeContent;&nbsp; <br>
}&nbsp; <br>
<br>
//将/n转换成为回车&lt;br>&nbsp; <br>
public&nbsp; String&nbsp; addBr(String&nbsp; Content){&nbsp; <br>
String&nbsp; makeContent=new&nbsp; String();&nbsp; <br>
StringTokenizer&nbsp; strToken=new&nbsp; StringTokenizer(Content,"\n");&nbsp; <br>
while(strToken.hasMoreTokens()){&nbsp; <br>
makeContent=makeContent+"&lt;br>"+strToken.nextToken();&nbsp; <br>
}&nbsp; <br>
return&nbsp; makeContent;&nbsp; <br>
}&nbsp; <br>
<br>
//将&lt;br>转换成为回车/n&nbsp; <br>
public&nbsp; String&nbsp; addCr(String&nbsp; Content){&nbsp; <br>
String&nbsp; makeContent=new&nbsp; String();&nbsp; <br>
StringTokenizer&nbsp; strToken=new&nbsp; StringTokenizer(Content,"&lt;br>");&nbsp; <br>
while(strToken.hasMoreTokens()){&nbsp; <br>
makeContent=makeContent+"\n"+strToken.nextToken();&nbsp; <br>
}&nbsp; <br>
return&nbsp; makeContent;&nbsp; <br>
}&nbsp; <br>
<br>
<br>
//====================================================================&nbsp; <br>
<br>
=====&nbsp; <br>
public&nbsp; boolean&nbsp; getIdentify(String&nbsp; name1,String&nbsp; pwd1)&nbsp; <br>
{&nbsp; <br>
try&nbsp; <br>
{&nbsp; <br>
String&nbsp; sql="select&nbsp; *&nbsp; from&nbsp; club_users&nbsp; where&nbsp; username='"&nbsp; +&nbsp; name1&nbsp; +&nbsp; "'&nbsp; <br>
<br>
and&nbsp; password='"&nbsp; +&nbsp; pwd1&nbsp; +&nbsp; "'";&nbsp; <br>
ResultSet&nbsp; rs&nbsp; =&nbsp; executeQuery(sql);&nbsp; <br>
if(rs.next())&nbsp; {&nbsp; rs.close();&nbsp; return(true);}&nbsp; <br>
else&nbsp; {&nbsp; rs.close();return(false);}&nbsp; <br>
}catch&nbsp; (Exception&nbsp; e)&nbsp; {&nbsp; return(false);}&nbsp; <br>
}&nbsp; <br>
<br>
public&nbsp; void&nbsp; counts(String&nbsp; pagename)&nbsp; <br>
{&nbsp; <br>
executeUpdate("update&nbsp; call_count&nbsp; set&nbsp; counts=counts&nbsp; +&nbsp; 1&nbsp; where&nbsp; pagenam&nbsp; <br>
<br>
e='"+pagename+"'");&nbsp; <br>
<br>
}&nbsp; <br>
<br>
//==================张家界市民虚拟社区管理============================&nbsp; <br>
<br>
======&nbsp; <br>
public&nbsp; String&nbsp; getDeptSuper(String&nbsp; vp)&nbsp; //取版主&nbsp; <br>
{&nbsp; <br>
String&nbsp; vst="未知";&nbsp; <br>
try{&nbsp; <br>
String&nbsp; sql="select&nbsp; administrator&nbsp; from&nbsp; club_cvcdept&nbsp; where&nbsp; deptno=&nbsp; <br>
<br>
'"+vp+"'";&nbsp; <br>
ResultSet&nbsp; rs&nbsp; =&nbsp; executeQuery(sql);&nbsp; <br>
if(rs.next())&nbsp; vst=rs.getString(1);&nbsp; <br>
rs.close();&nbsp; <br>
}&nbsp; catch&nbsp; (Exception&nbsp; e)&nbsp; {}&nbsp; <br>
return&nbsp; vst;&nbsp; <br>
}&nbsp; <br>
public&nbsp; String&nbsp; getDeptName(String&nbsp; vp)&nbsp; //取版名&nbsp; <br>
{&nbsp; <br>
String&nbsp; vst="未知";&nbsp; <br>
try{&nbsp; <br>
String&nbsp; sql="select&nbsp; deptnote&nbsp; from&nbsp; club_cvcdept&nbsp; where&nbsp; deptno='"+vp&nbsp; <br>
<br>
+"'";&nbsp; <br>
ResultSet&nbsp; rs&nbsp; =&nbsp; executeQuery(sql);&nbsp; <br>
if(rs.next())&nbsp; vst=rs.getString(1);&nbsp; <br>
rs.close();&nbsp; <br>
}&nbsp; catch&nbsp; (Exception&nbsp; e)&nbsp; {}&nbsp; <br>
return&nbsp; vst;&nbsp; <br>
}&nbsp; <br>
<br>
public&nbsp; String&nbsp; getUserEmail(String&nbsp; vp)&nbsp; //取社区用户email&nbsp; <br>
{&nbsp; <br>
String&nbsp; vst="未知";&nbsp; <br>
try{&nbsp; <br>
String&nbsp; sql="select&nbsp; email&nbsp; from&nbsp; club_users&nbsp; where&nbsp; username='"+vp+"'&nbsp; <br>
<br>
";&nbsp; <br>
ResultSet&nbsp; rs&nbsp; =&nbsp; executeQuery(sql);&nbsp; <br>
if(rs.next())&nbsp; vst=rs.getString(1);&nbsp; <br>
rs.close();&nbsp; <br>
}&nbsp; catch&nbsp; (Exception&nbsp; e)&nbsp; {}&nbsp; <br>
return&nbsp; vst;&nbsp; <br>
}&nbsp; <br>
<br>
public&nbsp; Object&nbsp; getaValue(String&nbsp; vp)&nbsp; //取社区用户email及其他&nbsp; <br>
{&nbsp; <br>
Object&nbsp; vst=null;&nbsp; <br>
try{&nbsp; <br>
String&nbsp; sql=vp;&nbsp; <br>
ResultSet&nbsp; rs&nbsp; =&nbsp; executeQuery(sql);&nbsp; <br>
if(rs.next())&nbsp; vst=rs.getObject(1);&nbsp; <br>
rs.close();&nbsp; <br>
}&nbsp; catch&nbsp; (Exception&nbsp; e)&nbsp; {}&nbsp; <br>
return&nbsp; vst;&nbsp; <br>
}&nbsp; <br>
<br>
public&nbsp; String&nbsp; getsValue(String&nbsp; vp)&nbsp; //取社区用户email及其他&nbsp; <br>
{&nbsp; <br>
String&nbsp; vst="";&nbsp; <br>
try{&nbsp; <br>
String&nbsp; sql=vp;&nbsp; <br>
ResultSet&nbsp; rs&nbsp; =&nbsp; executeQuery(sql);&nbsp; <br>
if(rs.next())&nbsp; vst=rs.getString(1);&nbsp; <br>
rs.close();&nbsp; <br>
}&nbsp; catch&nbsp; (Exception&nbsp; e)&nbsp; {}&nbsp; <br>
return&nbsp; vst;&nbsp; <br>
}&nbsp; <br>
<br>
<br>
}//end&nbsp; opDb.java&nbsp; <br>


  </table>
<p align="center"><script src="../../2.js"></script></a>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -