#ThemaximumamountofconcurrentsessionstheMySQLserverwill
#allow.Oneoftheseconnectionswillbereservedforauserwith
#SUPERprivilegestoallowtheadministratortologinevenifthe
#connectionlimithasbeenreached.
max_connections=100
BEFORE|AFTER
declare
……
begin
IS|AS
BEGIN
[EXCEPTION
END;
publicclassOracleUtils{
static{
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(ClassNotFoundExceptione){
e.printStackTrace();
}
publicstaticConnectiongetConnection()throwsSQLException{
Connectionconn=DriverManager.getConnection("jdbc:oracle:thin:@ip:1521:orcl","username","password");
returnconn;
publicstaticvoidclose(ResultSetrs,Statementstmt,Connectionconn){
.....
Connectionconn=OracleUtils.getConnection();
PreparedStatementstmt=conn.prepareStatement(sql);
ResultSetrs=stmt.executeQuery();
OracleUtils.close(rs,stmt,conn);
Updategoodssetnum=num-1whereid=id;
Insertordersvalues()wheregoods.id=goodsid
IONIO
SELECTLAST_INSERT_ID()ASIDinsertintot_employee(ID,EmployeeName,Position,Salary,Tel,DepartmentID)values(#{id,jdbcType=INTEGER},#{employeename,jdbcType=VARCHAR},#{position,jdbcType=VARCHAR},#{salary,jdbcType=DOUBLE},#{tel,jdbcType=VARCHAR},#{departmentid,jdbcType=INTEGER})