小小雨伞的博客

现在需求就是根据司机id和查询不为出场的状态查出该司机是否有派车的状态这是sqlselect (case when count(*)>0 then 1 else 0 end) as cnt from t_c_msy_customer_send_car_detail where driverId= '123' and currentState = 9这是xml的<select id="getDriverCarCount" resultType="java.lang.Boolea.

响应头

1.pom.xml<dependencies> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-test</artifactId> <version>5.3.2</version> </dependency&g

1.pom.xml<dependencies> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>5.3.2</version> </dependenc

1.pom.xml<dependencies> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>5.3.2</version> </dependen

1.pom文件<dependencies> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> <scope>test</scope>

1.pom配置文件<dependencies> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>5.3.2</version> </dependenc

1.配置pom.xml<dependencies> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> <scope>test</scope>

一个接口,定义一个方法一个实现类,实现接口的方法接口动态代理一个类用来动态代理那个被代理类final Producer producer =new Producer(); IProducer proxyProducer = (IProducer) Proxy.newProxyInstance(producer.getClass().getClassLoader(), Producer.class.getInterfaces(),

线程连接绑定@Componentpublic class ConnectionUtils { private ThreadLocal<Connection> tl =new ThreadLocal<>(); @Autowired private DataSource ds; /** * 获取当前线程的连接 */ public Connection getThreadConnection(){

导入这两个包<dependencies> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>5.3.2</version> </dependency&g

用到的包:spring5spring-testdbutilsmysqlc3p0junit1.配置pom.xml<dependencies> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <ve

@component创建对象和xml配置的bean标签一样@autowrite用于注入数据 和bean标签的property一样@Qualifier根据component的id获取bean对象@Autowired@Qualifier("userMapper")private UserMapper userMapper;@Resoure就是前面两个的结合@Resource(name = "userMapper")private UserMapper userMapper;注入be

private String name; private List<String> list; private Map<String,String> map; public void setName(String name) { this.name = name; } public void setList(List<String> list) { this.list = list; }

构造方式 //在类中使用有参构造 private String name; public UserMapperImpl(String name) { this.name = name; }<bean id="userMapper" class="top.chenyp.mapper.impl.UserMapperImpl"> <constructor-arg name="name" value="name"/> </

1导入依赖<dependencies> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>5.3.2</version> </dependency&gt

bean.propertiesuserMapper=top.chenyp.mapper.impl.UserMapperImpluserService=top.chenyp.service.impl.UserServiceImplmapperpublic interface UserMapper { void findById(String id);}public class UserMapperImpl implements UserMapper { @Override

创建jdbc基本步骤public static void main(String[] args) throws SQLException { Connection con=null; //注册驱动 DriverManager.registerDriver(new com.mysql.jdbc.Driver()); try { //反射 Class.forName("com.mysql.jdbc.Dr

创建maven普通项目导入maven<packaging>war</packaging> <dependencies> <dependency> <groupId>org.springframework</groupId> <artifactI...