亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

為了賬號安全,請及時綁定郵箱和手機立即綁定
已解決430363個問題,去搜搜看,總會有你想問的

Cannot find class: com.mysql.jdbc.Driver

Cannot find class: com.mysql.jdbc.Driver

qq_莫非 2019-01-24 13:17:40
mybatis-config.xml: <?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"><!--通過這個配置文件,完成mybatis與數據庫的連接??--><configuration>????<!--?注意此配置文件內的元素的??-->????<!--?引入database.properties文件?-->????????????????<!--?設置類的別名?-->????<typeAliases>????????<!--?根據包取別名,把包下面的所有類都按類名來取別名?-->????????<typeAlias?type="com.ljh.mybatis.pojo.Student"?alias="u"/>????</typeAliases>????<environments?default="development">????<environment?id="development">??????<transactionManager?type="JDBC"></transactionManager>??????<dataSource?type="UNPOOLED">???????? <property?name="driver"?value="com.mysql.jdbc.Driver"/>???????? <property?name="url"?value="jdbc:mysql://localhost:3306/test1"/>???????? <property?name="username"?value="root"/>???????? <property?name="password"?value="1997520"/>??????</dataSource>????</environment>??</environments>????????????<!--?pojo的映射文件UserMapper引入到配入到配置文件中?-->????<mappers>????????<mapper?class="com.ljh.mybatis.mapper.StudentMapper"/>????</mappers>?</configuration> StudentMapper: package?com.ljh.mybatis.mapper;import?java.util.ArrayList;import?com.ljh.mybatis.pojo.Student;public?interface?StudentMapper?{ public?ArrayList<Student>?getallstudents();} StudentMapper.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="com.ljh.mybatis.mapper.StudentMapper"> <select?id="getallstudents"?resultType="u"> select?*?from?student?where?1=1 </select></mapper> Student: package?com.ljh.mybatis.pojo;public?class?Student?{ private?int?id; private?String?stuid; private?String?password; private?String?name; public?int?getId()?{ return?id; } public?void?setId(int?id)?{ this.id?=?id; } public?String?getStuid()?{ return?stuid; } public?void?setStuid(String?stuid)?{ this.stuid?=?stuid; } public?String?getPassword()?{ return?password; } public?void?setPassword(String?password)?{ this.password?=?password; } public?String?getName()?{ return?name; } public?void?setName(String?name)?{ this.name?=?name; } public?Student(int?id,?String?stuid,?String?password,?String?name)?{ super(); this.id?=?id; this.stuid?=?stuid; this.password?=?password; this.name?=?name; } public?Student()?{ } } Test: package?com.ljh.mybatis.test;import?java.io.IOException;import?java.io.Reader;import?java.util.ArrayList;import?org.apache.ibatis.io.Resources;import?org.apache.ibatis.session.SqlSession;import?org.apache.ibatis.session.SqlSessionFactory;import?org.apache.ibatis.session.SqlSessionFactoryBuilder;import?com.ljh.mybatis.mapper.StudentMapper;import?com.ljh.mybatis.pojo.Student;public?class?Test?{ public?static?void?main(String[]?args)?{ try?{ //1、加載配置文件 Reader?reader=Resources.getResourceAsReader("mybatis-config.xml"); //2、得到sessionfactorybuilder SqlSessionFactoryBuilder?sfb=new?SqlSessionFactoryBuilder(); //3、得到sqlsessionfactory SqlSessionFactory?factory=sfb.build(reader); //4、得到sqlsession SqlSession?session=factory.openSession(); //5、得到Mapper映射器 StudentMapper?mapper=session.getMapper(StudentMapper.class); ArrayList<Student>?stu=mapper.getallstudents(); for(int?i=0;i<stu.size();i++){ System.out.println(stu.get(i).getName()); } session.close(); }?catch?(Exception?e)?{ e.printStackTrace(); } }}
查看完整描述

1 回答

已采納
?
sunyaox

TA貢獻68條經驗 獲得超6個贊

先檢查一下,項目里是否引入了,mysql的jar包。

查看完整回答
反對 回復 2019-01-24
  • 1 回答
  • 0 關注
  • 3143 瀏覽
慕課專欄
更多

添加回答

舉報

0/150
提交
取消
微信客服

購課補貼
聯系客服咨詢優惠詳情

幫助反饋 APP下載

慕課網APP
您的移動學習伙伴

公眾號

掃描二維碼
關注慕課網微信公眾號