利用XML文件配置数据库

来源：互联网发布：网络大v孙海英编辑：程序博客网时间：2024/05/16 15:58

之前我有介绍过链接数据库，通过java代码，例如下面

@RequestMapping(value = "addlist")    @ResponseBody    public String addList(HttpServletRequest request, HttpServletResponse response) throws Exception     {        String id=request.getParameter("id");        String name=request.getParameter("name");        String number=request.getParameter("number");        String dist=request.getParameter("dist");        String caegory=request.getParameter("caegory");        String checkSql="insert into czymanage values ('"+id+"','"+name+"','"+number+"','"+dist+"','"+caegory+"')";        String driver="net.sourceforge.jtds.jdbc.Driver";        String url="jdbc:jtds:sqlserver://10.20.90.6:1433/EC_Digest";        Class.forName(driver);        Connection conn=DriverManager.getConnection(url,"sa","root123");        Statement stmt=conn.createStatement();        stmt.executeUpdate(checkSql);        stmt.close();        conn.close();        return id;    }

如果只使用一次，可以这么使用，但如果有很多页面很多函数都需要使用，每次都写一个会显得非常繁琐，下面我给大家介绍一下通过数据库的连接简化一下。

1 ProductServiceImpl.java

@Service("productService")public class ProductServiceImpl implements ProductService{    @Autowired    private ComprisProductService comprisProductService;    @Override    public List<listBeans> queryAllCzymanage(listBeans newlistBeans) throws ServiceException    {        if(CMSConfig.getPosType().equalsIgnoreCase("compris")){            return comprisProductService.queryAllCzymanage(newlistBeans);        }else{            return null;        }    }    @Override    public void deleteByidCzymanage(listBeans listbeans) throws ServiceException{        if(CMSConfig.getPosType().equalsIgnoreCase("compris")){            comprisProductService.deleteByidCzymanage(listbeans);        }    }    @Override    public void saveCzymanage(listBeans listbeans) throws ServiceException{        if(CMSConfig.getPosType().equalsIgnoreCase("compris")){            comprisProductService.saveCzymanage(listbeans);        }       }}

2 ComprisProductService.java

@Service("comprisProductService")public class ComprisProductService extends BaseServiceImpl{    @Resource    private BaseDaoImpl dao;    Logger log = LoggerFactory.getLogger(ComprisProductService.class);    public List<listBeans> queryAllCzymanage(listBeans newlistBeans) {        return dao.findAll("productMapper.queryAllCzymanage", newlistBeans);    }    public void deleteByidCzymanage(listBeans listbeans) {        dao.delete("productMapper.deleteCzymanage",listbeans);    }    public List<listBeans> queryAllCzymanage(listBeans newlistBeans) {    public void saveCzymanage(listBeans listbeans) {        dao.save("productMapper.saveCzymanage",listbeans);    }}

3 productMapper.xml

<mapper namespace="productMapper" >    <select id="queryAllCzymanage" parameterType="com.yum.cms.acp.entity.listBeans" resultType="com.yum.cms.acp.entity.listBeans">           <![CDATA[select proid as id,proname as name,pronumber as number,prodist as dist,           procaegory as caegory from czymanage  where 1=1]]>                 <if test="id!=null and id!='' ">                       <![CDATA[ and  proid=#{id}  ]]>                 </if>    </select>    <delete id="deleteCzymanage" parameterType="com.yum.cms.acp.entity.listBeans">        <![CDATA[delete from czymanage where proid=#{id}]]>     </delete>    <insert id="saveCzymanage" parameterType="com.yum.cms.acp.entity.listBeans">        <![CDATA[insert into czymanage (proid,proname,pronumber,prodist,procaegory) values( #{id},#{name},#{number},#{dist},#{caegory})]]>     </insert></mapper>

4 最后要在配置文件sqlMapConfig.xml里写入

<mapper resource="sqlmap/ProductMapper.xml"/>

这样，通过XML连接数据库，再使用方法去调用，可以极大简化代码，使得层次清晰，并且降低耦合性。

0 0