XKraCqs7

1CREATE TABLE student(
2   ID int(10) NOT NULL AUTO_INCREMENT,
3   NAME varchar(100) NOT NULL,
4   BRANCH varchar(255) NOT NULL,
5   PERCENTAGE int(3) NOT NULL,
6   PHONE int(11) NOT NULL,
7   EMAIL varchar(255) NOT NULL,
8   PRIMARY KEY (`ID`)
9);
10
11
12DELIMITER //
13   DROP PROCEDURE IF EXISTS details.read_recordById //
14   CREATE PROCEDURE details.read_recordById (IN emp_id INT)
15	
16   BEGIN 
17      SELECT * FROM STUDENT WHERE ID = emp_id; 
18   END// 
19	
20DELIMITER ;
21
22
23<?xml version = "1.0" encoding = "UTF-8"?>
24<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
25	
26<mapper namespace = "Student">	
27		
28   <resultMap id = "result" type = "Student">
29      <result property = "id" column = "ID"/>
30      <result property = "name" column = "NAME"/>
31      <result property = "branch" column = "BRANCH"/>
32      <result property = "percentage" column = "PERCENTAGE"/>
33      <result property = "phone" column = "PHONE"/>
34      <result property = "email" column = "EMAIL"/>
35   </resultMap>   
36   
37   <select id = "callById" resultMap = "result" parameterType = "Student" statementType = "CALLABLE">
38      {call read_record_byid(#{id, jdbcType = INTEGER, mode = IN})}
39   </select>   
40    	
41</mapper>