jsp留言板源代码介绍
发布时间：2023-07-03 14:39:10 所属栏目：教程 来源：
导读：在学习了jsp的一些基本知识之后，错新技术频道小编在业余时间制作了jsp留言板源代码的制作方法，下面就让错新技术频道小编和你一起进入下文了解一下吧！
============================================
pack
============================================
pack
|
在学习了jsp的一些基本知识之后，错新技术频道小编在业余时间制作了jsp留言板源代码的制作方法，下面就让错新技术频道小编和你一起进入下文了解一下吧！ ============================================ package ymbean; import java.sql.*; import java.util.*; import java.text.*; import com.chinazjj.sql.dsql; import com.chinazjj.util.dutil; //其他的包dsql,dutil中的内容我就不再贴了,在本文件中用到的两个函数都很简 单 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 " " ===================================== //去掉奇怪的： 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转换成为回车 public String addBr(String Content){ String makeContent=new String(); StringTokenizer strToken=new StringTokenizer(Content,"/n"); while(strToken.hasMoreTokens()){ makeContent=makeContent+" "+strToken.nextToken(); } return makeContent; } //将 转换成为回车/n public String addCr(String Content){ String makeContent=new String(); StringTokenizer strToken=new StringTokenizer(Content," "); 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+"'"); } //==================张家界市民虚拟社区管理============================ ====== 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) //取社区用户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) //取社区用户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) //取社区用户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 （编辑：聊城站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
站长推荐
