在网上找的例子,可以参考一些
create table examples
(
names varchar(10 ),
age number(3 ),
BirDate date default sysdate
)
执行insert时,只需要insert前两个字段,BirDate字段会自动用当前时间填充,如下:
insert into examples(names,age) values('helo',25);
下面是我举例子
创建的数据库表的SQLcreate table PERSON
(
PERSONID VARCHAR2(36) default sys_guid() not null,
NAME VARCHAR2(36),
AGE NUMBER,
BIRTHDAY DATE,
COMMON VARCHAR2(200)
)
执行插入SQL的方法
package hb.dom4j;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Iterator;
import org.dom4j.Document;
import org.dom4j.DocumentException;
import org.dom4j.Element;
import org.dom4j.io.SAXReader;
import org.junit.Test;
public class PrepareInsertDate {
private static String path = "C:\\hb\\hb.xml";
private static String tableName="person";
private static String dbName="orcl";
private static String username="huangbiao";//连接数据库的用户名
private static String password="huangbiao";//
private static String serverIP = "127.0.0.1";//数据库的IP地址
private static String serverPort = "1521";
@Test
public void testPesson(){
Connection conn = null;
PreparedStatement pre = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@"+serverIP+":"+serverPort+":"+dbName, username, password);
System.out.println("连接成功!");
String sql = "insert into person (PERSONID,NAME,AGE,BIRTHDAY,COMMON)values(?,?,?,?,?)";
pre = conn.prepareStatement(sql);
java.util.Date utilDate = new java.util.Date();
java.sql.Date date = new java.sql.Date( utilDate .getTime());
pre.setString(1, "1");
pre.setString(2, "huangbiao");
pre.setInt(3, 1);
pre.setDate(4, date);
pre.setString(5, "common");
pre.executeUpdate();
} catch (ClassNotFoundException e1) {
e1.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
if(pre!=null){
pre.close();
}
if(conn!=null){
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}