OoCGO的博客

1、先连接数据库 import com.intellij.database.model.DasTable import com.intellij.database.model.ObjectKind import com.intellij.database.util.Case import com.intellij.database.util.DasUtil import java.io.* import java.text.SimpleDateFormat /* * Available cont

select <select id="userList" parameterType="user" resultType="User"> select * from user where name =#{name}　　　　　　 </select> insert <insert id="insertUser" parameterType="int"> 　　　　　　 insert into user (id) values (#{id}) 　　　　 .

drop table if exists tt_info; CREATE TABLE `tt_info` ( `tt_info_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id(自增主键）', `tt_info_serial_no` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '交易号', `serial_no` varchar(40) CHAR.