Write Code considerations

1, DAO layer do not use transaction 2, execute multiple SQL to use Transaction 3, try catch after transaction back invalid, execute throw exception to execute transaction 4, try catch as far as possible to the outermost parsing excetion5, SQL statements can be used in the Do not loop SQL 6, logical Try to write in the service layer, do not write in the Controller 7, SQL statements are to use anti-SQL injection notation is the parameter value in the SQL statement "? "Instead, fill in the values with the corresponding methods provided by JDBC

Write Code considerations