JAVA使用JDBC连接ORACLE数据库封装查询语句

独行侠谁也不带

已于 2022-12-30 22:37:47 修改

阅读量951

点赞数

分类专栏： JAVA全栈文章标签： java 数据库 sql

于 2022-12-30 21:27:44 首次发布

本文链接：https://blog.csdn.net/xielong8866/article/details/128500862

版权

这篇博客介绍了如何使用JAVA的JDBC连接ORACLE数据库，并封装了查询语句来统计表格的行数和列数。通过调用特定方法，可以实现对表的行数和列数的快速获取。

摘要由CSDN通过智能技术生成

import java.sql.*;
import java.util.*;
import java.util.Date;

public class DatabaseManupulate {
    public static void main(String[] args) throws ClassNotFoundException
    {
        databaseConnection();
    }

    public static void forEachIterator(List<Emp> list)
    {
        Iterator<Emp> i = list.iterator();
        while (i.hasNext())
        {
            Emp e = i.next();
        System.out.println("Empno   "+"Ename    "+"Job   "+"Mgr   "+"HireDate   "+"Sal   "+"Comm   "+"Deptno");
        System.out.println(e.getEmpno()+"   "+e.getEname()+"   "+e.getJob()+"   "+e.getMgr()+"   "+e.getHireDate()+"   "+e.getSal()+"   "+e.getComm()+"   "+e.getDeptno());
        }
    }

    public static void forEachAdvFor(List<Emp> list)
    {
        for(Emp e : list)
        {
            System.out.println(e.toString());
        }
    }

    public static void databaseConnection() throws ClassNotFoundException {
        
        //成员变量声明在try catch外面为了在finally中释放资源
        Connection conn = null;
        Statement s = null;
        ResultSet result = null;
        String sqlDeptAll = null;
        List<Emp> list = null;


        try
        {
            //1.注册驱动
            Class.forName("oracle.jdbc.OracleDriver");
            //2.获取驱动对象
            conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.10.150:1521:orcl11g","scott","scott");
            System.out.println(conn);
            //获取进行的sql
            s = conn.createStatement();
            //定义进行sql的内容
            sqlDeptAll = "select * from scott.emp";
            //获得结果集
            result = s.executeQuery(sqlDeptAll);

            ResultSetMetaData rsmd = result.getMetaData();

            //遍历结果集，封装对象
            list = new ArrayList<Emp>();
            while (result.next())
            {
                int empno = result.getInt(1);
                String ename = result.getString(2);
                String job