이클립스 spring mybatis 프로젝트 실습

 

https://mvnrepository.com/

 

commons-dbcp

<!-- https://mvnrepository.com/artifact/commons-dbcp/commons-dbcp -->
<dependency>
    <groupId>commons-dbcp</groupId>
    <artifactId>commons-dbcp</artifactId>
    <version>1.4</version>
</dependency>

mysql

<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.26</version>
</dependency>

mybatis

<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.5.7</version>
</dependency>

 

pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<groupId>Mybatis01</groupId>
	<artifactId>Mybatis01</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<dependencies>
		<dependency>
			<groupId>commons-dbcp</groupId>
			<artifactId>commons-dbcp</artifactId>
			<version>1.4</version>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>8.0.26</version>
		</dependency>
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>3.5.7</version>
		</dependency>
		<dependency>
			<groupId>org.apache.maven.plugins</groupId>
			<artifactId>maven-compiler-plugin</artifactId>
			<version>3.8.1</version>
		</dependency>
	</dependencies>
</project>

 

 

 

 

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"/>
      <dataSource type="POOLED">
        <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/db01"/>
        <property name="username" value="root"/>
        <property name="password" value="1234"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>
    <mapper resource="Mapper.xml"/>
  </mappers>
</configuration>

Mapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  
  <mapper namespace="Mapper">
	  <insert id = "test02">
	  	insert into table01(age) values(#{age})
	  </insert>
  </mapper>

 

Hello.java

package Pack;

import java.io.IOException;
import java.io.InputStream;

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 Hello {
	public static void main(String[] args) {
		System.out.println(1);
		
		SqlSessionFactory ssf = null;
		SqlSession session = null;
		
		InputStream is = null;
		try {
			is = Resources.getResourceAsStream("mybatis-config.xml");
		} catch (IOException e) {
			e.printStackTrace();
		}
		
		ssf = new SqlSessionFactoryBuilder().build(is);
		System.out.println(2);
		
		session = ssf.openSession();
		
		try {
			int result = session.insert("test02", 9999);
			System.out.println(result);
			if(result >0 ) {
				session.commit();
			}
			session.close();
		}catch (Exception e) {
			e.printStackTrace();
		}
		
	}
}

 

Workld.java

package Pack;

class Tiger{
	void m1() { System.out.println(1); }
	void m2() { System.out.println(2); }
	void m3() { System.out.println(3); }
	void m4() { System.out.println(4); }
	void m5() { System.out.println(5); }
}

interface Delegate{
	void delegate(Tiger t);
}

class Proxy{
	void command(Delegate d) {
		Tiger t = new Tiger();
		t.m1();
		d.delegate(t);	
		t.m5();		
	}
}

public class World {
	public static void main(String[] args) {
		Proxy proxy = new Proxy();
		proxy.command(new Delegate() {	
			public void delegate(Tiger t) {
				t.m2();
			}
		});
		System.out.println("==============");
		proxy.command(new Delegate() {	
			public void delegate(Tiger t) {
				t.m3();
			}
		});
		System.out.println("==============");
		proxy.command(new Delegate() {	
			public void delegate(Tiger t) {
				t.m4();
			}
		});
	
		
	}
}