import java.sql.Connection
import java.sql.DriverManager
import java.sql.PreparedStatement
import java.sql.ResultSet
import java.sql.SQLException
public class Oracle {
public static void main(String[] args) throws SQLException,
ClassNotFoundException {
Class.forName("oracle.jdbc.driver.OracleDriver")
String url = "jdbc:oracle:thin:@127.0.0.1:1521:test"
String user = "test"
String password = "test"
Connection conn = DriverManager.getConnection(url, user, password)
PreparedStatement ps = conn.prepareStatement("select * from emp")
ResultSet rs = ps.executeQuery()
while (rs.next()) {
System.out.println(rs.getObject(1))
}
rs.close()
ps.close()
conn.close()
}
}
你的这个问题根本就不需要触发器,你只需要更改数据库结构,将这个字段的默认值设置为getdate()就可以了。 然后insert数据库的时候,不用管这个字段,在insert之后这个字段自然就可以填入时间。class.forname("oracle.jdbc.driver.OracleDriver")//加载数据库驱动String url="jdbc:oracle:thin:@localhost:1521:db_name"
String sql="CREATE TABLE table(filed1 varchar2(2),filed2 varchar2(2))"
Connection conn=DriverManager.getConnection(url,"scott","tiger")//建立数据库连接
if(!conn.isClose()){
Statement stmt = conn.createStatement()
stmt.executeUPDATE(sql)//建立一个表
}