No DataSource specified

忘是亡心i 2022-03-16 10:26 259阅读 0赞

### **使用jdbcTemplate操控数据库结果出现如下错误：**  ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NTkxNjM3_size_16_color_FFFFFF_t_70][]

--------------------

### **错误代码如下** ###

package cn.com.compent;
    
    import java.util.List;
    
    import org.springframework.jdbc.core.BeanPropertyRowMapper;
    import org.springframework.jdbc.core.JdbcTemplate;
    import org.springframework.jdbc.core.RowMapper;
    import org.springframework.jdbc.support.rowset.SqlRowSet;
    
    import cn.com.bean.Port;
    
    public class TemplateJDBC {
    /*author:命运的信徒
     * date:2019/02/27
     * arm:通过templatjdbc来操控数据库
     */
    	
    	public static void main(String[] args) {
    		select();
    	}
    	public static void select(){
    		JdbcTemplate jt=new JdbcTemplate();
    		String sql="select * from Port";
    		RowMapper<Port> rowMapper=new BeanPropertyRowMapper<Port>(Port.class);
    		Port li=jt.queryForObject(sql, rowMapper);
    		System.out.println(li.toString());
    		
    	}
    }

--------------------

### **错误原因：** ###

### **没有加载spring的配置文件容器** ###

--------------------

**正确代码如下**

package cn.com.compent;
    
    import java.util.List;
    
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    import org.springframework.jdbc.core.BeanPropertyRowMapper;
    import org.springframework.jdbc.core.JdbcTemplate;
    import org.springframework.jdbc.core.RowMapper;
    
    import cn.com.bean.Port;
    
    public class TemplateJDBC {
    /*author:命运的信徒
     * date:2019/02/27
     * arm:通过templatjdbc来操控数据库
     */
    	
    	public static void main(String[] args) {
    		select();
    	}
    	public static void select(){
    		ApplicationContext ioc=new ClassPathXmlApplicationContext("applicationContext.xml");
    		JdbcTemplate jt=(JdbcTemplate) ioc.getBean("jdbcTemplate");
    		String sql="select * from Port";
    		RowMapper<Port> rowMapper=new BeanPropertyRowMapper<Port>(Port.class);
    		List<Port> li=(List<Port>) jt.queryForObject(sql, rowMapper);
    		for (Port port : li) {
    			System.out.println(port.toString());
    		}
    		
    	}
    }

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NTkxNjM3_size_16_color_FFFFFF_t_70]: /images/20220316/afbef999cc3541cb8fa72399700db908.png

No DataSource specified

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Failed to configure a DataSource: ‘url‘ attribute is not specified and no embedded datasource could

相关【error】Failed to configure a DataSource: ‘url‘ attribute is not specified and no embedded datasource

相关 Failed to configure a DataSource: ‘url‘ attribute is not specified and no embedded datasource could

相关报错 :configure a DataSource: ‘url‘ attribute is not specified and no embedded datasource could

相关 Failed to configure a DataSource: ‘url‘ attribute is not specified and no embedded datasource could

相关 Failed to configure a DataSource: ‘url‘ attribute is not specified and no embedded datasource could

相关 Failed to configure a DataSource: ‘url‘ attribute is not specified and no embedded datasource could

相关 Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could

相关 No DataSource specified

相关 Failed to configure a DataSource: 'url' attribute is not specified and no embedded datasource could