一聚教程网:一个值得你收藏的教程网站

最新下载

热门教程

JSP记事本程序

时间:2008-01-12 编辑:简简单单 来源:一聚教程网

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 align="center" border=1>
   <tr>
    <td >
     <div align="right">Name:</div>
    </td>
    <td >
     <input type="text" name="name">
    </td>
   </tr>
   <tr>

热门栏目