wq8660389 2016-12-07 02:25 采纳率: 35.7%
浏览 5211
已结题

java spring的问题找不到datasource

配置文件 <?xml version="1.0" encoding="UTF-8"?>
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop" xmlns:task="http://www.springframework.org/schema/task"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task.xsd">

<context:property-placeholder location="file:${user.home}/webapp-conf/oms_empty_config.properties"/>

<context:component-scan base-package="com.dabay.service.web.manager">
<context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>

/context:component-scan
task:annotation-driven/

<bean id="springContextUtil" class="com.dabay.service.web.manager.util.SpringContextUtil"/>

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    <property name="dataSource" ref="dataSource"/>
    <property name="mapperLocations" value="classpath:/mapper/*Mapper.xml"/>
    <property name="plugins">
        <array>
            <bean class="com.github.pagehelper.PageHelper">
                <property name="properties">
                    <value>
                        dialect = mysql
                        reasonable = true
                        pageSizeZero = true
                    </value>
                </property>
            </bean>
            <bean class="com.dabay.service.web.manager.interceptor.MybatisInterceptor"/>
        </array>
    </property>
</bean>

<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate" scope="prototype">
    <constructor-arg index="0" ref="sqlSessionFactory"/>
    <constructor-arg index="1" value="BATCH"/>
</bean>

<bean id="propertyConfigurer"  class="com.dabay.service.web.manager.util.PropertyUtils">
    <property name="locations">
        <list>
            <value>file:${user.home}/webapp-conf/oms_empty_config.properties</value>
        </list>
    </property>
</bean>

<!-- 支持上传文件 -->
<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver"/>

<bean class="tk.mybatis.spring.mapper.MapperScannerConfigurer">
    <property name="basePackage" value="com.dabay.service.web.manager.persistence.dao.**"/>
    <property name="properties">
        <value>
            mappers=tk.mybatis.mapper.common.Mapper
        </value>
    </property>
</bean>

<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource"></property>
</bean>

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
    <property name="driverClass" value="${sup.driver}"/>
    <property name="jdbcUrl" value="${sup.jdbcUrl}"/>
    <property name="User" value="${sup.user}"/>
    <property name="password" value="${sup.password}"/>
    <property name="maxPoolSize" value="${sup.maxPoolSize}"/>
    <property name="minPoolSize" value="${sup.minPoolSize}"/>
    <property name="preferredTestQuery" value="SELECT 1 FROM dual"/>
</bean>

处理登录的一个类文件
package com.dabay.service.web.manager.Dao;

import com.dabay.service.web.manager.entity.Admin;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import org.springframework.web.bind.annotation.RequestMapping;

import javax.sql.DataSource;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**

  • Created by Administrator on 2016/11/28.
    */
    @Repository
    public class JdbcAdminDao
    implements AdminDao,Serializable{

    @Autowired
    private DataSource dataSource;

    public Admin findByCode(
    String username) {
    if (username == null
    || username.equals("")) {
    return null;
    }
    Connection con = null;
    try {
    //创建连接
    con = dataSource.getConnection();
    //执行SQL
    String sql = "select * " +
    "from manage_employee" +
    "where login_name=?";
    PreparedStatement ps =
    con.prepareStatement(sql);
    ps.setString(1,username);
    ResultSet rs = ps.executeQuery();
    //处理结果集
    if (rs.next()) {
    Admin a = new Admin();
    //a.setId(rs.getInt("id"));
    //a.getEmployee_code(rs.getString("employee_code"));
    a.setLogin_name(rs.getString("login_name"));
    a.setPassword(rs.getString("password"));
    return a;
    }
    } catch (Exception e) {
    e.printStackTrace();
    throw new RuntimeException(
    "查询管理员失败!", e);
    } finally {
    try {
    con.close();
    } catch (SQLException e) {
    e.printStackTrace();
    throw new RuntimeException(
    "关闭连接失败!", e);
    }
    }
    return null;
    }
    }

debug的原因是因为 dataSource = null 哪位大神解答一下

  • 写回答

3条回答

  • intepter 2016-12-07 03:08
    关注

    可能是 却jar 还有就是配置不对,建议写个测试,加载一下配置文件,看能不能得到datasource对象

    评论

报告相同问题?

悬赏问题

  • ¥15 关于#windows#的问题:怎么用WIN 11系统的电脑 克隆WIN NT3.51-4.0系统的硬盘
  • ¥15 matlab有关常微分方程的问题求解决
  • ¥15 perl MISA分析p3_in脚本出错
  • ¥15 k8s部署jupyterlab,jupyterlab保存不了文件
  • ¥15 ubuntu虚拟机打包apk错误
  • ¥199 rust编程架构设计的方案 有偿
  • ¥15 回答4f系统的像差计算
  • ¥15 java如何提取出pdf里的文字?
  • ¥100 求三轴之间相互配合画圆以及直线的算法
  • ¥100 c语言,请帮蒟蒻写一个题的范例作参考