JSP記事本程式

來源:互聯網
上載者:User
package guestbook;
import java.sql.*;
public class guestbook{
  String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
  String sConnStr = "jdbc:odbc:guestbook";
  Connection conn = null;
  ResultSet rs = null;
 
  public guestbook() {
try {
      Class.forName(sDBDriver);  
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("guestbook(): " + e.getMessage());
}
  }
  public void executeInsert(String sql) {
    try {
conn = DriverManager.getConnection(sConnStr);    
     Statement stmt = conn.createStatement();
     stmt.executeUpdate(sql);
    }
    catch(SQLException ex) {   
System.err.println("guestbook.executeUpdate: " + ex.getMessage());
    }
  }
  public ResultSet executeQuery(String sql) {
  rs = null;
    try {
conn = DriverManager.getConnection(sConnStr);    
     Statement stmt = conn.createStatement();
     rs = stmt.executeQuery(sql);
    }
    catch(SQLException ex) {   
System.err.println("guestbook.executeQuery: " + ex.getMessage());
    }
    return rs;
  }
}
<html>
<head>
<title>My First Jsp GuestBook</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#CCCCFF" vlink="#000000" alink="#666666">
<div align="center">
 <p><font size="7"><b><font size="+6">Jsp GuestBook</font></b></font></p>
 <form method="post" action="index.jsp">
  <table width="75%" align="center" border=1>
   <tr>
    <td width="30%">
     <div align="right">Name:</div>
    </td>
    <td width="70%">
     <input type="text" name="name">
    </td>
   </tr>
   <tr>
相關文章

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.