使用jdbc更新、查询数据库实例

最新推荐文章于 2025-01-10 18:43:38 发布

原创最新推荐文章于 2025-01-10 18:43:38 发布 · 3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#jdbc #数据库 #string #exception #insert #oracle

Java 专栏收录该内容

27 篇文章

订阅专栏

本文提供了两个Java示例程序，分别演示如何使用JDBC插入记录到Oracle数据库中的person表，以及如何从该表中查询并打印所有记录的具体信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package org.oracle.insert;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class InsertDeom {
    public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";
    public static final String DBURL = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL";
    public static final String DBUSER = "scott";
    public static final String DBPASS = "tiger";
    
    

    public static void main(String[] args) throws Exception{
        
        Connection conn = null;
        Statement stmt = null;
                
        Class.forName(DBDRIVER);
        conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS);
        
        stmt = conn.createStatement();
        String sql = "insert into person(name,age,birthday,salary)values('王五',22,TO_Date('1986-2-22','yyyy-mm-dd'),4000)";
        stmt.executeUpdate(sql);    
        
        stmt.close();        
        conn.close();
        
        
    

    }

}

××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××××

package org.oracle.select;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class ResultDeom {
	public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver";
	public static final String DBURL = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL";
	public static final String DBUSER = "scott";
	public static final String DBPASS = "tiger";
	
	

	public static void main(String[] args) throws Exception{
		
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		
		Class.forName(DBDRIVER);
		conn = DriverManager.getConnection(DBURL, DBUSER, DBPASS);
		
		stmt = conn.createStatement();
//		stmt.executeUpdate("insert into person(name,age,birthday,salary)values('李四',22,TO_Date('1986-2-22','yyyy-mm-dd'),4000)");
		
		rs = stmt.executeQuery("select name,age,birthday,salary from person");
		
		while(rs.next()){
			System.out.print("name:"+rs.getString("name")+".   ");
			System.out.print("age:"+rs.getInt("age")+".   ");
			System.out.print("birthday:"+rs.getDate("birthday")+".   ");
			System.out.println("salary:"+rs.getFloat("salary")+".   ");
		}
		rs.close();
		stmt.close();		
		conn.close();
		
		
	

	}

}