3-6.txt

jsp常用实例讲解

package test;
import java.sql.*;
public class shop {
String sDBDriver =" sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr =" jdbc:odbc:shop";
Connection conn = null;
ResultSet rs = null;
public shop () {
try {
Class.forName(sDBDriver);
}
catch (java.lang.ClassNotFoundException e ) {
System.err.println("shop():" + e.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 " aq.executeQuery:" + ex.getMessage());
}
return rs;
}
}