您好,登錄后才能下訂單哦!
這篇文章主要介紹mysql連接數(shù)據(jù)庫(kù)并測(cè)試的方式方法,文中介紹的非常詳細(xì),具有一定的參考價(jià)值,感興趣的小伙伴們一定要看完!
1.通過(guò)maven導(dǎo)入關(guān)于mybatis的jar包
可以通過(guò)阿里云的maven庫(kù)直接下載相關(guān)jar包
<dependencies> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.4.5</version> </dependency> <dependency> <groupId>MySQL</groupId> <artifactId>mysql-connector-Java</artifactId> <version>5.1.38</version> </dependency> </dependencies>
2.編寫(xiě)mybatis的配置文件
<?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" /> <!-- 配置數(shù)據(jù)庫(kù) --> <dataSource type="POOLED"> <property name="driver" value="com.mysql.jdbc.Driver" /> <property name="url" value="jdbc:mysql://localhost:3306/my_schema?useSSL=true" /> <property name="username" value="root" /> <property name="password" value="" /> </dataSource> </environment> </environments> <!-- 映射文件 --> <mappers> <mapper resource="UserMapper.xml" /> </mappers> </configuration>
3.編寫(xiě)映射文件UserMapper.xml
<?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 namespace="userMapper"> <select id="selectUser" resultType="entity.User"> select * from user </select> </mapper>
4.寫(xiě)出實(shí)體類User,很平常的類,就不在過(guò)多解釋.
public class User { private String username; private String email; private String password; private String create_time; public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getEmail() { return email; } public void setEmail(String email) { this.email = email; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getCreate_time() { return create_time; } public void setCreate_time(String create_time) { this.create_time = create_time; } @Override public String toString() { return "User [username=" + username + ", email=" + email + ", password=" + password + ", create_time=" + create_time + "]"; } public User(String username, String email, String password, String create_time) { super(); this.username = username; this.email = email; this.password = password; this.create_time = create_time; } public User() { super(); }
}
5.在寫(xiě)一個(gè)類MybatisSamples,里面包含main方法,進(jìn)行測(cè)試.
具體代碼如下
public static void main(String[] args) { String resource = "mybatis-config.xml"; SqlSession session = null; try { InputStream is = Resources.getResourceAsStream(resource); //獲取一個(gè)session工廠 SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is); //通過(guò)工廠獲取session session = sqlSessionFactory.openSession(); //根據(jù)映射文件中select標(biāo)簽的id獲取集合 List<User> list = session.selectList("userMapper.selectUser"); for(User user: list) { System.out.println(user); } } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { //注意關(guān)閉session!!! session.close(); } }
執(zhí)行結(jié)果如下:
附:
包結(jié)構(gòu)
數(shù)據(jù)庫(kù)結(jié)構(gòu)
總結(jié):想入門mybatis最重要的兩步,第一是寫(xiě)配置文件,配置數(shù)據(jù)庫(kù)和mapper,第二步是寫(xiě)好mapper和實(shí)體類,mapper中寫(xiě)sql語(yǔ)句,然后可以就可以通過(guò)mybatis把表中的數(shù)據(jù)映射成為一個(gè)對(duì)象了。
以上是“mysql連接數(shù)據(jù)庫(kù)并測(cè)試的方式方法”這篇文章的所有內(nèi)容,感謝各位的閱讀!希望分享的內(nèi)容對(duì)大家有幫助,更多相關(guān)知識(shí),歡迎關(guān)注億速云行業(yè)資訊頻道!
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。