jsp message board source code 4: For beginners of jsp.

Author: precom (Cleaved Egg)
Among them
============================================
package ymbean;

import .*;
import .*;
import .*;
import ;
import ;

//I will not post the contents of other packages dsql and dutil anymore. Both functions used in this file are very simple

one
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

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

public void setinquire_num( String name ) { inquire_num =

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 = (sql);
("executeQuery: "+sql);
} catch(SQLException ex) { ("executeQuery: " +

());}
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();
(sql);
("executeUpdate: "+sql);
("commit");
}
catch(SQLException ex) { ("executeQuery: " + e

());
return(());
}
return("executeUpdate ok");
}

public Statement connectdb()
{

Statement lstmt=null;
Connection conn=null;

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

0.1:1521:clubdb";
final String driver_string="";
dsql mysql=new dsql();
lstmt=(driver_string,connect_string);
return lstmt;
}

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

final String driver_string="";
dsql mysql=new dsql();
lstmt=(driver_string,connect_string);
return lstmt;
}


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

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

)));
}

//========"/n" to "<br>" =====================================
// Remove the strange ones:
public String removeComment(String Content){
String makeContent=new String();
StringTokenizer strToken=new StringTokenizer(Content,"\n");
String tempToken=null;

while(()){
tempToken=();
if((":")!=0)
makeContent=makeContent+tempToken+"\n";
}
return makeContent;
}

//Convert /n to Enter<br>
public String addBr(String Content){
String makeContent=new String();
StringTokenizer strToken=new StringTokenizer(Content,"\n");
while(()){
makeContent=makeContent+"<br>"+();
}
return makeContent;
}

//Convert <br> to Enter/n
public String addCr(String Content){
String makeContent=new String();
StringTokenizer strToken=new StringTokenizer(Content,"<br>");
while(()){
makeContent=makeContent+"\n"+();
}
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(()) { (); return(true);}
else { ();return(false);}
}catch (Exception e) { return(false);}
}

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

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

}

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

======
public String getDeptSuper(String vp) //Get the moderator
{
String vst="Unknown";
try{
String sql="select administrator from club_cvcdept where deptno=

'"+vp+"'";
ResultSet rs = executeQuery(sql);
if(()) vst=(1);
();
} catch (Exception e) {}
return vst;
}
public String getDeptName(String vp) //Public name
{
String vst="Unknown";
try{
String sql="select deptnote from club_cvcdept where deptno='"+vp

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

public String getUserEmail(String vp) //Get community user email
{
String vst="Unknown";
try{
String sql="select email from club_users where username='"+vp+"'

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

public Object getaValue(String vp) //Get community user email and other
{
Object vst=null;
try{
String sql=vp;
ResultSet rs = executeQuery(sql);
if(()) vst=(1);
();
} catch (Exception e) {}
return vst;
}

public String getsValue(String vp) //Get community user email and other
{
String vst="";
try{
String sql=vp;
ResultSet rs = executeQuery(sql);
if(()) vst=(1);
();
} catch (Exception e) {}
return vst;
}


}//end