enujo

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> 
		<property name="dataSource" ref="dataSource" /> 
		<property name="mapperLocations"> 
			<list>
				<value>classpath:/com/tistory/luahius/service/LibraryMapper.xml</value>
			</list> 
	 	</property> 
</bean> 

enujo

		SELECT
			book.book_no as bookNo, 
			book.disbook_no as disbookNo, 
			book.library_no as libraryNo, 
			book.book_name as bookName, 
			book.book_writer as bookWriter, 
			book.book_pulisher as bookPulisher, 
			book.book_firstrent as bookFirstrent,
			book.book_totalrent as bookTotalrent, 
			book.book_totalday as bookTotalday, 

enujo

		SELECT
			book.book_no as "bookNo", 
			book.disbook_no as "disbookNo", 
			book.library_no as "libraryNo", 
			book.book_name as "bookName", 
			book.book_writer as "bookWriter", 
			book.book_pulisher as "bookPulisher", 
			book.book_firstrent as "bookFirstrent",
			book.book_totalrent as "bookTotalrent", 

enujo

-- 오름차순 값이 적은 것부터 큰 순서대로
SELECT * FROM table_nm ORDER BY field_nm ASC;

-- 내림차순 값이 큰 것부터 작은 순서대로 
SELECT * FROM table_nm ORDER BY field_nm DESC;

enujo

INSERT INTO TEST_A (
	B
) VALUES (
	'HI'
);

INSERT INTO TEST_B (
	C,
	D
) VALUES (

enujo

DELIMITER $$
DROP PROCEDURE IF EXISTS insertRent$$
CREATE PROCEDURE insertRent(libmemberNo INT(11), bookNo INT(11), payTotal INT(30),bookState VARCHAR(5))
BEGIN
INSERT INTO book_rent(
			libmember_no, 
			book_no, 
			brent_start
		) VALUES (
			libmemberNo, 

enujo

<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
	version="3.1">

	

</web-app>

enujo

<web-app xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
version="3.0">



</web-app>

enujo

<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
id="servlet-2_5" version="2.5">


</web-app>

enujo

<web-app id="servlet-2_4" version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">



</web-app>