数据库里有Account表,有username和password两个字段。现在用ibatorConfig.xml自动生成Account.class和AccountDAO.class以及AccountDAOImpl.class和sqmlmap.xml。
ibatorConfig.xml内容如下
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE ibatorConfiguration PUBLIC "-//Apache Software Foundation//DTD Apache iBATIS Ibator Configuration 1.0//EN" "http://ibatis.apache.org/dtd/ibator-config_1_0.dtd" >
<ibatorConfiguration >
<!-- 数据库驱动包地址 -->
<classPathEntry location="E:\jar\mysql-connector-java-5.1.18-bin.jar" />
<ibatorContext id="context1" >
<jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://192.168.1.247:3306/stuDB" userId="remote" password="123456" />
<javaModelGenerator targetPackage="com.yz" targetProject="Testing" />
<sqlMapGenerator targetPackage="com.yz" targetProject="Testing" />
<daoGenerator targetPackage="com.yz" targetProject="Testing" type="SPRING" />
<table schema="stuDB" tableName="Account" >
<property name="ignoreQualifiersAtRuntime" value="true" />
</table>
</ibatorContext>
</ibatorConfiguration>如何才能向表Account插入或查询数据?
具体代码是什么
ibatorConfig.xml内容如下
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE ibatorConfiguration PUBLIC "-//Apache Software Foundation//DTD Apache iBATIS Ibator Configuration 1.0//EN" "http://ibatis.apache.org/dtd/ibator-config_1_0.dtd" >
<ibatorConfiguration >
<!-- 数据库驱动包地址 -->
<classPathEntry location="E:\jar\mysql-connector-java-5.1.18-bin.jar" />
<ibatorContext id="context1" >
<jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://192.168.1.247:3306/stuDB" userId="remote" password="123456" />
<javaModelGenerator targetPackage="com.yz" targetProject="Testing" />
<sqlMapGenerator targetPackage="com.yz" targetProject="Testing" />
<daoGenerator targetPackage="com.yz" targetProject="Testing" type="SPRING" />
<table schema="stuDB" tableName="Account" >
<property name="ignoreQualifiersAtRuntime" value="true" />
</table>
</ibatorContext>
</ibatorConfiguration>如何才能向表Account插入或查询数据?
具体代码是什么
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货