jdbc步骤:
导入jdbc驱动包 加载驱动 常见数据库连接 创建数据库命令对象 创建sql命令 执行sql 关闭资源
常见的jdbc错误:
ClassNotFoundException: 驱动类未找到. java.sql.SQLException: No suitable driver found for :thin:@localhost:1521:orcl URL错误 java.sql.SQLException: ORA-01017: invalid username/password; logon denied 用户 名或密码错误 java.sql.SQLSyntaxErrorException: ORA-00900: 无效 SQL 语句 Sql语句错误 java.sql.SQLIntegrityConstraintViolationException: ORA-00001: 违反唯一约束条件 (SCOTT.PK_DEPT) 主键冲突
package com. insert;
import java. sql. Connection;
import java. sql. DriverManager;
import java. sql. SQLException;
import java. sql. Statement;
public class TestInsert1 {
public static void main ( String[ ] args) throws ClassNotFoundException, SQLException {
Class. forName ( "oracle.jdbc.driver.OracleDriver" ) ;
Connection conn= DriverManager. getConnection (
"jdbc:oracle:thin:@localhost:1521:orcl" , "scott" , "oracle" ) ;
Statement stmt= conn. createStatement ( ) ;
String sql= "insert into dept values (
'数据库列表数据1' , '数据库列表数据2' , '...' ) ";
int i= stmt. executeUpdate ( sql) ;
System. out. println ( "执行结果:" + i) ;
stmt. close ( ) ;
conn. close ( ) ;
}
}