各位大侠,我快抓狂了。。 帮一下哈。谢谢了!!!!
sqlMapConfig.xml如下:<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE sqlMapConfig
PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd"><sqlMapConfig> <!-- Configure a built-in transaction manager. If you're using an
app server, you probably want to use its transaction manager
and a managed datasource -->
<transactionManager type="JDBC" commitRequired="false">
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver"/>
<property name="JDBC.ConnectionURL" value="jdbc:oracle:thin:@localhost:1521:orcl"/>
<property name="JDBC.Username" value="cjq"/>
<property name="JDBC.Password" value="cjq"/>
</dataSource>
</transactionManager> <sqlMap resource="com/demo/hibernate/beans/user_SqlMap.xml"/>
</sqlMapConfig>
user_SqlMap.xml 如下 :<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE sqlMap
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd"><sqlMap namespace="user">
<select id="getUser" resultClass="com.demo.hibernate.beans.User">
select * from t_user where username=#username#
</select>
</sqlMap>UserDAOImpl 类如下:public class UserDAOImpl implements UserDAO{
private SqlMapClient sqlMapClient; public User getUser(String username) throws SQLException {
User record=(User)sqlMapClient.queryForObject("user.getUser",username);
return record;
} public SqlMapClient getSqlMapClient() {
return sqlMapClient;
} public void setSqlMapClient(SqlMapClient sqlMapClient) {
this.sqlMapClient = sqlMapClient;
}
}
sqlMapConfig.xml如下:<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE sqlMapConfig
PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd"><sqlMapConfig> <!-- Configure a built-in transaction manager. If you're using an
app server, you probably want to use its transaction manager
and a managed datasource -->
<transactionManager type="JDBC" commitRequired="false">
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver"/>
<property name="JDBC.ConnectionURL" value="jdbc:oracle:thin:@localhost:1521:orcl"/>
<property name="JDBC.Username" value="cjq"/>
<property name="JDBC.Password" value="cjq"/>
</dataSource>
</transactionManager> <sqlMap resource="com/demo/hibernate/beans/user_SqlMap.xml"/>
</sqlMapConfig>
user_SqlMap.xml 如下 :<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE sqlMap
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd"><sqlMap namespace="user">
<select id="getUser" resultClass="com.demo.hibernate.beans.User">
select * from t_user where username=#username#
</select>
</sqlMap>UserDAOImpl 类如下:public class UserDAOImpl implements UserDAO{
private SqlMapClient sqlMapClient; public User getUser(String username) throws SQLException {
User record=(User)sqlMapClient.queryForObject("user.getUser",username);
return record;
} public SqlMapClient getSqlMapClient() {
return sqlMapClient;
} public void setSqlMapClient(SqlMapClient sqlMapClient) {
this.sqlMapClient = sqlMapClient;
}
}
public User getUser(String username) throws SQLException {
User record=(User)sqlMapClient.queryForObject("user.getUser",username);
return record;
}方法调用中user.getUser 去掉user.
或者在sql-map-config.xml 中加
<settings useStatementNamespaces="true" />