jsp留言板源代码4

其中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中内容我就不再贴了,在本文件中用到两个都很简

单
public opDb {

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

e=\"\";
private String inquire_num=\"\",inquire_addr=\"\",inquire_name=\"\";
private dutil ldutil= dutil;
public opDb {

}

public void inquire_item(String name) { inquire_item= name

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

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

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

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

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

.chineseToUnicode(name);}

public String getinquire_dndata
{
\"\";
}

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

ex.getMessage);}
rs;
}

public Statement getStmt
{
Statement lstmt = null;
lstmt = connectdb;
lstmt;
}

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

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

public Statement connectdb
{

Statement lstmt=null;
Connection conn=null;

final String connect_=\"jdbc:oracle:thin:scott/[email protected].

0.1:1521:clubdb\";
final String driver_=\"oracle.jdbc.driver.OracleDriver\";
dsql mysql= dsql;
lstmt=mysql.dconnectdb(driver_,connect_);
lstmt;
}

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

final String driver_=\"oracle.jdbc.driver.OracleDriver\";
dsql mysql= dsql;
lstmt=mysql.dconnectdb(driver_,connect_);
lstmt;
}


//=other function =

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

)));
}

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

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

//将/n转换成为回车

public String addBr(String Content){
String makeContent= String;
StringTokenizer strToken= StringTokenizer(Content,\" \");
while(strToken.hasMoreTokens){
makeContent=makeContent+\"
\"+strToken.nextToken;
}
makeContent;
}

//将
转换成为回车/n
public String addCr(String Content){
String makeContent= String;
StringTokenizer strToken= StringTokenizer(Content,\"
\");
while(strToken.hasMoreTokens){
makeContent=makeContent+\" \"+strToken.nextToken;
}
makeContent;
}


//

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

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

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

e=\"+pagename+\"\");

}

//张家界市民虚拟社区管理


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

\"+vp+\"\";
ResultSet rs = executeQuery(sql);
(rs.next) vst=rs.getString(1);


rs.close;
} catch (Exception e) {}
vst;
}
public String getDeptName(String vp) //取版名
{
String vst=\"未知\";
try{
String sql=\"select deptnote from club_cvcdept where deptno=\"+vp

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

public String getUserEmail(String vp) //取社区用户email
{
String vst=\"未知\";
try{
String sql=\"select email from club_users where username=\"+vp+\"

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

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

public String getsValue(String vp) //取社区用户email及其他
{
String vst=\"\";
try{
String sql=vp;
ResultSet rs = executeQuery(sql);
(rs.next) vst=rs.getString(1);
rs.close;
} catch (Exception e) {}
vst;
}


}//end opDb.java