您可以使用INSERT查询将记录插入表中。
语法INSERTINTOTABLE_NAME(column1,column2,column3,...columnN)
VALUES(value1,value2,value3,...valueN);
Or,
INSERTINTOTABLE_NAMEVALUES(value1,value2,value3,...valueN);
要使用JDBC API将记录插入数据库的表中,您需要-
注册驱动程序:使用DriverManager类的registerDriver()方法注册驱动程序类。将驱动程序类名称作为参数传递给它。
建立连接:使用DriverManager类的getConnection()方法连接到数据库。将URL(字符串),用户名(字符串),密码(字符串)作为参数传递给它。
创建语句:使用Connection接口的createStatement()方法创建一个Statement对象。
执行查询:使用executeUpdate()Statement接口的方法执行查询。
让我们使用CREATE语句在Oracle数据库中创建一个带有名称调度的表,如下所示-CREATETABLEdispatches(
PRODUCTNAMEVARCHAR2(20),
CUSTOMERNAMEVARCHAR2(20),
DISPATCHDATEDATE,
DELIVERYTIMETIMESTAMP(6),
PRICENUMBER(38),
LOCATIONVARCHAR2(20)
);
以下JDBC程序建立与Oracle数据库的连接,并在Dispatches表中插入5条记录-
示例importjava.sql.Connection;
importjava.sql.Date;
importjava.sql.DriverManager;
importjava.sql.PreparedStatement;
importjava.sql.SQLException;
importjava.sql.Time;
publicclassInsertData_Oracle{
publicstaticvoidmain(Stringargs[])throwsSQLException{
//注册驱动程序
DriverManager.registerDriver(neworacle.jdbc.driver.OracleDriver());
//获得连接
StringoracleUrl="jdbc:oracle:thin:@localhost:1521/xe";
Connectioncon=DriverManager.getConnection(oracleUrl,"system","password");
System.out.println("Connectionestablished......");
//将值插入表格
Stringquery="INSERTINTOdispatchesVALUES(?,?,?,?,?,?)";
PreparedStatementpstmt=con.prepareStatement(query);
pstmt.setString(1,"Key-Board");
pstmt.setString(2,"Raja");
pstmt.setDate(3,newDate(1567315800000L));
pstmt.setTime(4,newTime(1567315800000L));
pstmt.setInt(5,7000);
pstmt.setString(6,"Hyderabad");
pstmt.execute();
pstmt.setString(1,"Earphones");
pstmt.setString(2,"Roja");
pstmt.setDate(3,newDate(1556688600000L));
pstmt.setTime(4,newTime(1556688600000L));
pstmt.setInt(5,2000);
pstmt.setString(6,"Vishakhapatnam");
pstmt.execute();
pstmt.setString(1,"Mouse");
pstmt.setString(2,"Puja");
pstmt.setDate(3,newDate(1551418199000L));
pstmt.setTime(4,newTime(1551418199000L));
pstmt.setInt(5,3000);
pstmt.setString(6,"Vijayawada");
pstmt.execute();
pstmt.setString(1,"Mobile");
pstmt.setString(2,"Vanaja");
pstmt.setDate(3,newDate(1551415252000L));
pstmt.setTime(4,newTime(1551415252000L));
pstmt.setInt(5,9000);
pstmt.setString(6,"Chennai");
pstmt.execute();
pstmt.setString(1,"Headset");
pstmt.setString(2,"Jalaja");
pstmt.setDate(3,newDate(1554529139000L));
pstmt.setTime(4,newTime(1554529139000L));
pstmt.setInt(5,6000);
pstmt.setString(6,"Goa");
pstmt.execute();
System.out.println("Recordsinserted......");
}
}
输出结果Connectionestablished......
Recordsinserted......
如果使用select语句验证分发表的内容,则可以在其中找到插入的记录,如下所示:SQL>select*fromdispatches;
PRODUCTNAMECUSTOMERNAMEDISPATCHDATEDELIVERYTIMEPRICELOCATION
------------------------------------------------------------------------------------------
Key-BoardRaja01-SEP-1901-SEP-1911.00.00.000000AM7001Hyderabad
EarphonesRoja01-MAY-1901-MAY-1911.00.00.000000AM2000Vishakhapatnam
MousePuja01-MAR-1901-MAR-1910.59.59.000000AM3000Vijayawada
MobileVanaja01-MAR-1901-MAR-1910.10.52.000000AM9001Chennai
HeadsetJalaja06-APR-1906-APR-1911.08.59.000000AM6000Goa