guestbook.java

来自「《jsp网站开发技术》中的源代码(清华大学出版社)」· Java 代码 · 共 49 行

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;
    }
}