1 mysql 创建数据库脚本
-Phpmyadmin SQL Dump-- Versión 4.2.11-- http: //www.phpmyadmin.net--- Host: localhost-- Tiempo de generación: 2016-08-02 18: 13: 50-- 服务器版本 ： 5.6.21-- Versión php: 5.6.3set sql_mode = "no_auto_value_on_zero"; "+00: 00";/ *! 40101 set @old_character_set_client = @@ caracteres_set_client */;/ *! 40101 set @old_character_set_results = @@ caracteres_set_results */;// *! 40101 set @old_collation_connection =@@colation_connection */;/ *! 40101 set. Base de datos: `mybatis` ---- ------------------------------------------------------------ 表的结构` estudiante`-Create Table Si no existe `estudiante` (` id` int (10) no nulo, `name` varchar (256) no null,` edad` int (4) no null) motor = myiSamam Auto_increment = 2 predeterminado = latina = Latin1; `Student`-Insert en` estudiante` (`id`,` name`, `age`) valores (1, 'zhansan', 20); ---- Índices para tablas dumpidas ------ índices para la tabla` estudiante`-tabla alter `estudiante 'llave primaria (` id` `` Id`); --------AutO_Crement para tablas volcadas ------ Auto_increment para la tabla `` Id`); `Student`modify` id` int (10) no null auto_incement, auto_incement = 2;/*! 40101 set caracteres_set_client = @character_set_client*/;/*! 40101 set caracteres_set_results =@old_character_set_results*//*! 40101 set cotleation_set_results =@Old_Character_set_Results*/;/*! 40101 set COLLATION_SETTERTS */;
2 创建与数据库表 Estudiante 对应的 POJO 类
paquete com.mtour.mybatis.demo; import javax.xml.bind.annotation.xmlrooTelement; @xmlrootelementPublic Class Student {int id; string name; int age; public int getId () {return id;} public void setid (int id) nombre) {this.name = name;} public int getAge () {return Age;} public void setAge (int a age) {this.age = age;}}3 创建映射 StudentMapper
<? xml versión = "1.0" encoding = "utf-8"?> <! Doctype mapper public "-// mybatis.org//dtd mapper 3.0 // en" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper Namespace = "com.mtour.mybatis.demo.studentmapper"> <select id = "getStudent" parametertype = "int" resulttype = "com.mtour.mybatis.demo.student"> Seleccione * del estudiante donde id =#{id} </select> </ mapper> 4. 创建 Conf.xml
<? xml versión = "1.0" encoding = "utf-8"?> < id="development"><transactionManager type="JDBC" /><!-- 配置数据库连接信息 --><dataSource type="POOLED"><property name="driver" value="com.mysql.jdbc.Driver" /><property name="url" value="jdbc:mysql://localhost:3306/mybatis" /><property name="username" value="root" /> <Property Name = "Password" Value = ""/> </dataSource> </entorno> </bossments> <mappers> <mapper resource = "com/mtour/mybatis/demo/studentmapper.xml"/> </mappers> </configuración>
5. 创建 Descanso 资源
paquete com.mtour.mybatis.demo; import java.io.ioException; import java.io.inputstream; import org.apache.ibatis.session.sqlsession; import org.apache.ibatis.session.sqlsessionFactory; import org.apache.ibatis.sission.sqlsession; import javax.ws.rs.path; import javax.ws.rs.produce; import javax.ws.rs.pathparam; import javax.ws.rs.core.mediatype; @Path ("/Student") Public Class Demo {static String Resource = "conf.xml"; static inputStream is = demo.class.getClassLoader (). GetResourceasstream (resource); sqlsessionFactory sessionFactory = new sqlSessionFactoryBuilder (). Build (build (build ( @get @produces (mediAType.text) sayhello () {return "hola jersey, primera demostración"; } @Get @path ("/{param}") @produces ("text/sencillo; charset = utf-8") String public sayHelToutf8 (@PathParam ("param") String UserName) {return "Hello" + Username; } @Get @path ("/getStudent/{id}") @produces (mediAtype.application_json) estudiante público getUserjson (@PathParam ("id") string id) "com.mtour.mybatis.demo.studentmapper.getstudent"; estudiante s = session.selectone (declaración, studentId); session.close (); return s; }}6. 启动调试
源码下载 ： http: //xiazai.vevb.com/201605/yuanma/mybatisdemo (JB51) .rar
以上所述是小编给大家介绍的通过 mybatis 读取数据库数据并提供 descanso 接口访问 ， 希望对大家有所帮助 如果大家有任何疑问请给我留言 ， 小编会及时回复大家的。在此也非常感谢大家对武林网网站的支持！