?? 0198.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">--- （文/皮蛋）</div>
<br>opDb.java <br>
============================================ <br>
package ymbean; <br>
<br>
import java.sql.*; <br>
import java.util.*; <br>
import java.text.*; <br>
import com.chinazjj.sql.dsql; <br>
import com.chinazjj.util.dutil; <br>
<br>
//其他的包dsql,dutil中的內容我就不再貼了,在本文件中用到的兩個函數都很簡 <br>
<br>
單 <br>
public class opDb { <br>
<br>
private String inquire_value="",inquire_item="",disptype="",inqtyp <br>
<br>
e=""; <br>
private String inquire_num="",inquire_addr="",inquire_name=""; <br>
private dutil ldutil=new dutil(); <br>
public opDb() { <br>
<br>
} <br>
<br>
public void setinquire_item(String name) { inquire_item= name <br>
<br>
;} <br>
public void setinquire_value( String name ) { inquire_value = ldut <br>
<br>
il.chineseToUnicode(name);} <br>
public void setdisptype(String name) { disptype=name;} <br>
public void setinqtype(String name) { inqtype=name;} <br>
<br>
public void setinquire_num( String name ) { inquire_num = ldutil.c <br>
<br>
hineseToUnicode(name);} <br>
public void setinquire_addr( String name ) { inquire_addr = ldutil <br>
<br>
.chineseToUnicode(name);} <br>
public void setinquire_name( String name ) { inquire_name = ldutil <br>
<br>
.chineseToUnicode(name);} <br>
<br>
public String getinquire_dndata() <br>
{ <br>
return ""; <br>
} <br>
<br>
public ResultSet executeQuery(String sql) <br>
{ <br>
ResultSet rs = null; <br>
Statement lstmt = null; <br>
try { <br>
lstmt = connectdb(); <br>
rs = lstmt.executeQuery(sql); <br>
System.out.println("executeQuery: "+sql); <br>
} catch(SQLException ex) { System.err.println("executeQuery: " + <br>
<br>
ex.getMessage());} <br>
return rs; <br>
} <br>
<br>
public Statement getStmt() <br>
{ <br>
Statement lstmt = null; <br>
lstmt = connectdb(); <br>
return lstmt; <br>
} <br>
<br>
public String executeUpdate(String sql) <br>
{ <br>
ResultSet rs = null; <br>
Statement lstmt = null; <br>
try { <br>
lstmt = connectdb(); <br>
lstmt.executeUpdate(sql); <br>
System.out.println("executeUpdate: "+sql); <br>
lstmt.executeUpdate("commit"); <br>
} <br>
catch(SQLException ex) { System.err.println("executeQuery: " + e <br>
<br>
x.getMessage()); <br>
return(ex.getMessage()); <br>
} <br>
return("executeUpdate ok"); <br>
} <br>
<br>
public Statement connectdb() <br>
{ <br>
<br>
Statement lstmt=null; <br>
Connection conn=null; <br>
<br>
final String connect_string="jdbc:oracle:thin:scott/tiger@192.168. <br>
<br>
0.1:1521:clubdb"; <br>
final String driver_string="oracle.jdbc.driver.OracleDriver"; <br>
dsql mysql=new dsql(); <br>
lstmt=mysql.dconnectdb(driver_string,connect_string); <br>
return lstmt; <br>
} <br>
<br>
public Statement connectdb(String connect_string) <br>
{ <br>
Statement lstmt=null; <br>
Connection conn=null; <br>
<br>
final String driver_string="oracle.jdbc.driver.OracleDriver"; <br>
dsql mysql=new dsql(); <br>
lstmt=mysql.dconnectdb(driver_string,connect_string); <br>
return lstmt; <br>
} <br>
<br>
<br>
//=========other function =================================== <br>
<br>
public String getCurrentDate(String ldateform) <br>
{ <br>
return(new SimpleDateFormat(ldateform).format(new java.util.Date( <br>
<br>
))); <br>
} <br>
<br>
//========"/n" to "<br>" ===================================== <br>
//去掉奇怪的： <br>
public String removeComment(String Content){ <br>
String makeContent=new String(); <br>
StringTokenizer strToken=new StringTokenizer(Content,"\n"); <br>
String tempToken=null; <br>
<br>
while(strToken.hasMoreTokens()){ <br>
tempToken=strToken.nextToken(); <br>
if(tempToken.indexOf(":")!=0) <br>
makeContent=makeContent+tempToken+"\n"; <br>
} <br>
return makeContent; <br>
} <br>
<br>
//將/n轉換成為回車<br> <br>
public String addBr(String Content){ <br>
String makeContent=new String(); <br>
StringTokenizer strToken=new StringTokenizer(Content,"\n"); <br>
while(strToken.hasMoreTokens()){ <br>
makeContent=makeContent+"<br>"+strToken.nextToken(); <br>
} <br>
return makeContent; <br>
} <br>
<br>
//將<br>轉換成為回車/n <br>
public String addCr(String Content){ <br>
String makeContent=new String(); <br>
StringTokenizer strToken=new StringTokenizer(Content,"<br>"); <br>
while(strToken.hasMoreTokens()){ <br>
makeContent=makeContent+"\n"+strToken.nextToken(); <br>
} <br>
return makeContent; <br>
} <br>
<br>
<br>
//==================================================================== <br>
<br>
===== <br>
public boolean getIdentify(String name1,String pwd1) <br>
{ <br>
try <br>
{ <br>
String sql="select * from club_users where username='" + name1 + "' <br>
<br>
and password='" + pwd1 + "'"; <br>
ResultSet rs = executeQuery(sql); <br>
if(rs.next()) { rs.close(); return(true);} <br>
else { rs.close();return(false);} <br>
}catch (Exception e) { return(false);} <br>
} <br>
<br>
public void counts(String pagename) <br>
{ <br>
executeUpdate("update call_count set counts=counts + 1 where pagenam <br>
<br>
e='"+pagename+"'"); <br>
<br>
} <br>
<br>
//==================張家界市民虛擬社區管理============================ <br>
<br>
====== <br>
public String getDeptSuper(String vp) //取版主 <br>
{ <br>
String vst="未知"; <br>
try{ <br>
String sql="select administrator from club_cvcdept where deptno= <br>
<br>
'"+vp+"'"; <br>
ResultSet rs = executeQuery(sql); <br>
if(rs.next()) vst=rs.getString(1); <br>
rs.close(); <br>
} catch (Exception e) {} <br>
return vst; <br>
} <br>
public String getDeptName(String vp) //取版名 <br>
{ <br>
String vst="未知"; <br>
try{ <br>
String sql="select deptnote from club_cvcdept where deptno='"+vp <br>
<br>
+"'"; <br>
ResultSet rs = executeQuery(sql); <br>
if(rs.next()) vst=rs.getString(1); <br>
rs.close(); <br>
} catch (Exception e) {} <br>
return vst; <br>
} <br>
<br>
public String getUserEmail(String vp) //取社區用戶email <br>
{ <br>
String vst="未知"; <br>
try{ <br>
String sql="select email from club_users where username='"+vp+"' <br>
<br>
"; <br>
ResultSet rs = executeQuery(sql); <br>
if(rs.next()) vst=rs.getString(1); <br>
rs.close(); <br>
} catch (Exception e) {} <br>
return vst; <br>
} <br>
<br>
public Object getaValue(String vp) //取社區用戶email及其他 <br>
{ <br>
Object vst=null; <br>
try{ <br>
String sql=vp; <br>
ResultSet rs = executeQuery(sql); <br>
if(rs.next()) vst=rs.getObject(1); <br>
rs.close(); <br>
} catch (Exception e) {} <br>
return vst; <br>
} <br>
<br>
public String getsValue(String vp) //取社區用戶email及其他 <br>
{ <br>
String vst=""; <br>
try{ <br>
String sql=vp; <br>
ResultSet rs = executeQuery(sql); <br>
if(rs.next()) vst=rs.getString(1); <br>
rs.close(); <br>
} catch (Exception e) {} <br>
return vst; <br>
} <br>
<br>
<br>
}//end opDb.java <br>
</table>
<p align="center"><script src="../../2.js"></script></a>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -