目录

ireport连接Oracle数据库

目录

ireport连接Oracle数据库

最近项目中遇到打印需求,在网上查询打印软件,最后还是选择ireport打印,因为是免费,把ireport打印总结一下,方便以后在其它项目遇到打印需求,可以快速开发。

目录

  1. 添加oracle驱动jar 如下

    第一步 在导航栏点击【工具】下拉框【选项】 如图

    https://img-blog.csdn.net/20171231150147125?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvem91bGlwaW5nMTIzNDU2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast

    第二步 点击 Add JAR 添加jar包 如图

    https://img-blog.csdn.net/20171231150529750?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvem91bGlwaW5nMTIzNDU2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast

    第三步 在本地电脑找到oracle驱动jar 如图

    https://img-blog.csdn.net/20171231150759773?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvem91bGlwaW5nMTIzNDU2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast

    添加成功如图

    https://img-blog.csdn.net/20171231150907221?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvem91bGlwaW5nMTIzNDU2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast

    1. 连接数据库

      第一步 如图

      https://img-blog.csdn.net/20171231151309912?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvem91bGlwaW5nMTIzNDU2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast

      第二步 新增数据连接 如图

      https://img-blog.csdn.net/20171231151506926?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvem91bGlwaW5nMTIzNDU2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast

      第三步 添加数据库驱动 如图

      JDBC URL:jdbc:oracle:thin:@127.0.0.1:1521:orcl

      https://img-blog.csdn.net/20171231151909576?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvem91bGlwaW5nMTIzNDU2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast

      第四步 测试是否连接成功 如图

      https://img-blog.csdn.net/20171231152026519?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvem91bGlwaW5nMTIzNDU2/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast