query_user.java

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

package ksnb;

import java.util.*;
import java.sql.*;
public class Query_User {

    ResultSet rs;
    Statement st;
    public conn c;
    public Connection con;
    public Query_User()
    {
        try
        {
            c=new conn();
            con=c.getConncetion();
        }
        catch(Exception e)
        {}
    }
    public ResultSet Q_User(String user,String passd)
    {

        try
        {

            st=con.createStatement();
           // rs=st.executeQuery("select * from Shop_Admin where Name=  " +user + " and Pwd=  "+passd );
            rs=st.executeQuery("select * from Shop_Admin where Name='" +user + "' and Pwd='"+passd+"'" );

        }
        catch(Exception e)
        {
            System.out.println(e.toString());
        }
        return rs;

    }



}