Java连接SQLite（导入DLL方式）

最新推荐文章于 2023-08-28 14:03:47 发布

ichiko

最新推荐文章于 2023-08-28 14:03:47 发布

阅读量424

点赞数

分类专栏： Java 文章标签： sqlite dll java null jdbc session

本文链接：https://blog.csdn.net/ichiko/article/details/4746998

版权

32 篇文章 0 订阅

订阅专栏

/*从该网站下载 http://www.ch-werner.de/javasqlite/*/
/*导入其中的jar包，并把dll文件放在程序同级目录即可*/

       try {

            Class clz = Class.forName("SQLite.JDBCDriver");

            Connection conn = DriverManager.getConnection("jdbc:sqlite:/"+System.getProperty("user.dir")+"/RTCProfileStore.db");

            String sql = "select MSG_INFO1 from SESSION_MESSAGE_HISTORY ";

            PreparedStatement pst = conn.prepareStatement(sql);

            ResultSet rs = pst.executeQuery();

            if(rs.next()){

                InputStream is = null;

                is = rs.getBinaryStream("MSG_INFO1");

                JOptionPane.showMessageDialog(this, "ok");

        } catch (SQLException ex) {

            Logger.getLogger(MainLocal.class.getName()).log(Level.SEVERE, null, ex);

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

        } catch (ClassNotFoundException ex) {

            Logger.getLogger(MainLocal.class.getName()).log(Level.SEVERE, null, ex);

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

关注