已完结小说排行榜,女人书籍排行榜

主頁 > 知識庫 > jsp留言板源代碼四: 給jsp初學(xué)者.

jsp留言板源代碼四: 給jsp初學(xué)者.

作者: precom (皮蛋)
其中的opDb.java
============================================
package ymbean;

import java.sql.*;
import java.util.*;
import java.text.*;
import com.chinazjj.sql.dsql;
import com.chinazjj.util.dutil;

//其他的包dsql,dutil中的內(nèi)容我就不再貼了,在本文件中用到的兩個函數(shù)都很簡

單
public class opDb {

private String inquire_value="",inquire_item="",disptype="",inqtyp

e="";
private String inquire_num="",inquire_addr="",inquire_name="";
private dutil ldutil=new dutil();
public opDb() {

}

public void setinquire_item(String name) { inquire_item= name

;}
public void setinquire_value( String name ) { inquire_value = ldut

il.chineseToUnicode(name);}
public void setdisptype(String name) { disptype=name;}
public void setinqtype(String name) { inqtype=name;}

public void setinquire_num( String name ) { inquire_num = ldutil.c

hineseToUnicode(name);}
public void setinquire_addr( String name ) { inquire_addr = ldutil

.chineseToUnicode(name);}
public void setinquire_name( String name ) { inquire_name = ldutil

.chineseToUnicode(name);}

public String getinquire_dndata()
{
return "";
}

public ResultSet executeQuery(String sql)
{
ResultSet rs = null;
Statement lstmt = null;
try {
lstmt = connectdb();
rs = lstmt.executeQuery(sql);
System.out.println("executeQuery: "+sql);
} catch(SQLException ex) { System.err.println("executeQuery: " +

ex.getMessage());}
return rs;
}

public Statement getStmt()
{
Statement lstmt = null;
lstmt = connectdb();
return lstmt;
}

public String executeUpdate(String sql)
{
ResultSet rs = null;
Statement lstmt = null;
try {
lstmt = connectdb();
lstmt.executeUpdate(sql);
System.out.println("executeUpdate: "+sql);
lstmt.executeUpdate("commit");
}
catch(SQLException ex) { System.err.println("executeQuery: " + e

x.getMessage());
return(ex.getMessage());
}
return("executeUpdate ok");
}

public Statement connectdb()
{

Statement lstmt=null;
Connection conn=null;

final String connect_string="jdbc:oracle:thin:scott/tiger@192.168.

0.1:1521:clubdb";
final String driver_string="oracle.jdbc.driver.OracleDriver";
dsql mysql=new dsql();
lstmt=mysql.dconnectdb(driver_string,connect_string);
return lstmt;
}

public Statement connectdb(String connect_string)
{
Statement lstmt=null;
Connection conn=null;

final String driver_string="oracle.jdbc.driver.OracleDriver";
dsql mysql=new dsql();
lstmt=mysql.dconnectdb(driver_string,connect_string);
return lstmt;
}

//=========other function ===================================

public String getCurrentDate(String ldateform)
{
return(new SimpleDateFormat(ldateform).format(new java.util.Date(

)));
}

//========"/n" to "br>" =====================================
//去掉奇怪的：
public String removeComment(String Content){
String makeContent=new String();
StringTokenizer strToken=new StringTokenizer(Content,"\n");
String tempToken=null;

while(strToken.hasMoreTokens()){
tempToken=strToken.nextToken();
if(tempToken.indexOf(":")!=0)
makeContent=makeContent+tempToken+"\n";
}
return makeContent;
}

//將/n轉(zhuǎn)換成為回車br>
public String addBr(String Content){
String makeContent=new String();
StringTokenizer strToken=new StringTokenizer(Content,"\n");
while(strToken.hasMoreTokens()){
makeContent=makeContent+"br>"+strToken.nextToken();
}
return makeContent;
}

//將br>轉(zhuǎn)換成為回車/n
public String addCr(String Content){
String makeContent=new String();
StringTokenizer strToken=new StringTokenizer(Content,"br>");
while(strToken.hasMoreTokens()){
makeContent=makeContent+"\n"+strToken.nextToken();
}
return makeContent;
}

//====================================================================

=====
public boolean getIdentify(String name1,String pwd1)
{
try
{
String sql="select * from club_users where username='" + name1 + "'

and password='" + pwd1 + "'";
ResultSet rs = executeQuery(sql);
if(rs.next()) { rs.close(); return(true);}
else { rs.close();return(false);}
}catch (Exception e) { return(false);}
}

public void counts(String pagename)
{
executeUpdate("update call_count set counts=counts + 1 where pagenam

e='"+pagename+"'");

}

//==================張家界市民虛擬社區(qū)管理============================

======
public String getDeptSuper(String vp) //取版主
{
String vst="未知";
try{
String sql="select administrator from club_cvcdept where deptno=

'"+vp+"'";
ResultSet rs = executeQuery(sql);
if(rs.next()) vst=rs.getString(1);
rs.close();
} catch (Exception e) {}
return vst;
}
public String getDeptName(String vp) //取版名
{
String vst="未知";
try{
String sql="select deptnote from club_cvcdept where deptno='"+vp

+"'";
ResultSet rs = executeQuery(sql);
if(rs.next()) vst=rs.getString(1);
rs.close();
} catch (Exception e) {}
return vst;
}

public String getUserEmail(String vp) //取社區(qū)用戶email
{
String vst="未知";
try{
String sql="select email from club_users where username='"+vp+"'

";
ResultSet rs = executeQuery(sql);
if(rs.next()) vst=rs.getString(1);
rs.close();
} catch (Exception e) {}
return vst;
}

public Object getaValue(String vp) //取社區(qū)用戶email及其他
{
Object vst=null;
try{
String sql=vp;
ResultSet rs = executeQuery(sql);
if(rs.next()) vst=rs.getObject(1);
rs.close();
} catch (Exception e) {}
return vst;
}

public String getsValue(String vp) //取社區(qū)用戶email及其他
{
String vst="";
try{
String sql=vp;
ResultSet rs = executeQuery(sql);
if(rs.next()) vst=rs.getString(1);
rs.close();
} catch (Exception e) {}
return vst;
}

}//end opDb.java

您可能感興趣的文章:

JS實現(xiàn)簡易留言板特效
JS實現(xiàn)留言板功能[樓層效果展示]
JS實現(xiàn)留言板功能
用ReactJS和Python的Flask框架編寫留言板的代碼示例
js使用DOM操作實現(xiàn)簡單留言板的方法
JS+CSS模擬可以無刷新顯示內(nèi)容的留言板實例
js 實現(xiàn)的可折疊留言板(附源碼下載)
本人ajax留言板的源程序不錯的應(yīng)用js
jsp留言板源代碼一: 給jsp初學(xué)者.
jsp留言板源代碼二: 給jsp初學(xué)者.
jsp留言板源代碼三: 給jsp初學(xué)者.
javascript實現(xiàn)留言板功能

標簽：肇慶紹興玉樹廣元潮州吳忠北海保定

巨人網(wǎng)絡(luò)通訊聲明：本文標題《jsp留言板源代碼四: 給jsp初學(xué)者.》，本文關(guān)鍵詞 jsp,留言板,源代碼,四,給,；如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問題，煩請?zhí)峁┫嚓P(guān)信息告之我們，我們將及時溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò)，涉及言論、版權(quán)與本站無關(guān)。

濮阳杆衣贸易有限公司

jsp留言板源代碼四: 給jsp初學(xué)者.