mysql
意 外
这个作者很懒,什么都没留下…
展开
-
Mybatis一对多查询处理
student实体类:import lombok.Data;@Datapublic class Student { private int id; private String name; private String tid;}teacher实体类:import lombok.Data;import java.util.List;@Datapublic class Teacher { private int id; private Strin原创 2021-01-09 21:01:52 · 207 阅读 · 0 评论 -
Mybatis实现分页
1、UserMapper.javaList<User> getUserByLimit(Map<String, Integer> map);2、Usermapper.xml<select id="getUserByLimit" parameterType="map" resultType="com.wjj.pojo.User"> select * from mybatis.user limit #{startIndex}, #{pageSize}</原创 2021-01-09 14:25:33 · 63 阅读 · 0 评论 -
Mybatis配置LOG4J
1、 导包:<dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> <version>1.2.17</version> </dependency>2、在配置文件目录下新建一个log4j.properties,内容如下:#将等级为DEBUG的日志信息输出到console和file这两个目的地,conso原创 2021-01-09 13:37:16 · 360 阅读 · 1 评论 -
Mybatis实现增删改查
1、配置pom文件,导入jar包<!-- 导入驱动 --> <dependencies> <!-- mysql驱动 --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <v原创 2021-01-08 18:19:31 · 101 阅读 · 0 评论 -
Jdbc事务的简单使用
public class JdbcTest3 { public static void main(String[] args) { String url = "jdbc:mysql://47.105.167.226:3306/jdbc?useUnicode=true&characterEncoding=utf-8"; String username = "root"; String password = "Wjj811971...";原创 2020-12-09 15:51:25 · 77 阅读 · 0 评论 -
Jdbc连接数据库的两种方式
1、Statementpublic class JdbcTest { public static void main(String[] args) throws Exception { String url = "jdbc:mysql://ip:3306/jdbc?useUnicode=true&characterEncoding=utf-8"; String username = "root"; String password = "密码"原创 2020-12-09 15:15:52 · 184 阅读 · 0 评论 -
Jdbc连接mysql
public class JdbcTest { public static void main(String[] args) throws Exception { String url = "jdbc:mysql://47.105.167.226:3306/jdbc?useUnicode=true&characterEncoding=utf-8"; String username = "root"; String password = "Wjj原创 2020-12-09 14:27:21 · 71 阅读 · 0 评论