Question

怎样在jsp网页中提交oracle数据库数据

Answer 1

Class.forName("oracle.jdbc.driver.OracleDriver");
con =DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.8:1521:orcl", "scott", "tiger");
stmt =con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
//利用SQL语句将数据新增至数据库
stmt.executeUpdate(//添加数据的sql语句);
con.setAutoCommit(true);
stmt.close();
con.close();
再去Oracle中用命令commit一下看看有没有数据！
Statament本来就是自动提交的！