Jsp网络购物系统

package ckstudio.db; import java.io.PrintStream; import java.sql.*; public class faq { String sDBDriver; String sConnStr; Connection conn; ResultSet rs; public faq() { sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; sConnStr = "jdbc:odbc:zsmshop"; //设置数据源 zsmshop conn = null; rs = null; try { Class.forName(sDBDriver); } catch(ClassNotFoundException classnotfoundexception) { System.err.println("faq(): " + classnotfoundexception.getMessage()); } } public void executeInsert(String s) { try { conn = DriverManager.getConnection(sConnStr); Statement statement = conn.createStatement(); int i = statement.executeUpdate(s); } catch(SQLException sqlexception) { System.err.println("faq.executeUpdate:" + sqlexception.getMessage()); } } public ResultSet executeQuery(String s) { rs = null; try { conn = DriverManager.getConnection(sConnStr); Statement statement = conn.createStatement(1004, 1008); rs = statement.executeQuery(s); } catch(SQLException sqlexception) { System.err.println("aq.executeQuery: " + sqlexception.getMessage()); } return rs; } public void executeDelete(String s) { try { conn = DriverManager.getConnection(sConnStr); Statement statement = conn.createStatement(); statement.executeUpdate(s); } catch(SQLException sqlexception) { System.err.println("faq.executeDelete: " + sqlexception.getMessage()); } } public int executeUpdate(String s) { int i = 0; try { conn = DriverManager.getConnection(sConnStr); Statement statement = conn.createStatement(); i = statement.executeUpdate(s); } catch(SQLException sqlexception) { System.err.println("faq.executeDelete: " + sqlexception.getMessage()); } return i; } public void Close() { try { if(rs != null) rs.close(); if(conn != null) conn.close(); } catch(SQLException sqlexception) { System.err.println("faq.executeDelete: " + sqlexception.getMessage()); } } }