用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>

遊玩內容。