语源科技BlogJava-劳者多能http://www.blogjava.net/chenyu/劳者多能zh-cnMon, 13 Apr 2026 08:53:25 GMTMon, 13 Apr 2026 08:53:25 GMT60Spring 杂记http://www.blogjava.net/chenyu/archive/2012/11/01/390634.html劳者多能劳者多能Thu, 01 Nov 2012 14:09:00 GMThttp://www.blogjava.net/chenyu/archive/2012/11/01/390634.htmlhttp://www.blogjava.net/chenyu/comments/390634.htmlhttp://www.blogjava.net/chenyu/archive/2012/11/01/390634.html#Feedback0http://www.blogjava.net/chenyu/comments/commentRss/390634.htmlhttp://www.blogjava.net/chenyu/services/trackbacks/390634.html Spring JDBC支持

在applicationContext中配置数据连接


 <!-- 配置数据库连接信息 -->
 <bean id="ds" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
  <property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
  <property name="url" value="jdbc:sqlserver://localhost:1433;databaseName=testdb" />
  <property name="username" value="sa" />
  <property name="password" value="123456" />
 </bean>

然后给目标对象注入dataSource参数     目标对象类型继承自（extends） jdbcTemplate

查询方法示例：
 public List<dept> queryAll(){
    
    return super.query("sql语句", new RowMapper(){
            //实现该类（RowMapper）中方法 
            return 返回实体   
            public Dept mapRow(ResultSet rs, int index) throws SQLException {
    
            Dept d = new Dept();
    
            d.setDid(rs.getInt("did"));
            d.setDname(rs.getString("dname"));
    
            return d;
        
    });

}



劳者多能 2012-11-01 22:09 发表评论
]]>Hibernate杂记http://www.blogjava.net/chenyu/archive/2012/10/31/390546.html劳者多能劳者多能Wed, 31 Oct 2012 08:57:00 GMThttp://www.blogjava.net/chenyu/archive/2012/10/31/390546.htmlhttp://www.blogjava.net/chenyu/comments/390546.htmlhttp://www.blogjava.net/chenyu/archive/2012/10/31/390546.html#Feedback0http://www.blogjava.net/chenyu/comments/commentRss/390546.htmlhttp://www.blogjava.net/chenyu/services/trackbacks/390546.htmlHibernate使用getCurrentSession用法：需要在hibernate中配置：
<property name="hibernate.current_session_context_class">thread</property>


劳者多能 2012-10-31 16:57 发表评论
]]>