spring+jdbcTemplate操作数据库（mysql）

// 初始化数据源
org.springframework.jdbc.datasource.DriverManagerDataSource dataSource = new org.springframework.jdbc.datasource.DriverManagerDataSource();
dataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
dataSource.setUrl("jdbc:mysql://localhost:3306/zyappdata_db");
dataSource.setUsername("root");
dataSource.setPassword("root");

// jdbcTemplate操作数据库
org.springframework.jdbc.core.JdbcTemplate jdbcTemplate = new org.springframework.jdbc.core.JdbcTemplate(dataSource);
String mSql = "insert into sys_view_m(view_name, view_desc, database_id, last_version, creator_account, create_time, update_time) values(?, ?, ?, ?, ?, ?, ?);";
jdbcTemplate.update(mSql, viewName, viewDesc, databaseId, version, creatorAccount, createTime, createTime);

// -- 创建视图
String createViewSql = String.format("CREATE OR REPLACE VIEW %s.%s AS %s", databaseId, viewName, editScript);
jdbcTemplate.execute(createViewSql);