OoCGO的博客

1、先连接数据库import com.intellij.database.model.DasTableimport com.intellij.database.model.ObjectKindimport com.intellij.database.util.Caseimport com.intellij.database.util.DasUtilimport 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.