首页 > 编程知识 正文

java连接oracle数据库,jdbc建立数据库连接

时间:2023-05-06 18:06:33 阅读:131266 作者:1205

yxyapplication.yml文件

server : port :5001 spring : application : name : config-server profiles 3360 active : JDBC数据源3360 driver-3360 : JDBC : MySQL ://127.0.0.133603306/order test? use unicode=truecharacterencoding=utf-8 server time zone=Asia/Shanghai username 3360 rootpassword 3360根POM文件

! -数据库连接的jar包--- dependencygroupidorg.spring framework.boot/groupidartifactidspring-boot-starter-JDBC/artifact id dependencydependencygroupidmysql/groupidartifactidmysql-connector-Java/artifact id/dependencydencygroutour

@ springbootapplicationpublicclassconfigserverapplication (publicstaticvoidmain ) string[]args ) spring application.run }

@ getter @ setterpublicclassstudent {私有Intid; 私有字符串名称; publicinterfacestudentdao { publicstringgetusernamebyid (intid ); } @Repositorypublic class令人焦急的向日葵implementsstudentdao {//auto wired中跳跃的寒风//@Resource的作用与@Autowired相同, @Autowired按byType自动rred @ resource默认按byName自动rz dhm @ resourceprivatejdbctemplatejdbctemplate; @ overridepublicstringgetusernamebyid (intid ) returnjdbctemplate.queryforobject ) ' selectnamefromstudentwhereid=?String.class; }服务层

publicinterfacestudentservice { publicstringgetusernamebyid (intid ); } @ servicepublicclassxxdzmimplementsstudentservice { @ resourceprivatestudentdaostudentdao; @ overridepublicstringgetusernamebyid (intid ) returnstudentdao.getusername byid ) id; } }控制器层

@ rest controller @ request mapping (/mydb ) ) publicclassstudentcontroller ) @ resourceprivatestudentservicestudentservice @ Hello ) ) publicstringgetusernamebyid ) intid ) returnstudentservice.getusername byid ); }测试

版权声明:该文观点仅代表作者本人。处理文章:请发送邮件至 三1五14八八95#扣扣.com 举报,一经查实,本站将立刻删除。