将ArrayList转化为Byte[] 存入mysql数据库，arraylistmysql

将ArrayList转化为Byte[] 存入mysql数据库，arraylistmysql

/** 
     * 将ArrayList转化为二进制数组 
     *  
     * @param list 
     *            ArrayList对象 
     * @return 二进制数组 
     */  
    public byte[] getInfoBytesFromObject(ArrayList<scrapMaterial> list) {  
        ByteArrayOutputStream arrayOutputStream = new ByteArrayOutputStream();  
        try {  
            ObjectOutputStream objectOutputStream = new ObjectOutputStream(  
                    arrayOutputStream);  
            objectOutputStream.writeObject(list);  
            objectOutputStream.flush();  
            byte[] data = arrayOutputStream.toByteArray();  
            objectOutputStream.close();  
            arrayOutputStream.close();  
            return data;  
        } catch (Exception e) {  
            // TODO Auto-generated catch block  
            e.printStackTrace();  
        }  
        return null;  
    } 
    
    /** 
     * 从二进制数组转换Arrayist对象 
     * @param bytes 二进制数组 
     * @return ArrayList返回对象 
     */  
    private ArrayList<scrapMaterial> getInfoListFromBytes(byte[] bytes) {  
        ByteArrayInputStream arrayInputStream = new ByteArrayInputStream(bytes);  
        try {  
            ObjectInputStream inputStream = new ObjectInputStream(  
                    arrayInputStream);  
            ArrayList<scrapMaterial> list = (ArrayList<scrapMaterial>) inputStream  
                    .readObject();  
            inputStream.close();  
            arrayInputStream.close();  
            return list;  
        } catch (Exception e) {  
            // TODO Auto-generated catch block  
            e.printStackTrace();  
        }  
        return null;  
    }  

经测试成功插入与查找想要的数据