SQL主要程序设计语言
数据定义语言DDL(Data Definition Language) 如 create、alter、drop,
数据操作语言DML(Data Munipulation Language) 如 insert、update、delete,
数据控制语言DCL(Data Control Language) 如 grant、revoke
Connection conn = DBUtil.getConnection();
Statement st = null;
try {
conn.setAutoCommit(false); //关闭自动提交
st = conn.createStatement();
st.executeUpdate("alter table test rename column name to name2"); //①直接commit
st.executeUpdate("alter table test rename column address too address2"); //②故意将to写为too
conn.commit();
} catch (SQLException e) {