java向oracle写数据报错,原因是主键,我确实设了主键,输入数据也会重复,我希望的效果是,要导入一批数据,数据源确实可能重复,但是到数据库中不能重复,即重复数据不进数据库,但是java这边不要报错,允许重复数据插入失败。
简化代码大致是这样的,我对于try和 exception之类的不了解,刚开始
import java.sql.*;
public class OracleSelect
{
public static void main(String[] args) throws Exception
{
Class.forName("oracle.jdbc.driver.OracleDriver");
try(
Connection conn = DriverManager.getConnection(
"jdbc:oracle:thin:@114.212.127.77:1521:orcl"
,"Traffic","123456");
Statement stmt = conn.createStatement();
)
{
String sql = "insert into TAXIDATA values(3584098030,118753752,31999163,1,282,to_date('01-31-2013 06:59:44','MM-DD-YYYY HH24:MI:SS'),0,1 )";
stmt.executeUpdate(sql);
ResultSet rs = stmt.executeQuery("SELECT ID, M_location_x, M_location_y, M_speed, M_dircetion, Time, Time, Passenger_status, GPS_status FROM TAXIDATA");
System.out.println("ok");
}
}
}