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＞
