连接数据库的类

            stmt = null;
        }
        if (prepstmt != null) {
            prepstmt.close();
            prepstmt = null;
        }
        conn.close();
        conn = null;
    }
}

 

//连接案例

<%@ page import="java.sql.*" %>
<jsp:useBean id="SQL" scope="session" class="net.asales.mysql.Mysql" />
sql = "SELECT * FROM table";

ResultSet rs = SQL.executeQuery(sql);

sql = "INSERT INTO table (id, name) values(', ')";

SQL.executeUpdate(sql);