membersql.java

用J2EE开发的网站,可以应用到图书馆,图书超市

package ksnb;
import java.sql.*;
import java.util.*;
import ksnb.conn;
public class MemberSql {
    Statement st;
    ResultSet rs;
    public conn c;
    public Connection con;
    public MemberSql() {

        try
        {
            c=new conn();
            con=c.getConncetion();
        }
        catch(Exception e)
        {}

    }



    public ResultSet Query_Member(String sql)
    {
        try
        {


            st=con.createStatement();
            rs=st.executeQuery(sql);
        }
        catch(Exception e)
        {
            System.out.println(e.toString());
        }
        return rs;

    }
    public int Delete_Query(String s)
    {
        int i=-1;
        try
        {

            st=con.createStatement();
            i=st.executeUpdate(s);
        }
        catch(Exception e)
        {
            System.out.println(e.toString());
        }
        return i;
    }
    public void close()
    {
        try {
            rs.close();
            st.close();
        } catch (SQLException ex) {
        }
    }
}