mybatis mysql select_MyBatis+mysql查询和添加数据

项目结构：

Menu

package com.mstf.dao;

import java.util.Scanner;

import org.apache.ibatis.session.SqlSession;

import com.mstf.util.MyBatisUtil;

public class Menu {

private static Scanner sc = new Scanner(System.in);

public static void main(String[] args) {

SqlSession session=MyBatisUtil.getSession();

System.out.println("请输入菜单选项：");

System.err.println("1.根据订单ID查询信息");

System.err.println("2.添加客户订单信息");

String id = sc.next();

if ("1".equals(id)) {

Table.table1();

} else if ("2".equals(id)) {

Table.table2();

} else {

System.err.println("非法操作：没有此选项！");

session.close();

}

}

}

Table

package com.mstf.dao;

import java.util.List;

import java.util.Scanner;

import org.apache.ibatis.session.SqlSession;

import com.mstf.entity.T_customer;

import com.mstf.entity.T_order;

import com.mstf.util.MyBatisUtil;

public class Table {

private static Scanner sc = new Scanner(System.in);

static SqlSession session=MyBatisUtil.getSession();

/**

* 根据订单 ID 查询

* @author wangzheng

*/

public static void table1(){

System.err.println("请输入订单ID：");

String bug=sc.next();

try {

List list = session.selectList("getT_customerT_order",bug);

for (T_order t_order : list) {

System.out.println(t_order);

}

} finally {

session.commit();

session.close();

System.out.println("查询一条数据成功！如果没有数据显示，则为无此订单ID！");

}

}

/**

* 添加一条新数据

* @author wangzheng

*/

public static void table2(){

int customer_id=0;

System.out.println("请输入客户姓名：");

String name=sc.next();

System.out.println("请输入客户年龄：");

String age=sc.next();

System.out.println("请输入客户电话：");

String tel=sc.next();

System.out.println("请输入订单编号：");

String order_number=sc.next();

System.out.println("请输入订单价格：");

String order_price=sc.next();

try {

T_customer t_customer = new T_customer(0,name,age,tel);

T_order t_order = new T_order(0,order_number,order_price,customer_id);

session.insert("insert_T_customer",t_customer);

session.insert("insert_T_order",t_order);

} finally {

session.commit();

session.close();

System.out.println("添加数据成功！");

}

}

}

T_customer

package com.mstf.entity;

public class T_customer {

private int id;

private String name;

private String age;

private String tel;

public int getId() {

return id;

}

public void setId(int id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String getAge() {

return age;

}

public void setAge(String age) {

this.age = age;

}

public String getTel() {

return tel;

}

public void setTel(String tel) {

this.tel = tel;

}

public T_customer(int id, String name, String age, String tel) {

super();

this.id = id;

this.name = name;

this.age = age;

this.tel = tel;

}

public T_customer() {

super();

}

@Override

public String toString() {

return "订单客户：[客户ID：" + id + ", 姓名：" + name + ", 年龄：" + age + ", 电话：" + tel + "]";

}

}

T_order

package com.mstf.entity;

public class T_order {

private int id;

private String order_number;

private String order_price;

private T_customer t_customer;

private int customer_id;

public int getCustomer_id() {

return customer_id;

}

public void setCustomer_id(int customer_id) {

this.customer_id = customer_id;

}

public T_customer getT_customer() {

return t_customer;

}

public void setT_customer(T_customer t_customer) {

this.t_customer = t_customer;

}

public int getId() {

return id;

}

public void setId(int id) {

this.id = id;

}

public String getOrder_number() {

return order_number;

}

public void setOrder_number(String order_number) {

this.order_number = order_number;

}

public String getOrder_price() {

return order_price;

}

public void setOrder_price(String order_price) {

this.order_price = order_price;

}

public T_order(int id, String order_number, String order_price, int customer_id) {

super();

this.id = id;

this.order_number = order_number;

this.order_price = order_price;

this.customer_id = customer_id;

}

public T_order() {

super();

}

@Override

public String toString() {

return "系统订单：[订单ID：" + id + ", 订单号：" + order_number + ", 总价：" + order_price

+ "];\n" + t_customer + "\n";

}

}

T_customer.xml

/p>

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

SELECT * FROM t_customer tc,t_order t WHERE tc.id=t.customer_id and t.customer_id =#{t.customer_id}

T_order.xml

/p>

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

insert into t_customer (name, age, tel) values (#{name}, #{age}, #{tel})

insert into t_order (order_number, order_price, customer_id) VALUES (#{order_number},#{order_price},(SELECT MAX(`id`) FROM `t_customer`))

MyBatisUtil

package com.mstf.util;

import java.io.Reader;

import org.apache.ibatis.io.Resources;

import org.apache.ibatis.session.SqlSession;

import org.apache.ibatis.session.SqlSessionFactory;

import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class MyBatisUtil {

// 去读取编写的 mybatis_config.xml 文件加载文件中的映射

public static SqlSession getSession() {

SqlSessionFactory ssf=null;

String url="mybatis_config.xml";

Reader reader=null;

try {

reader=Resources.getResourceAsReader(url);

} catch (Exception e) {

e.printStackTrace();

}

ssf=new SqlSessionFactoryBuilder().build(reader);

return ssf.openSession();

}

}

db.properties

driver=com.mysql.jdbc.Driver

url=jdbc:mysql://127.0.0.1/demo

username=root

password=root

log4j.properties

# 全局的日志配置

log4j.rootLogger = ERROR,stdout

# MyBatis 的日志配置

log4j.logger.org.fkit.mapper.UserMapper=DEBUG

# 控制台输出

log4j.appender.stdout = org.apache.log4j.ConsoleAppender

log4j.appender.stdout.layout = org.apache.log4j.PatternLayout

log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

mybatis_config.xml

/p>

PUBLIC "-//mybatis.org//DTD Config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">