1 mysql 创建数据库脚本
-PhpmyAdmin SQL-дамп-версия 4.2.11-- http: //www.phpmyadmin.net--- Хост: Localhost-- Время поколения: 2016-08-02 18: 13: 50-- 服务器版本 host 5.6.21-- PHP версия: 5.6.3set SQL_Mode = "NO_Auto_Value_on_zero»; "+00: 00";/ *! 40101 SET @OLD_CHARACTER_SET_CLIENT = @@ haract_set_client */;/ *! 40101 SET @OLD_CHARACTER_SET_RESULTS = @@ MARCES_SET_RESULT */;/ *! База данных: `mybatis` ----- -------------------------------------------------------- 表的结构` Студент '-Create Table, если не существует `student` (` id` int (10) не null, `name` varchar (256) не null,` age` int (4) не null engine = myisam auto_increment = 2 wef-nef-necete-neclet-`age` int (4). `Студент '-Inceping in a student` (` id`, `name`,` age`) значения (1,' Zhansan ', 20); ---- Индексы для сброшенных таблиц ------ Индексы для таблицы `student`-Alter` student`ad Primary Key (`id`); `Student`modify` id` int (10) не null auto_increment, auto_increment = 2;/*! 40101 set marmate_set_client =@old_character_set_client*/;/*! 40101 set marmate_set_result */;
2 创建与数据库表 Студент 对应的 Pojo 类
Пакет com.mtour.mybatis.demo; import javax.xml.bind.annotation.xmlrootelement; @xmlrootelementpublic Class Student {int id; name; int age; public int getId () {return id;} public void setId (int id) {this.id = id;} public string string () rate string string setId (int id). name) {this.name = name;} public int getage () {return Age;} public void setage (int age) {this.age = age;}}3 创建映射 StudentMapper
<? xml version = "1.0" Encoding = "UTF-8"?> <! Doctype Mapper public "-// mybatis.org//dtd mapper 3.0 // en" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> mapper.org/dtd/mybatis-3-mapper.dtd"> mapper. namespace = "com.mtour.mybatis.demo.studentmapper"> <select id = "getStudent" parameterType = "int" outdetpe = "com.mtour.mybatis.demo.student"> select * от студента, где id =#{id} </select> </mapper> 4. 创建 conf.xml
<? xml version = "1.0" Encoding = "UTF-8"?> <! Конфигурация doctype public "-// mybatis.org//dtd config 3.0 // en" "http://mybatis.org/dtd/mybatis-3 config.dtd"> configuration>. id = "Развитие"> <transactionManager type = "jdbc" /> <!-配置数据库连接信息-> <dataSource type = "Booled"> <name = "Driver" value = "com.mysql.jdbc.driver" /> <name = "url" value = "jdbc: mysql: // localhost: 3306 /mybatis" /namer namer namer namer namer namer namer namer namer namern vally vally vally = /> <name = name = "password" value = ""/> </dataSource> </environment> </ervines> <mappers> <mapper resource = "com/mtour/mybatis/demo/studentmapper.xml"/> </mappers> </configuration>
5. 创建 отдых 资源
пакет com.mtour.mybatis.demo; import java.io.ioexception; импорт java.io.inputstream; import org.apache.ibatis.session.sqlsession; импорт org.apache.ibatis.session.ssessionFactory; импорт org.apache.ibatis.session.sessionFactory; Импорт javax.ws.rs.path; импортировать javax.ws.rs.produces; Импорт javax.ws.rs.pathparam; Импорт javax.ws.rs.core.mediatype; @Path ("/staction") открытый класс демонстрация {static String resource = "conf.xml"; static inputstream is = demo.class.getClassloader (). GetResourceasStream (ресурс); static sqlSessionFactory sessionFactory = new sqlSessionFactfactBuilder (). sayhello () {return "hello Jersey, первая демонстрация"; } @Get @path ("/{param}") @produces ("text/plain; charset = utf-8") public String SayHellotOutf8 (@pathparam ("param") String username) {return "hello" + username; } @Get @path ("/getStudent/{id}") @produces (mediaType.application_json) Public Student getUserJson (@pathparam ("id") String id) {integer student = integer.valueof (id); sqlsession session = session.opensession (); "com.mtour.mybatis.demo.studentmapper.getStudent"; студент s = session.selectone (утверждение, StudentId); session.close (); return s; }}6. 启动调试
源码下载 ： http: //xiazai.vevb.com/201605/yuanma/mybatisdemo (jb51) .rar
以上所述是小编给大家介绍的通过 mybatis 读取数据库数据并提供 отдых 接口访问 希望对大家有所帮助 ， 如果大家有任何疑问请给我留言 ， 小编会及时回复大家的。在此也非常感谢大家对武林网网站的支持！