用JSP编写通用信息发布程序

作者：Eve Cole 更新时间：2009-07-02 17:12:41

信息发布界面

提供发布信息的交互界面，调用recordMessage.jsp程序。

sayMessage.jsp
信息发布

<身体>
<％@页面contentType=“text/html;字符集=GB2312”％ >

<％@页面语言=“java” import=“java.sql.＊”％>

<表单操作 =recordmessage.jsp 方法 =帖子名称 =sign>
<输入名称=dtkey类型=隐藏值=ta_routes>

<正文>

<正文>

<br> </文本区域><br> </TD><br> </TR></TBODY></TABLE></DIV></TD></TR><br> <TR><TDalign=middlecolspan=2nowrap><br> <input name=cmdcommit type=submit value="提交"><br> </td></tr></tbody></table><br> </形式></中心><br> <div></div></body></html><br><br><br>连接数据库<br><br>通过调用Java Bean连接Oracle数据库。<br><br> opDb.java<br><br>封装 ymbean； // java包<br><br>导入java.sql.＊；<br><br>公共类 opDb {<br><br>公共 opDb() { }<br><br>公共 ResultSetexecuteQuery(String sql)<br><br> {<br><br>结果集 rs = null;<br><br>语句 lstmt = null;<br><br>尝试 { lstmt = connectdb();<br><br> rs = lstmt.executeQuery(sql);<br><br> System.out.println(“executeQuery:”＋ sql);<br><br> } catch(SQLException ex) { return(null)； }<br><br>返回RS；<br><br> }<br><br>公共字符串executeUpdate（字符串sql）<br><br> {<br><br>结果集 rs = null;<br><br>语句 lstmt = null;<br><br>尝试 {<br><br> lstmt = connectdb();<br><br> lstmt.executeUpdate(sql);<br><br> System.out.println(“executeUpdate:”＋ sql);<br><br> lstmt.executeUpdate(“提交”);<br><br> }catch（SQLException 前）{}<br><br> return(“执行更新确定”);<br><br> }<br><br> //连接数据库<br><br>公共语句 connectdb()<br><br> { 语句 lstmt=null;<br><br>连接 conn=null;<br><br>最终字符串 connect_string=“ jdbc:oracle:thin:scott/tiger@192.168.0.1:1521:test” ;<br><br>最终字符串 driver_string=“ oracle.jdbc.driver。<br><br> Oracle 驱动程序”;<br><br>连接lconn；<br><br>尝试{ Class.forName(driverstr);<br><br> lconn=DriverManager.getConnection(connectstr);<br><br> lstmt=lconn.createStatement();<br><br> } catch (异常 e) { return(null);}<br><br>返回lstmt；<br><br> }<br><br> }//结束opDb.java<br></span>        </div>
    </div>
</section>
<footer class="footer_template">
    <div class="w12_box">
        <div class="clearfix">
            <div class="l_item">
                <img src="https://images.downcodes.com/newdown/images/down-logo-foot.png" alt="">
                <div class="f_icon">
                    <a href="https://www.facebook.com/"></a>
                    <a href="https://telegram.org/"></a>
                    <a href="https://www.tiktok.com/"></a>
                    <a href="https://www.youtube.com/"></a>
                </div>
            </div>
            <div class="r_item">
                <dl>
                    <dt>Products & Services</dt>
                    <dd><a href="javascript:;">Install APK</a></dd>
                    <dd><a href="javascript:;">APK signature verification</a></dd>
                    <dd><a href="javascript:;">APK Download Service</a></dd>
                </dl>
                <dl>
                    <dt>Company</dt>
                    <dd><a href="javascript:;">Developer Console</a></dd>
                    <dd><a href="javascript:;">Submit APK</a></dd>
                    <dd><a href="javascript:;">Monetization of traffic through downcodes</a></dd>
                </dl>
                <dl>
                    <dt>Legal</dt>
                    <dd><a href="javascript:;">About us</a></dd>
                    <dd><a href="javascript:;">Contact Us</a></dd>
                    <dd><a href="javascript:;">Cooperation</a></dd>
                </dl>
            </div>

</div>
        <p>© 2006-2024Copyright All rights reserves</p>
    </div>
</footer>

<script>
    var _paq = window._paq = window._paq || [];
    /* tracker methods like "setCustomDimension" should be called before "trackPageView" */
    _paq.push(['trackPageView']);
    _paq.push(['enableLinkTracking']);
    (function() {
        var u="//tongji.zhangwan.net/";
        _paq.push(['setTrackerUrl', u+'matomo.php']);
        _paq.push(['setSiteId', '3']);
        var d=document, g=d.createElement('script'), s=d.getElementsByTagName('script')[0];
        g.async=true; g.src=u+'matomo.js'; s.parentNode.insertBefore(g,s);
    })();
</script>


<script async src="https://www.googletagmanager.com/gtag/js?id=G-5D64MDP2H8"></script>
<script>
    window.dataLayer = window.dataLayer || [];
    function gtag(){dataLayer.push(arguments);}
    gtag('js', new Date());

gtag('config', 'G-5D64MDP2H8');
</script>
</body>
<script src="/newdown/js/jquery.js" type="text/javascript" charset="utf-8"></script>
<script src="/newdown/js/lazy.js" type="text/javascript" charset="utf-8"></script>
<script src="/newdown/js/index.js" type="text/javascript" charset="utf-8"></script>
</html>

线路名称：
<输入最大长度=100名称=路线名称大小=36>

显示序号：
<输入 maxlength=3 名称=routeno 大小=36>

游玩内容。文字超一行时，请敲击Enter键换行