db_manager.java

来自「it s apriori algorithm source code in ja」· Java 代码 · 共 62 行

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package dm_lab1;

import com.mysql.jdbc.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.LinkedList;

/**
 *
 * @author smashdown
 */
public class DB_Manager {
    
    Connection conn = null;
    Statement stmt;
    
    int port = 3306;
    
    String url, id, pw;

    DB_Manager(String u, String i, String p)
    {
        url = u;
        id = i;
        pw = p;
       
    }
    LinkedList<String> ScanTable() throws Exception
    {
        LinkedList<String> r_value = new LinkedList<String>();
        String query = "SELECT items_bought FROM trans;";
        ResultSet rs = null;
        try{
            conn = DriverManager.getConnection(url,id,pw);
            stmt = (Statement)conn.createStatement();
            rs = stmt.executeQuery(query);
            while(rs.next())
            {
                String one_trans = rs.getString(1);
                r_value.addLast(one_trans);
                //System.out.print(one_trans + "\n");
            }
        
        }catch(Exception e){
            throw e;
        }
        finally
        {
            conn.close();
        }

        return r_value;
    }
}