صفحه بندی دیتابیس در جاوا

[cnmeysam]

این کلاسیه که برای صفحه بندی تعریف کردم

package Clas;









import java.sql.*;

import java.io.*;

import java.util.ArrayList;

import java.util.logging.Level;

import java.util.logging.Logger;

import javax.swing.JOptionPane;









public class classpaging {

    

    public static Connection con = null;

    public static Statement stmt = null;

    public static ResultSet resSet = null;

    public static String url = null;

    

    public static ResultSet getResultSet()

    {

        return resSet;

    }

    

    public static Connection getcoConnection()

    {

        return con;

    }

    

    public static boolean connect_to_db()

    {

        

        try

        {

            FileReader reader = new FileReader("Miscsied.dll");

            BufferedReader bfr = new BufferedReader(reader);

            String line;

            while ((line = bfr.readLine())!=null)

            {

                System.out.println(line);

                url = line;

            }

            reader.close();

            Class.forName("com.mysql.jdbc.Driver").newInstance  ();

            con = DriverManager.getConnection(url);

            return true;

        }

        catch (Exception e)

        {

            JOptionPane.showMessageDialog(null, e.getMessage());

            return false;

        }

    }

    

    public static boolean query_to_db( String _query)

    {

        try

        {

            stmt = con.createStatement();

            resSet = stmt.executeQuery(_query);

            if (resSet.next())

            {

                return true;

            }

            else

            {

                return false;

            }

            

        }

        catch (Exception e)

        {

            

            JOptionPane.showMessageDialog(null, e.getMessage());

            return false;

        }

    

    }

    

    

     

    

}