网站建设肆金手指排名9大麦网的网站建设

当前位置： 首页 > news >正文

网站建设肆金手指排名9,大麦网的网站建设,附近电脑培训班位置,找人做网站要拿到源代码吗Mybatis 整合流程 ① 添加MyBatis的依赖 ② 创建数据库表 ③ 编写pojo实体类 ④ 编写映射文件UserMapper.xml ⑤ 编写核心文件mybatis-config.xml ⑥ 编写测试类** 编写 pojo 实体类 (设计相应的数据库#xff09; Data AllArgsConstructor NoArgsConstructor public class…Mybatis 整合流程 ① 添加MyBatis的依赖 ② 创建数据库表 ③ 编写pojo实体类 ④ 编写映射文件UserMapper.xml ⑤ 编写核心文件mybatis-config.xml ⑥ 编写测试类** 编写 pojo 实体类 (设计相应的数据库 Data AllArgsConstructor NoArgsConstructor public class User {private int id; //idprivate String name; //姓名private String pwd; //密码 }UserMapper 接口实现 ListUser getUserLike(String value);//查询全部用户 ListUser findAll();//根据id查询用户 User selectUserById(int id); User getUserById(MapString,Object map);// 万能的map//添加一个用户 int addUser(User user); int addUser2(MapString,Object map);// 万能的map//修改一个用户 int updateUser(User user);//删除一个用户 int deleteUser(int id);// 分页ListUser Limit(MapString,Integer map);ListUser RowBounds();UserMapper.xml dao包下面 !–查询操作select idfindAll resultTypecom.hp.pojo.User 下面同理可见–!–模糊查询–select idgetUserLike resultTypeUserselect *from user where pwd like %#{value}%/select!–查询全部操作–select idfindAll resultTypeuserselect * from user/select!–插入操作–insert idaddUser parameterTypeuserinsert into user values(#{id},#{username},#{password})/insert!–万能的 Map 操作–insert idaddUser2 parameterTypemapinsert into user values (#{userid1111},#{userName},#{password})/insert!–删除操作–delete iddelete parameterTypeintdelete from user where id#{id}/delete!–修改操作–update idupdate parameterTypeuserupdate user set username#{username},password#{password} where id#{id}/update!–根据id进行查询–select idfindById resultTypeuser parameterTypeintselect * from user where id#{id}/select!–分页 结果集映射–resultMap idUserMap typeUser/select idLimit parameterTypemap resultMapUserMapselect * from user limit #{startIndex},#{pageSize}/select!–分页 方法2–select idRowBounds resultTypeUserselect * from user/selectmybatis-config.xml Resources资源目录下 ?xml version1.0 encodingUTF-8 ? !DOCTYPE configurationPUBLIC -//mybatis.org//DTD Config 3.0//ENhttp://mybatis.org/dtd/mybatis-3-config.dtd configuration!–通过properties标签加载外部properties文件–properties resourcedb.properties/!–引入日志工厂–settingssetting namelogImpl valueSTDOUT_LOGGING//settings!– 设置驼峰命名规则–settingssetting namemapUnderscoreToCamelCase valuetrue//settings!–自定义别名–typeAliasestypeAlias typecom.hp.pojo.User aliasuser//typeAliases!–数据源环境–environments defaultmysqlenvironment idmysqltransactionManager typeJDBC/dataSource typePOOLEDproperty namedriver value\({jdbc.driver}/property nameurl value\){jdbc.url}/property nameusername value\({jdbc.username}/property namepassword value\){jdbc.password}//dataSource/environment/environments!–加载映射文件–mappers!–告诉 mybatis 要执行的 sql 语句的位置 引入外部xml文件–mapper resourcecom/hp/dao/mapper.xml//mappers/configuration抽出 MyBatisUtil 工具类 简化测试代码Util包下面 public class MyBatisUtil {//定义 SqlSessionFactoryprivate static SqlSessionFactory factory null;static {//使用 静态块 创建一次 SqlSessionFactorytry {//读取配置文件InputStream inputStream Resources.getResourceAsStream(mybatis-config.xml);//创建 SqlSessionFactory 对象factory new SqlSessionFactoryBuilder().build(inputStream);} catch (Exception e) {factory null;e.printStackTrace();}}/* 获取 SqlSession 对象 /public static SqlSession getSqlSession() {SqlSession sqlsession null;if (factory ! null) {sqlsession factory.openSession();}return sqlsession;} }测试类代码 public void findAll() {SqlSession sqlSession MyBatisUtil.getSqlSession();UserMapper mapper sqlSession.getMapper(UserMapper.class);ListUser userList mapper.findAll();// userList.forEach(System.out::println); 也可以遍历全部输出for (User user : userList) { // 增强for循环输出System.out.println(user);}sqlSession.close();}db.properties jdbc.drivercom.mysql.jdbc.Driver jdbc.urljdbc:mysql://localhost:3306/mybatis?useSSLtrueamp;useUnicodetrueamp;characterEncodingutf8 jdbc.usernameroot jdbc.passwordrootlog4j.properties log4j.rootLoggerDEBUG,console,file#控制台输出的相关设置 log4j.appender.console org.apache.log4j.ConsoleAppender log4j.appender.console.Target System.out log4j.appender.console.ThresholdDEBUG log4j.appender.console.layout org.apache.log4j.PatternLayout log4j.appender.console.layout.ConversionPattern[%c]-%m%n#文件输出的相关设置 log4j.appender.file org.apache.log4j.RollingFileAppender log4j.appender.file.File./log/hp.log log4j.appender.file.MaxFileSize10mb log4j.appender.file.ThresholdDEBUG log4j.appender.file.layoutorg.apache.log4j.PatternLayout log4j.appender.file.layout.ConversionPattern[%p][%d{yy-MM-dd}][%c]%m%n#日志输出级别 log4j.logger.org.mybatisDEBUG log4j.logger.java.sqlDEBUG log4j.logger.java.sql.StatementDEBUG log4j.logger.java.sql.ResultSetDEBUG log4j.logger.java.sql.PreparedStatementDEBUGMaven 依赖配置 dependencies!–mybatis-spring –dependencygroupIdorg.mybatis/groupIdartifactIdmybatis-spring/artifactIdversion2.0.2/version/dependency!–junit –dependencygroupIdjunit/groupIdartifactIdjunit/artifactIdversion4.12/versionscopetest/scope/dependency!– mybatis –dependencygroupIdorg.mybatis/groupIdartifactIdmybatis/artifactIdversion3.5.9/version/dependency!– mysql-connector-java –dependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion5.1.9/version/dependency!– spring-webmvc –dependencygroupIdorg.springframework/groupIdartifactIdspring-webmvc/artifactIdversion5.1.9.RELEASE/version/dependency!– spring-jdbc –dependencygroupIdorg.springframework/groupIdartifactIdspring-jdbc/artifactIdversion5.1.9.RELEASE/version/dependency!– lombok –dependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactIdversion1.16.10/versionscopeprovided/scope/dependency/dependencies!– Maven静态资源过滤问题–buildresourcesresourcedirectorysrc/main/java/directory!–所在的目录–includes!–包括目录下的.properties,.xml 文件都会扫描到–include**/.properties/includeinclude*/.xml/include/includesfilteringfalse/filtering/resource/resourcespluginspluginartifactIdmaven-compiler-plugin/artifactIdversion3.1/versionconfigurationsource1.8/sourcetarget1.8/target/configuration/plugin/plugins/build