spring整合JdbcTemplate sql语句报错

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [Delete from user where name= 正辉]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ‘正辉’ in ‘where clause’

原语句
jt.execute("Delete from user where name= " + delname);
正确语句
jt.execute("Delete from user where name= '" + delname+"'");
Java中sql的书写必须规范,不能有前面学习xml中写法的惯性
例如模糊查询?传参的写法

 String sql = " select * from t_user where username  like ? and nickname like ? ";
        List<User> ulist = jdbcTemplate.query(sql, new UserRowMapper(), new Object[]{"%"+user.getUsername()+"%","%"+user.getNickname()+"%"});