JAVA连接oracle数据库，并执行查询

来源：互联网发布：淘宝客一键复制编辑：程序博客网时间：2024/05/16 08:47

1、创建数据库test1，包含t_id、t_name
create table test1( t_id number,t_name varchar(20));

2、下载oracle的jdbc，官网下载
3、代码：

package dao;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;public class DBUtil {    private static String user="xdd";    private static String password="xdd";    private static String url="jdbc:oracle:thin:@localhost:1521:orcl";    public static Connection getConnnection(){        Connection conn=null;        try {            Class.forName("oracle.jdbc.driver.OracleDriver");            conn=DriverManager.getConnection(url, user, password);        } catch (Exception e) {            // TODO Auto-generated catch block            e.printStackTrace();        }        return conn;    }    public static void main(String args[]){        Connection conn=DBUtil.getConnnection();        PreparedStatement psta=null;        ResultSet rs=null;        try {            psta=conn.prepareStatement("select * from test1");            rs=psta.executeQuery();            while(rs.next()){                int id=rs.getInt("t_id");                String name=rs.getString("t_name");                System.out.println("ID:"+id+","+"Name:"+name);            }        } catch (Exception e) {            // TODO Auto-generated catch block            e.printStackTrace();        }    }}

4、结果：
这里写图片描述

0 0