java 讀取world的圖片 並把圖片路徑存入資料庫

標籤：

package World;import java.io.File;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.FileOutputStream;import java.io.IOException;import java.util.List;import org.apache.poi.POIXMLDocument;import org.apache.poi.POIXMLTextExtractor;import org.apache.poi.openxml4j.opc.OPCPackage;import org.apache.poi.xwpf.extractor.XWPFWordExtractor;import org.apache.poi.xwpf.usermodel.XWPFDocument;import org.apache.poi.xwpf.usermodel.XWPFPictureData;import java.io.IOException;import java.io.InputStream;import java.io.Reader;import World.User;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;public class World {        public static void main(String[] args) {                   String connect ="";        String path ="d:\\123.docx";        File file = new File(path);        try {            FileInputStream fis = new FileInputStream(file);            XWPFDocument document = new XWPFDocument(fis);            XWPFWordExtractor xwpfWordExtractor = new XWPFWordExtractor(document);            String text = xwpfWordExtractor.getText();            System.out.println(text);            List<XWPFPictureData> picList = document.getAllPictures();            for (XWPFPictureData pic : picList) {                System.out.println(pic.getPictureType() + file.separator + pic.suggestFileExtension()                        +file.separator+pic.getFileName());                connect = pic.getPictureType() + file.separator + pic.suggestFileExtension()                        +file.separator+pic.getFileName();                byte[] bytev = pic.getData();                FileOutputStream fos = new FileOutputStream("d:\\WEB\\"+pic.getFileName());                 fos.write(bytev);            }            fis.close();                                                String resource = "conf.xml";            InputStream is = World.class.getClassLoader().getResourceAsStream(resource);            SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(is);            SqlSession session = sessionFactory.openSession();            String statement = "World.userMapper.insertUser1";            User user2 = new User();            user2.setName(text);            user2.setAge(connect);            int count = session.insert("World.userMapper.add", user2);            session.commit();            System.out.println(count);                                                                   } catch (IOException e) {            e.printStackTrace();        }            }}

 

java 讀取world的圖片 並把圖片路徑存入資料庫