public class DynamicCrud {
public static void main(String[] args) {
DynamicCrud dc = new DynamicCrud();
dc.add("中文",30);
}
Connection conn;
public void add(String name, int age) {
conn = ConnectionUtil.getOracleConn();
String sql = "insert into student1 (name,age) values (name=?,age=?)";
try {
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(2, name);
ps.setInt(3, age);
ps.execute();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}