在哪里交自由编程啊?在这里叫吗?
com.imooc.spring.jdbc.daocom.imooc.spring.jdbc.entity.Hotelorg.springframework.jdbc.core.BeanPropertyRowMapperorg.springframework.jdbc.core.JdbcTemplatejava.util.ListHotelDao {
JdbcTemplate Hotel (Integer OrderNo){
String sql=Hotel hotel = .queryForObject(sqlObject[]{OrderNo}BeanPropertyRowMapper<Hotel>(Hotel.))hotel}
List<Hotel> (String city){
String sql=List<Hotel> list = .query(sqlObject[]{city}BeanPropertyRowMapper<Hotel>(Hotel.))list}
(Hotel hotel){
String sql=i = .update(sqlObject[]{hotel.getOrderNo()hotel.getCity()hotel.getPrice()hotel.getHotelName()hotel.getArriveDate()hotel.getLeaveDate()})i}
(Hotel hotel){
String sql=count = .update(sqlObject[]{hotel.getCity()hotel.getPrice()hotel.getHotelName()hotel.getArriveDate()hotel.getLeaveDate()hotel.getOrderNo()})count}
(Integer integer){
String sql=count = .update(sqlObject[]{integer})count}
JdbcTemplate () {
}
(JdbcTemplate jdbcTemplate) {
.= jdbcTemplate}
}
package com.imooc.spring.jdbc.entity;
import java.util.Date;
public class Hotel {
private Integer orderNo;
private String city;
private Float price;
private String hotelName;
private Date arriveDate;
private Date leaveDate;
@Override
public String toString() {
return "Hotel{" +
"orderNo=" + orderNo +
", city='" + city + '\'' +
", price=" + price +
", hotelName='" + hotelName + '\'' +
", arriveDate=" + arriveDate +
", leaveDate=" + leaveDate +
'}';
}
public Integer getOrderNo() {
return orderNo;
}
public void setOrderNo(Integer orderNo) {
this.orderNo = orderNo;
}
public String getCity() {
return city;
}
public void setCity(String city) {
this.city = city;
}
public Float getPrice() {
return price;
}
public void setPrice(Float price) {
this.price = price;
}
public String getHotelName() {
return hotelName;
}
public void setHotelName(String hotelName) {
this.hotelName = hotelName;
}
public Date getArriveDate() {
return arriveDate;
}
public void setArriveDate(Date arriveDate) {
this.arriveDate = arriveDate;
}
public Date getLeaveDate() {
return leaveDate;
}
public void setLeaveDate(Date leaveDate) {
this.leaveDate = leaveDate;
}
}<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="
http://www.springframework.org/schema/beans https://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
<!-- bean definitions here -->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
<property name="url" value="jdbc:mysql://localhost:3306/jdbc_imooc?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true">
</property>
<property name="username" value="root"></property>
<property name="password" value="root"></property>
</bean>
<bean id="JdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"></property>
</bean>
<bean id="hotelDao" class="com.imooc.spring.jdbc.dao.HotelDao">
<property name="jdbcTemplate" ref="JdbcTemplate"></property>
</bean>
</beans>
com.imooc.spring.jdbc.dao.HotelDaocom.imooc.spring.jdbc.entity.Hotelorg.junit.org.junit.runner.org.springframework.test.context.org.springframework.test.context.junit4.SpringJUnit4ClassRunnerjavax.annotation.java.text.ParseExceptionjava.text.SimpleDateFormatjava.util.Datejava.util.List(SpringJUnit4ClassRunner.)
({})
JdbcTemplateTestor {
HotelDao (){
Hotel hotel = .findById()System..println(hotel)}
(){
List<Hotel> = .findByCity()System..println()}
(){
Hotel hotel=Hotel()hotel.setOrderNo()hotel.setCity()hotel.setHotelName()hotel.setArriveDate(Date())hotel.setLeaveDate(Date())hotel.setPrice()count = .insert(hotel)System..println(count)}
() ParseException {
String date1=String data2=SimpleDateFormat simpleDateFormat =SimpleDateFormat()Hotel hotel = .findById()hotel.setLeaveDate(simpleDateFormat.parse(date1))hotel.setArriveDate(simpleDateFormat.parse(data2))count = .alter(hotel)System..println(count)}
(){
count = .delete()System..println(count)}
}4.0.0org.exampleexercise1.0-SNAPSHOTorg.springframeworkspring-context5.2.6.RELEASEorg.springframeworkspring-jdbc5.2.6.RELEASEmysqlmysql-connector-java5.1.41junitjunit4.12testorg.springframeworkspring-test5.2.6.RELEASEjunitjunit4.12compile
6
收起
正在回答 回答被采纳积分+1
1回答
2023版Java工程师
- 参与学习 人
- 提交作业 8810 份
- 解答问题 9886 个
综合就业常年第一,编程排行常年霸榜,北上广深月薪过万! 不需要基础,无需脱产即可学习,只要你有梦想,想高薪! 全新升级:技术栈升级(包含VUE3.0,ES6,Git)+项目升级(前后端联调与功能升级)
了解课程

恭喜解决一个难题,获得1积分~
来为老师/同学的回答评分吧
0 星