??xml version="1.0" encoding="utf-8" standalone="yes"?>成人精品一区二区三区电影,性色av一区,作爱视频免费观看视频在线播放激情网 http://www.aygfsteel.com/BlogJava522935502/articles/354118.html吕鹏-Roc吕鹏-RocMon, 11 Jul 2011 09:55:00 GMThttp://www.aygfsteel.com/BlogJava522935502/articles/354118.htmlhttp://www.aygfsteel.com/BlogJava522935502/comments/354118.htmlhttp://www.aygfsteel.com/BlogJava522935502/articles/354118.html#Feedback1http://www.aygfsteel.com/BlogJava522935502/comments/commentRss/354118.htmlhttp://www.aygfsteel.com/BlogJava522935502/services/trackbacks/354118.htmlpackage cn.zbvc.util;

import java.util.List;

import cn.zbvc.bean.User;

public class PageBean {
    
private List<User> list;  //要返回的某一늚记录列表
    
    
private int allRow; //总记录数
    private int totalPage;  //总页?/span>
    private int currentPage;  //当前?/span>
    private int pageSize;  //每页的记录数
    
    
private boolean isFirstPage;  //是否为当前第一?/span>
    private boolean isLastPage;  //是否为最后一?/span>
    private boolean hasPreviousPage;  //是否有前一?/span>
    private boolean hasNextPage;  //是否有下一?/span>
    
    
public List<User> getList() {
        
return list;
    }
    
public void setList(List<User> list) {
        
this.list = list;
    }
    
public int getAllRow() {
        
return allRow;
    }
    
public void setAllRow(int allRow) {
        
this.allRow = allRow;
    }
    
public int getTotalPage() {
        
return totalPage;
    }
    
public void setTotalPage(int totalPage) {
        
this.totalPage = totalPage;
    }
    
public int getCurrentPage() {
        
return currentPage;
    }
    
public void setCurrentPage(int currentPage) {
        
this.currentPage = currentPage;
    }
    
public int getPageSize() {
        
return pageSize;
    }
    
public void setPageSize(int pageSize) {
        
this.pageSize = pageSize;
    }
    
public boolean isFirstPage() {
        
return isFirstPage;
    }
    
public boolean isLastPage() {
        
return isLastPage;
    }
    
public boolean isHasPreviousPage() {
        
return hasPreviousPage;
    }
    
public boolean isHasNextPage() {
        
return hasNextPage;
    }
    
    
/**
     * 初始化分信?br />      
*/
    
public void init(){
        
this.isFirstPage = isFirstPage;
        
this.isLastPage = isLastPage;
        
this.hasPreviousPage = hasPreviousPage;
        
this.hasNextPage = hasNextPage;
    }
    
    
/**
     * 计算总页?nbsp; 静态方?br />      * 
@param pageSize  每页的记录数
     * 
@param allRow  总记录数
     * 
@return 总页?br />      */
    
public static int countTatalPage(final int pageSize,final int allRow){
        
int toalPage = allRow % pageSize == 0 ? allRow/pageSize : allRow/pageSize + 1;
        
return toalPage;
    }
    
    
/**
     * 计算当前开始的记录
     * 
@param pageSize 每页记录?br />      * @param currentPage 当前W几?br />      * @return 当前开始记录号
     
*/
    
public static int countOffset(final int pageSize,final int currentPage){
        
final int offset = pageSize * (currentPage - 1);
        
return offset;
    }
    
    
/**
     * 计算当前,若ؓ(f)0或者请求的URL中没?#8220;?page = ”则用1代替
     * 
@param page 传入的参敎ͼ可能为空Q即0  则返?Q?br />      * @return
     
*/
    
public static int countCurrentPage(int page){
        
final int curpage = (page == 0 ? 1 : page);
        
return curpage;
    }    
    
}
@import url(http://www.aygfsteel.com/CuteSoft_Client/CuteEditor/Load.ashx?type=style&file=SyntaxHighlighter.css);@import url(/css/cuteeditor.css);

吕鹏-Roc 2011-07-11 17:55 发表评论
]]>
SSH基础上分功能的实现http://www.aygfsteel.com/BlogJava522935502/articles/354039.html吕鹏-Roc吕鹏-RocSun, 10 Jul 2011 06:04:00 GMThttp://www.aygfsteel.com/BlogJava522935502/articles/354039.htmlhttp://www.aygfsteel.com/BlogJava522935502/comments/354039.htmlhttp://www.aygfsteel.com/BlogJava522935502/articles/354039.html#Feedback6http://www.aygfsteel.com/BlogJava522935502/comments/commentRss/354039.htmlhttp://www.aygfsteel.com/BlogJava522935502/services/trackbacks/354039.html

参考网址1Q?/font>http://www.aygfsteel.com/BlogJava522935502/

参考网址2Q?/font>http://blog.csdn.net/qq522935502/

资料部分借鉴Q?a href="http://www.aygfsteel.com/rongxh7/">http://www.aygfsteel.com/rongxh7/

 

 

上节课,我们完成了一?font face="Times New Roman">SSH整合?/font>CRUD操作案例Qƈ且完善了其国际化以及(qing)校验{内容,q节课,我们l箋加以完善Q我们知道,当我们查询数据库的内容过多的时候,昄在页面上的内容就比较冗长Q所以分늚实现显的十分有必要了。分功能的实现是必不可的Q掌握一CU分|术在在实际开发前是有必要的,前两天浏览博客的时候看C一个程序员的博文写的一个分功能的实现非常好,在这里,分nl大家?/font>

 

在讲解分功能实C前,大家必须对分|一定的了解Q知道分늚几个要素Q总记录数Q每|C数Q共几页Q当前页{?/p>

 

在上个例子的基础上我们开始完善我们的E序?/p>

 

1.首先我们先新建立一个接?font face="Times New Roman">MemberDao.java,把所需要用到的Ҏ(gu)列出来:(x)


package cn.zbvc.dao;
import java.util.List;
import cn.zbvc.bean.User;
public interface MemberDao {
/**
 * 分页查询
 * 
@param hql  查询条g
 * 
@param offset  开始记?br />  * @param length  一ơ查询几条记?br />  * @return 查询的记录集?br />  */
public List<User> queryForPage(final String hql,final int offset,final int length);
/**
 * 查询所有的记录?br />  * 
@param hql 查询条g
 * 
@return 总记录数
 
*/
public int getAllRowCount(String hql);
}

 

 

2.然后我们创徏其实现类Q?font face="Times New Roman">MemberDaoImpl.java

package cn.zbvc.dao.impl;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import cn.zbvc.bean.User;
import cn.zbvc.dao.MemberDao;
public class MemberDaoImpl extends HibernateDaoSupport implements MemberDao {
/**
 * 查询所有的记录?br />  * 
@param hql 查询条g
 * 
@return 总记录数
 
*/
public int getAllRowCount(String hql) {
return this.getHibernateTemplate().find(hql).size();
}
/**
 * 分页查询
 * 
@param hql  查询条g
 * 
@param offset  开始记?br />  * @param length  一ơ查询几条记?br />  * @return 查询的记录集?br />  */
@SuppressWarnings(
"unchecked")
public List<User> queryForPage(final String hql, final int offset, final int length) {
Session session 
= this.getSession();
Query q 
= session.createQuery(hql);
q.setFirstResult(offset);
q.setMaxResults(length);
List
<User> list = q.list();
System.out.println(list.size());
session.close();
return list;
}

 

 

大家可以看到Q我们一共定义了两个Ҏ(gu)Q第一个方式是获取数据库表的总记录数Q第二个Ҏ(gu)是获取我们想要获取的某一늚数据集合Q传递的三个参数分别是:(x)查询条g、开始的记录、结束的记录?/p>

 

l心的读者会(x)发现Q这个类l承?font face="Times New Roman">HibernateDaoSupportc,HibernateDaoSupport?/font>Spring提供的对Hibernate支持的类Q在其参数内Q我们能像原生的Hibernate一栯?/font>query.setFirstResult(offset)?/font>query.setMaxResults(length)来实现分|询功能?/font>

 

 

3.然后我们需要徏立一个获取分信息的pageBean.java:

package cn.zbvc.util;
import java.util.List;
import cn.zbvc.bean.User;
public class PageBean {
private List<User> list;  //要返回的某一늚记录列表
private int allRow; //总记录数
private int totalPage;  //总页?/span>
private int currentPage;  //当前?/span>
private int pageSize;  //每页的记录数
private boolean isFirstPage;  //是否为当前第一?/span>
private boolean isLastPage;  //是否为最后一?/span>
private boolean hasPreviousPage;  //是否有前一?/span>
private boolean hasNextPage;  //是否有下一?/span>
Set and getҎ(gu)
PageBean中的具体Ҏ(gu)Q?br />
/**
 * 初始化分信?br />  
*/
public void init(){
this.isFirstPage = isFirstPage;
this.isLastPage = isLastPage;
this.hasPreviousPage = hasPreviousPage;
this.hasNextPage = hasNextPage;
}
/**
 * 计算总页?nbsp; 静态方?br />  * 
@param pageSize  每页的记录数
 * 
@param allRow  总记录数
 * 
@return 总页?br />  */
public static int countTatalPage(final int pageSize,final int allRow){
int toalPage = allRow % pageSize == 0 ? allRow/pageSize : allRow/pageSize + 1;
return toalPage;
}
/**
 * 计算当前开始的记录
 * 
@param pageSize 每页记录?br />  * @param currentPage 当前W几?br />  * @return 当前开始记录号
 
*/
public static int countOffset(final int pageSize,final int currentPage){
final int offset = pageSize * (currentPage - 1);
return offset;
}
/**
 * 计算当前,若ؓ(f)0或者请求的URL中没?#8220;?page = ”则用1代替
 * 
@param page 传入的参敎ͼ可能为空Q即0  则返?Q?br />  * @return
 
*/
public static int countCurrentPage(int page){
final int curpage = (page == 0 ? 1 : page);
return curpage;
}    }

 

 

 

4.业务逻辑层的实现Q我们现在就只操?font face="Times New Roman">UserQ现在我们在UserService中定义一个方法:(x)

/**
 * 分页查询  
 * 
@param pageSize  每页昄多少记录
 * 
@param currentPage 当前?br />  * @return 装了分信息的bean
 
*/
public PageBean queryForPage(int pageSize,int page);

 

 

5.使用UserServiceImpl实现q个具体Ҏ(gu)Q?/font>

/**
 * 分页查询  
 * 
@param pageSize  每页昄多少记录
 * 
@param currentPage 当前?br />  * @return 装了分信息的bean
 
*/
public PageBean queryForPage(int pageSize, int page) {
final String hql = "from User user order by user.id"//查询语句
int allRow = memberDao.getAllRowCount(hql);  //总记录数
int totalPage = PageBean.countTatalPage(pageSize, allRow); //总页?/span>
final int offset = PageBean.countOffset(pageSize, page); //当前开始记?/span>
final int length = pageSize; // 每页记录?/span>
final int currentPage = PageBean.countCurrentPage(page); // 当前?/span>
List list = memberDao.queryForPage(hql, offset, length); //
//把分信息保存到Bean当中
PageBean pageBean  = new PageBean();
pageBean.setPageSize(pageSize);
pageBean.setCurrentPage(currentPage);
pageBean.setAllRow(allRow);
pageBean.setTotalPage(totalPage);
pageBean.setList(list);
pageBean.init();
return pageBean;
}

 

 

6.然后我们Z不媄(jing)响上一个例子,我们新创Z?font face="Times New Roman">ListUserAction2.java:

package cn.zbvc.action.user;
import java.util.List;
import com.opensymphony.xwork2.ActionSupport;
import cn.zbvc.bean.User;
import cn.zbvc.service.UserService;
import cn.zbvc.util.PageBean;
public class ListUserAction2 extends ActionSupport {
private UserService service;//通过Spring创徏业务层对?nbsp; 使用setҎ(gu)依赖注入
private PageBean pageBean; //装了分信息和数据内容的pageBean
private List<User> listUser;//用于储存pageBean当中被封装的User信息
private int page = 1//表示从网中q回的当前页的?nbsp; 默认? 表示默认昄W一内?/span>
public int getPage() {
return page;
}
public void setPage(int page) {
this.page = page;
}
public List<User> getListUser() {
return listUser;
}
public void setListUser(List<User> listUser) {
this.listUser = listUser;
}
public PageBean getPageBean() {
return pageBean;
}
public void setPageBean(PageBean pageBean) {
this.pageBean = pageBean;
}
public void setService(UserService service) {
this.service = service;
}
public String execute()throws Exception{
this.pageBean = service.queryForPage(5, page);//获取装了分信息和数据的pageBean
this.listUser = this.pageBean.getList(); //获取数据
return SUCCESS;
}
}

 

 

7.配置applicationContext.xml?/font>struts.xml的相关信息,q里省略了?/font>

8.?font face="Times New Roman">listUser2.jsp面中添加分内容:(x)

<s:iterator value="pageBean">
        
<tr>
         
<td colspan="6" align="center" bgcolor="#5BA8DE">
         ?/span><s:property value="allRow"/>条记?nbsp;   
         ?/span><s:property value="totalPage"/>?nbsp;   
         当前W?/span><s:property value="currentPage"/>?/span><br>
    
         
<s:if test="%{currentPage == 1}">
           W一?nbsp; 上一?br />          
</s:if>
         
<!-- currentPage为当前页 -->
         
<s:else>
           
<href="listUser2.action?page=1">W一?/span></a>
           
<href="listUser2.action?page=<s:property value="%{currentPage-1}"/>">上一?/span></a>
         
</s:else>
    
         
<s:if test="%{currentPage != totalPage}">
         
<href="listUser2.action?page=<s:property value="%{currentPage+1}"/>">下一?/span></a>
         
<href="listUser2.action?page=<s:property value="totalPage"/>">最后一?/span></a>
            
</s:if>
    
         
<s:else>
         下一?nbsp; 最后一?br />          
</s:else>
         
</td>
        
</tr>
</s:iterator>

 

 

 

9.查看效果Q?/p>


10.思考ȝ

关于分页功能实现Q应该是有有很多U解x法,我介l的q种解决Ҏ(gu)是ؓ(f)了给大家一?/p>

范例Q让大家明白分页功能实现的原理,其中Q大部分的内容借鉴了之前提到的|址。接下来的时_(d)我会(x)l箋学习(fn)关于分页功能的其它实现方式,然后分nl大Ӟ另外Q还?x)l的整理SSH的整合?/font>

 



吕鹏-Roc 2011-07-10 14:04 发表评论
]]>
java日期处理beanhttp://www.aygfsteel.com/BlogJava522935502/articles/354029.html吕鹏-Roc吕鹏-RocSun, 10 Jul 2011 02:13:00 GMThttp://www.aygfsteel.com/BlogJava522935502/articles/354029.htmlhttp://www.aygfsteel.com/BlogJava522935502/comments/354029.htmlhttp://www.aygfsteel.com/BlogJava522935502/articles/354029.html#Feedback0http://www.aygfsteel.com/BlogJava522935502/comments/commentRss/354029.htmlhttp://www.aygfsteel.com/BlogJava522935502/services/trackbacks/354029.htmlimport java.text.ParsePosition; import java.text.SimpleDateFormat; import java....  阅读全文

吕鹏-Roc 2011-07-10 10:13 发表评论
]]>
java讉K资源文ghttp://www.aygfsteel.com/BlogJava522935502/articles/354028.html吕鹏-Roc吕鹏-RocSun, 10 Jul 2011 02:12:00 GMThttp://www.aygfsteel.com/BlogJava522935502/articles/354028.htmlhttp://www.aygfsteel.com/BlogJava522935502/comments/354028.htmlhttp://www.aygfsteel.com/BlogJava522935502/articles/354028.html#Feedback0http://www.aygfsteel.com/BlogJava522935502/comments/commentRss/354028.htmlhttp://www.aygfsteel.com/BlogJava522935502/services/trackbacks/354028.html
import java.io.FileInputStream;   
import java.io.FileOutputStream;   
import java.util.Properties;   
  
public class PropertyEditor {   
    
public static void main(String[] args) throws Exception {   
        Properties prop 
= new Properties();// 属性集合对?nbsp;  
        FileInputStream fis = new FileInputStream("prop.properties");// 属性文件输入流   (相对于根目录下的文g名,要加上包?nbsp;“src/prop.properties”)
        prop.load(fis);// 属性文件流装蝲到Properties对象?nbsp;  
        fis.close();// 关闭?nbsp;  
  
        
// 获取属性|sitename已在文g中定?nbsp;  
        System.out.println("获取属性|(x)sitename=" + prop.getProperty("sitename"));   
        
// 获取属性|country未在文g中定义,在此程序中q回一个默认|但ƈ不修改属性文?nbsp;  
        System.out.println("获取属性|(x)country=" + prop.getProperty("country""中国"));   
  
        
// 修改sitename的属性?nbsp;  
        prop.setProperty("sitename""中国");   
        
// d一个新的属性studio   
        prop.setProperty("studio""Boxcode Studio");   
        
// 文g输出?nbsp;  
        FileOutputStream fos = new FileOutputStream("prop.properties");   
        
// Properties集合保存到流?nbsp;  
        prop.store(fos, "Copyright (c) Boxcode Studio");   
        fos.close();
// 关闭?nbsp;  
    }   
}

/*
 *资源文g

sitename=\u4E2D\u56FD
siteurl=www.abcjava.com ? 
studio=Boxcode Studio
 *
 *
*/


吕鹏-Roc 2011-07-10 10:12 发表评论
]]>
java自定义按?/title><link>http://www.aygfsteel.com/BlogJava522935502/articles/354027.html</link><dc:creator>吕鹏-Roc</dc:creator><author>吕鹏-Roc</author><pubDate>Sun, 10 Jul 2011 02:08:00 GMT</pubDate><guid>http://www.aygfsteel.com/BlogJava522935502/articles/354027.html</guid><wfw:comment>http://www.aygfsteel.com/BlogJava522935502/comments/354027.html</wfw:comment><comments>http://www.aygfsteel.com/BlogJava522935502/articles/354027.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/BlogJava522935502/comments/commentRss/354027.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/BlogJava522935502/services/trackbacks/354027.html</trackback:ping><description><![CDATA[<br /> <div style="background-color: #eeeeee; font-size: 13px; border-left-color: #cccccc; padding-right: 5px; padding-bottom: 4px; padding-left: 4px; padding-top: 4px; width: 98%; word-break: break-all; "><!--<br /> <br /> Code highlighting produced by Actipro CodeHighlighter (freeware)<br /> http://www.CodeHighlighter.com/<br /> <br /> --><span style="color: #0000FF; ">package</span><span style="color: #000000; "> cn.zbvc.java;<br /> </span><span style="color: #0000FF; ">import</span><span style="color: #000000; "> java.awt.FlowLayout;<br /> </span><span style="color: #0000FF; ">import</span><span style="color: #000000; "> javax.swing.JButton;<br /> </span><span style="color: #0000FF; ">import</span><span style="color: #000000; "> javax.swing.JFrame;<br /> </span><span style="color: #0000FF; ">import</span><span style="color: #000000; "> javax.swing.UIManager;<br /> </span><span style="color: #0000FF; ">import</span><span style="color: #000000; "> javax.swing.plaf.synth.SynthLookAndFeel;<br />  <br /> </span><span style="color: #0000FF; ">public</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">class</span><span style="color: #000000; "> MyButton {<br />  JFrame frame </span><span style="color: #000000; ">=</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">new</span><span style="color: #000000; "> JFrame(</span><span style="color: #000000; ">"</span><span style="color: #000000; ">Test Buttons</span><span style="color: #000000; ">"</span><span style="color: #000000; ">);<br />  JButton jButton </span><span style="color: #000000; ">=</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">new</span><span style="color: #000000; "> JButton(</span><span style="color: #000000; ">"</span><span style="color: #000000; ">JButton</span><span style="color: #000000; ">"</span><span style="color: #000000; ">); </span><span style="color: #008000; ">//</span><span style="color: #008000; "> 按钮</span><span style="color: #008000; "><br /> </span><span style="color: #000000; "> </span><span style="color: #0000FF; ">public</span><span style="color: #000000; "> MyButton() {<br />   frame.setLayout(</span><span style="color: #0000FF; ">new</span><span style="color: #000000; "> FlowLayout());<br />   frame.getContentPane().add(jButton);<br />  }<br />  </span><span style="color: #0000FF; ">public</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">void</span><span style="color: #000000; "> show() {<br />   frame.pack();<br />   frame.show();<br />  }<br />  </span><span style="color: #0000FF; ">public</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">static</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">void</span><span style="color: #000000; "> main(String[] args) {<br />   MyButton tb </span><span style="color: #000000; ">=</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">new</span><span style="color: #000000; "> MyButton();<br />   tb.show();<br />   SynthLookAndFeel slf </span><span style="color: #000000; ">=</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">new</span><span style="color: #000000; "> SynthLookAndFeel();<br />   </span><span style="color: #0000FF; ">try</span><span style="color: #000000; "> {<br />       slf.load(MyButton.</span><span style="color: #0000FF; ">class</span><span style="color: #000000; ">.getResourceAsStream(</span><span style="color: #000000; ">"</span><span style="color: #000000; ">mybutton.xml</span><span style="color: #000000; ">"</span><span style="color: #000000; ">), MyButton.</span><span style="color: #0000FF; ">class</span><span style="color: #000000; ">);<br />       UIManager.setLookAndFeel(slf);<br />   } </span><span style="color: #0000FF; ">catch</span><span style="color: #000000; "> (Exception e) {<br />       e.printStackTrace();<br />       </span><span style="color: #0000FF; ">return</span><span style="color: #000000; ">;<br />   }<br /> <br />  }<br /> }<br /> <br /> </span><span style="color: #008000; ">/*</span><span style="color: #008000; "><br />  *<br />  *<synth><br />   <style id="mybutton"><br />      <state><br />        <imagePainter method="buttonBackground" path="mybutton.png" sourceInsets="3 6 12 20" paintCenter="true" stretch="true"/><br />     <insets top="3" left="6" bottom="12" right="20"/><br />     <font name="Aharoni" size="16"/><br />   </state><br />   <property key="Button.margin" type="insets" value="0 0 5 8"/><br />   </style><br />   <bind style="mybutton" type="region" key="Button"/><br /> </synth><br />  *<br />  *</span><span style="color: #008000; ">*/</span></div> <img src ="http://www.aygfsteel.com/BlogJava522935502/aggbug/354027.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/BlogJava522935502/" target="_blank">吕鹏-Roc</a> 2011-07-10 10:08 <a href="http://www.aygfsteel.com/BlogJava522935502/articles/354027.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>JDBC的增删改查操?/title><link>http://www.aygfsteel.com/BlogJava522935502/articles/354025.html</link><dc:creator>吕鹏-Roc</dc:creator><author>吕鹏-Roc</author><pubDate>Sun, 10 Jul 2011 02:06:00 GMT</pubDate><guid>http://www.aygfsteel.com/BlogJava522935502/articles/354025.html</guid><wfw:comment>http://www.aygfsteel.com/BlogJava522935502/comments/354025.html</wfw:comment><comments>http://www.aygfsteel.com/BlogJava522935502/articles/354025.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.aygfsteel.com/BlogJava522935502/comments/commentRss/354025.html</wfw:commentRss><trackback:ping>http://www.aygfsteel.com/BlogJava522935502/services/trackbacks/354025.html</trackback:ping><description><![CDATA[<br /> <div style="background-color: #eeeeee; font-size: 13px; border-left-color: #cccccc; padding-right: 5px; padding-bottom: 4px; padding-left: 4px; padding-top: 4px; width: 98%; word-break: break-all; "><!--<br /> <br /> Code highlighting produced by Actipro CodeHighlighter (freeware)<br /> http://www.CodeHighlighter.com/<br /> <br /> --><span style="color: #008080; ">  1</span> <span style="color: #0000FF; ">package</span><span style="color: #000000; "> cn.zbvc.java;<br /> </span><span style="color: #008080; ">  2</span> <span style="color: #000000; "></span><span style="color: #0000FF; ">import</span><span style="color: #000000; "> java.io.InputStream;<br /> </span><span style="color: #008080; ">  3</span> <span style="color: #000000; "></span><span style="color: #0000FF; ">import</span><span style="color: #000000; "> java.sql.Connection;<br /> </span><span style="color: #008080; ">  4</span> <span style="color: #000000; "></span><span style="color: #0000FF; ">import</span><span style="color: #000000; "> java.sql.DriverManager;<br /> </span><span style="color: #008080; ">  5</span> <span style="color: #000000; "></span><span style="color: #0000FF; ">import</span><span style="color: #000000; "> java.sql.ResultSet;<br /> </span><span style="color: #008080; ">  6</span> <span style="color: #000000; "></span><span style="color: #0000FF; ">import</span><span style="color: #000000; "> java.sql.SQLException;<br /> </span><span style="color: #008080; ">  7</span> <span style="color: #000000; "></span><span style="color: #0000FF; ">import</span><span style="color: #000000; "> java.sql.Statement;<br /> </span><span style="color: #008080; ">  8</span> <span style="color: #000000; "></span><span style="color: #0000FF; ">import</span><span style="color: #000000; "> java.util.Properties;<br /> </span><span style="color: #008080; ">  9</span> <span style="color: #000000; "><br /> </span><span style="color: #008080; "> 10</span> <span style="color: #000000; "><br /> </span><span style="color: #008080; "> 11</span> <span style="color: #000000; "></span><span style="color: #0000FF; ">public</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">class</span><span style="color: #000000; "> JDBConnection {<br /> </span><span style="color: #008080; "> 12</span> <span style="color: #000000; ">    </span><span style="color: #0000FF; ">public</span><span style="color: #000000; "> Connection conn </span><span style="color: #000000; ">=</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">null</span><span style="color: #000000; ">; </span><span style="color: #008000; ">//</span><span style="color: #008000; "> 声明Connection对象的实?/span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 13</span> <span style="color: #008000; "></span><span style="color: #000000; ">    </span><span style="color: #0000FF; ">public</span><span style="color: #000000; "> Statement stmt </span><span style="color: #000000; ">=</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">null</span><span style="color: #000000; ">; </span><span style="color: #008000; ">//</span><span style="color: #008000; "> 声明Statement对象的实?/span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 14</span> <span style="color: #008000; "></span><span style="color: #000000; ">    </span><span style="color: #0000FF; ">public</span><span style="color: #000000; "> ResultSet rs </span><span style="color: #000000; ">=</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">null</span><span style="color: #000000; ">; </span><span style="color: #008000; ">//</span><span style="color: #008000; "> 声明ResultSet对象的实?/span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 15</span> <span style="color: #008000; "></span><span style="color: #000000; ">    <br /> </span><span style="color: #008080; "> 16</span> <span style="color: #000000; ">    </span><span style="color: #0000FF; ">private</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">static</span><span style="color: #000000; "> String dbClassName </span><span style="color: #000000; ">=</span><span style="color: #000000; "> </span><span style="color: #000000; ">"</span><span style="color: #000000; ">com.microsoft.jdbc.sqlserver.SQLServerDriver</span><span style="color: #000000; ">"</span><span style="color: #000000; ">;</span><span style="color: #008000; ">//</span><span style="color: #008000; ">定义保存数据库驱动的变量</span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 17</span> <span style="color: #008000; "></span><span style="color: #000000; ">    </span><span style="color: #0000FF; ">private</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">static</span><span style="color: #000000; "> String dbUrl </span><span style="color: #000000; ">=</span><span style="color: #000000; "> </span><span style="color: #000000; ">"</span><span style="color: #000000; ">jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=DB_ATM</span><span style="color: #000000; ">"</span><span style="color: #000000; ">;<br /> </span><span style="color: #008080; "> 18</span> <span style="color: #000000; ">    </span><span style="color: #0000FF; ">private</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">static</span><span style="color: #000000; "> String dbUser </span><span style="color: #000000; ">=</span><span style="color: #000000; "> </span><span style="color: #000000; ">"</span><span style="color: #000000; ">sa</span><span style="color: #000000; ">"</span><span style="color: #000000; ">;<br /> </span><span style="color: #008080; "> 19</span> <span style="color: #000000; ">    </span><span style="color: #0000FF; ">private</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">static</span><span style="color: #000000; "> String dbPwd </span><span style="color: #000000; ">=</span><span style="color: #000000; "> </span><span style="color: #000000; ">"</span><span style="color: #000000; ">sa</span><span style="color: #000000; ">"</span><span style="color: #000000; ">;<br /> </span><span style="color: #008080; "> 20</span> <span style="color: #000000; "><br /> </span><span style="color: #008080; "> 21</span> <span style="color: #000000; ">    </span><span style="color: #0000FF; ">public</span><span style="color: #000000; "> JDBConnection(String propertyFileName) {</span><span style="color: #008000; ">//</span><span style="color: #008000; "> 带属性文件名的构造方?/span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 22</span> <span style="color: #008000; "></span><span style="color: #000000; ">        Properties prop </span><span style="color: #000000; ">=</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">new</span><span style="color: #000000; "> Properties();</span><span style="color: #008000; ">//</span><span style="color: #008000; "> 属性集合对?/span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 23</span> <span style="color: #008000; "></span><span style="color: #000000; ">        InputStream is </span><span style="color: #000000; ">=</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">null</span><span style="color: #000000; ">;<br /> </span><span style="color: #008080; "> 24</span> <span style="color: #000000; ">        </span><span style="color: #0000FF; ">try</span><span style="color: #000000; "> {<br /> </span><span style="color: #008080; "> 25</span> <span style="color: #000000; ">            is </span><span style="color: #000000; ">=</span><span style="color: #000000; "> JDBConnection.</span><span style="color: #0000FF; ">class</span><span style="color: #000000; ">.getClassLoader().getResourceAsStream(<br /> </span><span style="color: #008080; "> 26</span> <span style="color: #000000; ">                    propertyFileName);</span><span style="color: #008000; ">//</span><span style="color: #008000; "> 属性文件输入流<br /> </span><span style="color: #008080; "> 27</span> <span style="color: #008000; ">            </span><span style="color: #008000; ">//</span><span style="color: #008000; "> is = new FileInputStream("src/" + propertyFileName);</span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 28</span> <span style="color: #008000; "></span><span style="color: #000000; ">            prop.load(is);</span><span style="color: #008000; ">//</span><span style="color: #008000; "> 属性文件流装蝲到Properties对象?/span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 29</span> <span style="color: #008000; "></span><span style="color: #000000; ">            is.close();</span><span style="color: #008000; ">//</span><span style="color: #008000; "> 关闭?/span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 30</span> <span style="color: #008000; "></span><span style="color: #000000; ">            dbClassName </span><span style="color: #000000; ">=</span><span style="color: #000000; "> prop.getProperty(</span><span style="color: #000000; ">"</span><span style="color: #000000; ">dbClassName</span><span style="color: #000000; ">"</span><span style="color: #000000; ">);<br /> </span><span style="color: #008080; "> 31</span> <span style="color: #000000; ">            dbUrl </span><span style="color: #000000; ">=</span><span style="color: #000000; "> prop.getProperty(</span><span style="color: #000000; ">"</span><span style="color: #000000; ">dbUrl</span><span style="color: #000000; ">"</span><span style="color: #000000; ">);<br /> </span><span style="color: #008080; "> 32</span> <span style="color: #000000; ">            dbUser </span><span style="color: #000000; ">=</span><span style="color: #000000; "> prop.getProperty(</span><span style="color: #000000; ">"</span><span style="color: #000000; ">dbUser</span><span style="color: #000000; ">"</span><span style="color: #000000; ">);<br /> </span><span style="color: #008080; "> 33</span> <span style="color: #000000; ">            dbPwd </span><span style="color: #000000; ">=</span><span style="color: #000000; "> prop.getProperty(</span><span style="color: #000000; ">"</span><span style="color: #000000; ">dbPwd</span><span style="color: #000000; ">"</span><span style="color: #000000; ">);<br /> </span><span style="color: #008080; "> 34</span> <span style="color: #000000; ">        } </span><span style="color: #0000FF; ">catch</span><span style="color: #000000; "> (Exception e) {<br /> </span><span style="color: #008080; "> 35</span> <span style="color: #000000; ">            System.out.println(</span><span style="color: #000000; ">"</span><span style="color: #000000; ">属性文?nbsp; </span><span style="color: #000000; ">"</span><span style="color: #000000; "> </span><span style="color: #000000; ">+</span><span style="color: #000000; "> propertyFileName </span><span style="color: #000000; ">+</span><span style="color: #000000; "> </span><span style="color: #000000; ">"</span><span style="color: #000000; "> 打开p|Q?/span><span style="color: #000000; ">"</span><span style="color: #000000; ">);<br /> </span><span style="color: #008080; "> 36</span> <span style="color: #000000; ">        }<br /> </span><span style="color: #008080; "> 37</span> <span style="color: #000000; ">        </span><span style="color: #0000FF; ">try</span><span style="color: #000000; "> {<br /> </span><span style="color: #008080; "> 38</span> <span style="color: #000000; "><br /> </span><span style="color: #008080; "> 39</span> <span style="color: #000000; ">            Class.forName(dbClassName);</span><span style="color: #008000; ">//</span><span style="color: #008000; "> 1.注册驱动</span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 40</span> <span style="color: #008000; "></span><span style="color: #000000; ">        } </span><span style="color: #0000FF; ">catch</span><span style="color: #000000; "> (ClassNotFoundException e) {<br /> </span><span style="color: #008080; "> 41</span> <span style="color: #000000; ">            e.printStackTrace();<br /> </span><span style="color: #008080; "> 42</span> <span style="color: #000000; ">        }<br /> </span><span style="color: #008080; "> 43</span> <span style="color: #000000; ">    }<br /> </span><span style="color: #008080; "> 44</span> <span style="color: #000000; "><br /> </span><span style="color: #008080; "> 45</span> <span style="color: #000000; ">    </span><span style="color: #0000FF; ">public</span><span style="color: #000000; "> JDBConnection() {</span><span style="color: #008000; ">//</span><span style="color: #008000; "> 默认的不带参数的构造函?/span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 46</span> <span style="color: #008000; "></span><span style="color: #000000; ">        </span><span style="color: #0000FF; ">try</span><span style="color: #000000; "> {<br /> </span><span style="color: #008080; "> 47</span> <span style="color: #000000; "><br /> </span><span style="color: #008080; "> 48</span> <span style="color: #000000; ">            Class.forName(dbClassName);</span><span style="color: #008000; ">//</span><span style="color: #008000; "> 1.注册驱动</span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 49</span> <span style="color: #008000; "></span><span style="color: #000000; ">        } </span><span style="color: #0000FF; ">catch</span><span style="color: #000000; "> (ClassNotFoundException e) {<br /> </span><span style="color: #008080; "> 50</span> <span style="color: #000000; ">            e.printStackTrace();<br /> </span><span style="color: #008080; "> 51</span> <span style="color: #000000; ">        }<br /> </span><span style="color: #008080; "> 52</span> <span style="color: #000000; ">    }<br /> </span><span style="color: #008080; "> 53</span> <span style="color: #000000; "><br /> </span><span style="color: #008080; "> 54</span> <span style="color: #000000; ">    </span><span style="color: #0000FF; ">public</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">static</span><span style="color: #000000; "> Connection getConnection() {<br /> </span><span style="color: #008080; "> 55</span> <span style="color: #000000; ">        Connection conn </span><span style="color: #000000; ">=</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">null</span><span style="color: #000000; ">;<br /> </span><span style="color: #008080; "> 56</span> <span style="color: #000000; ">        </span><span style="color: #0000FF; ">try</span><span style="color: #000000; "> {<br /> </span><span style="color: #008080; "> 57</span> <span style="color: #000000; ">            </span><span style="color: #008000; ">//</span><span style="color: #008000; "> Class.forName(dbClassName);</span><span style="color: #008000; ">//</span><span style="color: #008000; "> 1.注册驱动</span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 58</span> <span style="color: #008000; "></span><span style="color: #000000; ">            conn </span><span style="color: #000000; ">=</span><span style="color: #000000; "> DriverManager.getConnection(dbUrl, dbUser, dbPwd);</span><span style="color: #008000; ">//</span><span style="color: #008000; ">2.建立与数据库的链?/span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 59</span> <span style="color: #008000; "></span><span style="color: #000000; ">        } </span><span style="color: #0000FF; ">catch</span><span style="color: #000000; "> (Exception ee) {<br /> </span><span style="color: #008080; "> 60</span> <span style="color: #000000; ">            ee.printStackTrace();<br /> </span><span style="color: #008080; "> 61</span> <span style="color: #000000; ">        }<br /> </span><span style="color: #008080; "> 62</span> <span style="color: #000000; ">        </span><span style="color: #0000FF; ">if</span><span style="color: #000000; "> (conn </span><span style="color: #000000; ">==</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">null</span><span style="color: #000000; ">) {<br /> </span><span style="color: #008080; "> 63</span> <span style="color: #000000; ">            System.err<br /> </span><span style="color: #008080; "> 64</span> <span style="color: #000000; ">                    .println(</span><span style="color: #000000; ">"</span><span style="color: #000000; ">警告: DbConnectionManager.getConnection() 获得数据库链接失?\r\n\r\n链接cd:</span><span style="color: #000000; ">"</span><span style="color: #000000; "><br /> </span><span style="color: #008080; "> 65</span> <span style="color: #000000; ">                            </span><span style="color: #000000; ">+</span><span style="color: #000000; "> dbClassName<br /> </span><span style="color: #008080; "> 66</span> <span style="color: #000000; ">                            </span><span style="color: #000000; ">+</span><span style="color: #000000; "> </span><span style="color: #000000; ">"</span><span style="color: #000000; ">\r\n链接位置:</span><span style="color: #000000; ">"</span><span style="color: #000000; "><br /> </span><span style="color: #008080; "> 67</span> <span style="color: #000000; ">                            </span><span style="color: #000000; ">+</span><span style="color: #000000; "> dbUrl<br /> </span><span style="color: #008080; "> 68</span> <span style="color: #000000; ">                            </span><span style="color: #000000; ">+</span><span style="color: #000000; "> </span><span style="color: #000000; ">"</span><span style="color: #000000; ">\r\n用户/密码</span><span style="color: #000000; ">"</span><span style="color: #000000; "><br /> </span><span style="color: #008080; "> 69</span> <span style="color: #000000; ">                            </span><span style="color: #000000; ">+</span><span style="color: #000000; "> dbUser </span><span style="color: #000000; ">+</span><span style="color: #000000; "> </span><span style="color: #000000; ">"</span><span style="color: #000000; ">/</span><span style="color: #000000; ">"</span><span style="color: #000000; "> </span><span style="color: #000000; ">+</span><span style="color: #000000; "> dbPwd);<br /> </span><span style="color: #008080; "> 70</span> <span style="color: #000000; ">        }<br /> </span><span style="color: #008080; "> 71</span> <span style="color: #000000; ">        </span><span style="color: #0000FF; ">return</span><span style="color: #000000; "> conn;<br /> </span><span style="color: #008080; "> 72</span> <span style="color: #000000; ">    }<br /> </span><span style="color: #008080; "> 73</span> <span style="color: #000000; "><br /> </span><span style="color: #008080; "> 74</span> <span style="color: #000000; ">    </span><span style="color: #008000; ">/*</span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 75</span> <span style="color: #008000; ">     * 功能Q执行查询语?br /> </span><span style="color: #008080; "> 76</span> <span style="color: #008000; ">     </span><span style="color: #008000; ">*/</span><span style="color: #000000; "><br /> </span><span style="color: #008080; "> 77</span> <span style="color: #000000; ">    </span><span style="color: #0000FF; ">public</span><span style="color: #000000; "> ResultSet executeQuery(String sql) {<br /> </span><span style="color: #008080; "> 78</span> <span style="color: #000000; ">        </span><span style="color: #0000FF; ">try</span><span style="color: #000000; "> { </span><span style="color: #008000; ">//</span><span style="color: #008000; "> 捕捉异常</span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 79</span> <span style="color: #008000; "></span><span style="color: #000000; ">            conn </span><span style="color: #000000; ">=</span><span style="color: #000000; "> getConnection(); </span><span style="color: #008000; ">//</span><span style="color: #008000; "> 调用getConnection()Ҏ(gu)构造Connection对象的一个实例conn</span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 80</span> <span style="color: #008000; "></span><span style="color: #000000; ">            stmt </span><span style="color: #000000; ">=</span><span style="color: #000000; "> conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,</span><span style="color: #008000; ">//</span><span style="color: #008000; ">3.创徏语句</span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 81</span> <span style="color: #008000; "></span><span style="color: #000000; ">                    ResultSet.CONCUR_READ_ONLY);<br /> </span><span style="color: #008080; "> 82</span> <span style="color: #000000; ">            rs </span><span style="color: #000000; ">=</span><span style="color: #000000; "> stmt.executeQuery(sql);</span><span style="color: #008000; ">//</span><span style="color: #008000; ">4.执行查询</span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 83</span> <span style="color: #008000; "></span><span style="color: #000000; ">        } </span><span style="color: #0000FF; ">catch</span><span style="color: #000000; "> (SQLException ex) {<br /> </span><span style="color: #008080; "> 84</span> <span style="color: #000000; ">            System.err.println(ex.getMessage()); </span><span style="color: #008000; ">//</span><span style="color: #008000; "> 输出异常信息</span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 85</span> <span style="color: #008000; "></span><span style="color: #000000; ">        }<br /> </span><span style="color: #008080; "> 86</span> <span style="color: #000000; ">        </span><span style="color: #0000FF; ">return</span><span style="color: #000000; "> rs; </span><span style="color: #008000; ">//</span><span style="color: #008000; "> q回l果集对?nbsp;5.l果处理</span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 87</span> <span style="color: #008000; "></span><span style="color: #000000; ">    }<br /> </span><span style="color: #008080; "> 88</span> <span style="color: #000000; "><br /> </span><span style="color: #008080; "> 89</span> <span style="color: #000000; ">    </span><span style="color: #008000; ">/*</span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 90</span> <span style="color: #008000; ">     * 功能:执行更新操作<br /> </span><span style="color: #008080; "> 91</span> <span style="color: #008000; ">     </span><span style="color: #008000; ">*/</span><span style="color: #000000; "><br /> </span><span style="color: #008080; "> 92</span> <span style="color: #000000; ">    </span><span style="color: #0000FF; ">public</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">int</span><span style="color: #000000; "> executeUpdate(String sql) {<br /> </span><span style="color: #008080; "> 93</span> <span style="color: #000000; ">        </span><span style="color: #0000FF; ">int</span><span style="color: #000000; "> result </span><span style="color: #000000; ">=</span><span style="color: #000000; "> </span><span style="color: #000000; ">0</span><span style="color: #000000; ">; </span><span style="color: #008000; ">//</span><span style="color: #008000; "> 定义保存q回值的变量</span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 94</span> <span style="color: #008000; "></span><span style="color: #000000; ">        </span><span style="color: #0000FF; ">try</span><span style="color: #000000; "> { </span><span style="color: #008000; ">//</span><span style="color: #008000; "> 捕捉异常</span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 95</span> <span style="color: #008000; "></span><span style="color: #000000; ">            conn </span><span style="color: #000000; ">=</span><span style="color: #000000; "> getConnection(); </span><span style="color: #008000; ">//</span><span style="color: #008000; "> 调用getConnection()Ҏ(gu)构造Connection对象的一个实例conn</span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 96</span> <span style="color: #008000; "></span><span style="color: #000000; ">            stmt </span><span style="color: #000000; ">=</span><span style="color: #000000; "> conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,<br /> </span><span style="color: #008080; "> 97</span> <span style="color: #000000; ">                    ResultSet.CONCUR_READ_ONLY);<br /> </span><span style="color: #008080; "> 98</span> <span style="color: #000000; ">            result </span><span style="color: #000000; ">=</span><span style="color: #000000; "> stmt.executeUpdate(sql); </span><span style="color: #008000; ">//</span><span style="color: #008000; "> 执行更新操作</span><span style="color: #008000; "><br /> </span><span style="color: #008080; "> 99</span> <span style="color: #008000; "></span><span style="color: #000000; ">        } </span><span style="color: #0000FF; ">catch</span><span style="color: #000000; "> (SQLException ex) {<br /> </span><span style="color: #008080; ">100</span> <span style="color: #000000; ">            result </span><span style="color: #000000; ">=</span><span style="color: #000000; "> </span><span style="color: #000000; ">0</span><span style="color: #000000; ">; </span><span style="color: #008000; ">//</span><span style="color: #008000; "> 保存返回值的变量赋gؓ(f)0</span><span style="color: #008000; "><br /> </span><span style="color: #008080; ">101</span> <span style="color: #008000; "></span><span style="color: #000000; ">        }<br /> </span><span style="color: #008080; ">102</span> <span style="color: #000000; ">        </span><span style="color: #0000FF; ">return</span><span style="color: #000000; "> result; </span><span style="color: #008000; ">//</span><span style="color: #008000; "> q回保存q回值的变量</span><span style="color: #008000; "><br /> </span><span style="color: #008080; ">103</span> <span style="color: #008000; "></span><span style="color: #000000; ">    }<br /> </span><span style="color: #008080; ">104</span> <span style="color: #000000; "><br /> </span><span style="color: #008080; ">105</span> <span style="color: #000000; ">    </span><span style="color: #008000; ">/*</span><span style="color: #008000; "><br /> </span><span style="color: #008080; ">106</span> <span style="color: #008000; ">     * 功能:关闭数据库的q接<br /> </span><span style="color: #008080; ">107</span> <span style="color: #008000; ">     </span><span style="color: #008000; ">*/</span><span style="color: #000000; "><br /> </span><span style="color: #008080; ">108</span> <span style="color: #000000; ">    </span><span style="color: #0000FF; ">public</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">void</span><span style="color: #000000; "> close() {</span><span style="color: #008000; ">//</span><span style="color: #008000; ">6.释放资源</span><span style="color: #008000; "><br /> </span><span style="color: #008080; ">109</span> <span style="color: #008000; "></span><span style="color: #000000; ">        </span><span style="color: #0000FF; ">try</span><span style="color: #000000; "> { </span><span style="color: #008000; ">//</span><span style="color: #008000; "> 捕捉异常</span><span style="color: #008000; "><br /> </span><span style="color: #008080; ">110</span> <span style="color: #008000; "></span><span style="color: #000000; ">            </span><span style="color: #0000FF; ">try</span><span style="color: #000000; "> {<br /> </span><span style="color: #008080; ">111</span> <span style="color: #000000; ">                </span><span style="color: #0000FF; ">if</span><span style="color: #000000; "> (rs </span><span style="color: #000000; ">!=</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">null</span><span style="color: #000000; ">) { </span><span style="color: #008000; ">//</span><span style="color: #008000; "> 当ResultSet对象的实例rs不ؓ(f)I时</span><span style="color: #008000; "><br /> </span><span style="color: #008080; ">112</span> <span style="color: #008000; "></span><span style="color: #000000; ">                    rs.close(); </span><span style="color: #008000; ">//</span><span style="color: #008000; "> 关闭ResultSet对象</span><span style="color: #008000; "><br /> </span><span style="color: #008080; ">113</span> <span style="color: #008000; "></span><span style="color: #000000; ">                }<br /> </span><span style="color: #008080; ">114</span> <span style="color: #000000; ">            } </span><span style="color: #0000FF; ">finally</span><span style="color: #000000; "> {<br /> </span><span style="color: #008080; ">115</span> <span style="color: #000000; ">                </span><span style="color: #0000FF; ">try</span><span style="color: #000000; "> {<br /> </span><span style="color: #008080; ">116</span> <span style="color: #000000; ">                    </span><span style="color: #0000FF; ">if</span><span style="color: #000000; "> (stmt </span><span style="color: #000000; ">!=</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">null</span><span style="color: #000000; ">) { </span><span style="color: #008000; ">//</span><span style="color: #008000; "> 当Statement对象的实例stmt不ؓ(f)I时</span><span style="color: #008000; "><br /> </span><span style="color: #008080; ">117</span> <span style="color: #008000; "></span><span style="color: #000000; ">                        stmt.close(); </span><span style="color: #008000; ">//</span><span style="color: #008000; "> 关闭Statement对象</span><span style="color: #008000; "><br /> </span><span style="color: #008080; ">118</span> <span style="color: #008000; "></span><span style="color: #000000; ">                    }<br /> </span><span style="color: #008080; ">119</span> <span style="color: #000000; ">                } </span><span style="color: #0000FF; ">finally</span><span style="color: #000000; "> {<br /> </span><span style="color: #008080; ">120</span> <span style="color: #000000; ">                    </span><span style="color: #0000FF; ">if</span><span style="color: #000000; "> (conn </span><span style="color: #000000; ">!=</span><span style="color: #000000; "> </span><span style="color: #0000FF; ">null</span><span style="color: #000000; ">) { </span><span style="color: #008000; ">//</span><span style="color: #008000; "> 当Connection对象的实例conn不ؓ(f)I时</span><span style="color: #008000; "><br /> </span><span style="color: #008080; ">121</span> <span style="color: #008000; "></span><span style="color: #000000; ">                        conn.close(); </span><span style="color: #008000; ">//</span><span style="color: #008000; "> 关闭Connection对象</span><span style="color: #008000; "><br /> </span><span style="color: #008080; ">122</span> <span style="color: #008000; "></span><span style="color: #000000; ">                    }<br /> </span><span style="color: #008080; ">123</span> <span style="color: #000000; ">                }<br /> </span><span style="color: #008080; ">124</span> <span style="color: #000000; ">            }<br /> </span><span style="color: #008080; ">125</span> <span style="color: #000000; ">        } </span><span style="color: #0000FF; ">catch</span><span style="color: #000000; "> (Exception e) {<br /> </span><span style="color: #008080; ">126</span> <span style="color: #000000; ">            e.printStackTrace(System.err); </span><span style="color: #008000; ">//</span><span style="color: #008000; "> 输出异常信息</span><span style="color: #008000; "><br /> </span><span style="color: #008080; ">127</span> <span style="color: #008000; "></span><span style="color: #000000; ">        }<br /> </span><span style="color: #008080; ">128</span> <span style="color: #000000; ">    }<br /> </span><span style="color: #008080; ">129</span> <span style="color: #000000; "><br /> </span><span style="color: #008080; ">130</span> <span style="color: #000000; ">}<br /> </span><span style="color: #008080; ">131</span> <span style="color: #000000; "><br /> </span><span style="color: #008080; ">132</span> <span style="color: #000000; "></span><span style="color: #008000; ">/*</span><span style="color: #008000; "><br /> </span><span style="color: #008080; ">133</span> <span style="color: #008000; "> *属性文?br /> </span><span style="color: #008080; ">134</span> <span style="color: #008000; ">dbClassName=com.microsoft.jdbc.sqlserver.SQLServerDriver<br /> </span><span style="color: #008080; ">135</span> <span style="color: #008000; ">dbClassName2=com.mysql.jdbc.Driver<br /> </span><span style="color: #008080; ">136</span> <span style="color: #008000; ">dbPwd=sa<br /> </span><span style="color: #008080; ">137</span> <span style="color: #008000; ">dbPwd2=root<br /> </span><span style="color: #008080; ">138</span> <span style="color: #008000; ">dbUrl=jdbc\:microsoft\:sqlserver\://localhost\:1433;DatabaseName\=DB_ATM<br /> </span><span style="color: #008080; ">139</span> <span style="color: #008000; ">dbUrl2=jdbc\:mysql\://localhost\:3306/db_atm<br /> </span><span style="color: #008080; ">140</span> <span style="color: #008000; ">dbUser=sa<br /> </span><span style="color: #008080; ">141</span> <span style="color: #008000; ">dbUser2=root<br /> </span><span style="color: #008080; ">142</span> <span style="color: #008000; "> *</span><span style="color: #008000; ">*/</span></div> <img src ="http://www.aygfsteel.com/BlogJava522935502/aggbug/354025.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.aygfsteel.com/BlogJava522935502/" target="_blank">吕鹏-Roc</a> 2011-07-10 10:06 <a href="http://www.aygfsteel.com/BlogJava522935502/articles/354025.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>javadxml文ghttp://www.aygfsteel.com/BlogJava522935502/articles/354024.html吕鹏-Roc吕鹏-RocSun, 10 Jul 2011 02:03:00 GMThttp://www.aygfsteel.com/BlogJava522935502/articles/354024.htmlhttp://www.aygfsteel.com/BlogJava522935502/comments/354024.htmlhttp://www.aygfsteel.com/BlogJava522935502/articles/354024.html#Feedback0http://www.aygfsteel.com/BlogJava522935502/comments/commentRss/354024.htmlhttp://www.aygfsteel.com/BlogJava522935502/services/trackbacks/354024.html
package cn.zbvc.java;
import java.io.*;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;

/*
 *java讉Kxml文g
 *
*/

public class xmljava


public static void main(String args[])
    {    
          Element element
=null;
          File f 
=new File("a.xml");
          DocumentBuilder db
=null;        //documentBuilder为抽象不能直接实例化(XML文g转换为DOM文g)
          DocumentBuilderFactory dbf=null
      
try{
         
          dbf
= DocumentBuilderFactory.newInstance(); //q回documentBuilderFactory对象   
          db =dbf.newDocumentBuilder();//q回db对象用documentBuilderFatory对象获得q回documentBuildr对象

          Document dt
= db.parse(f); //得到一个DOMq返回给document对象
          element = dt.getDocumentElement();//得到一个elment根元?/span>
          
          System.out.println(
"根元素:(x)"+element.getNodeName()); //获得根节?/span>

        NodeList childNodes 
=element.getChildNodes() ;    // 获得根元素下的子节点
    
      
for (int i = 0; i < childNodes.getLength(); i++)     // 遍历q些子节?/span>

   {       
       Node node1 
= childNodes.item(i); // childNodes.item(i); 获得每个对应位置i的结?/span>

     
if ("Account".equals(node1.getNodeName())) 
      { 
                        
// 如果节点的名UCؓ(f)"Account"Q则输出Account元素属性type
      System.out.println("\r\n扑ֈ一̎? 所属区? "   + node1.getAttributes().getNamedItem        ("type").getNodeValue() + "");
      NodeList nodeDetail 
= node1.getChildNodes();   // 获得<Accounts>下的节点
      for (int j = 0; j < nodeDetail.getLength(); j++)
       {   
// 遍历<Accounts>下的节点
          Node detail = nodeDetail.item(j);    // 获得<Accounts>元素每一个节?/span>
            if ("code".equals(detail.getNodeName()))   // 输出code
            System.out.println("卡号: " + detail.getTextContent());
             
else if ("pass".equals(detail.getNodeName())) // 输出pass
                System.out.println("密码: " + detail.getTextContent());
             
else if ("name".equals(detail.getNodeName())) // 输出name
                System.out.println("姓名: " + detail.getTextContent());
             
else if ("money".equals(detail.getNodeName())) // 输出money
                 System.out.println("余额: "+ detail.getTextContent());
      
        }
      }

    }
}

catch(Exception e){System.out.println(e);}
    
}
}

/**
 *XML文g
 
 <?xml version="1.0" encoding="gbk"?>      
<Accounts>
<Account type="by0003"> 
<code>100001</code>
<pass>123</pass>
<name>李四</name> 
<money>1000000.00</money> 
</Account> 
<Account type="hz0001"> 
<code>100002</code>
<pass>123</pass>
<name>张三</name> 
<money>1000.00</money> 
</Account> 
</Accounts>
 
 
 
 
 
 
*/


吕鹏-Roc 2011-07-10 10:03 发表评论
]]>
Struts2.2+Hibernate3.3+Spring2.5.6整合 一个简单的CRUD案例http://www.aygfsteel.com/BlogJava522935502/articles/JavaBlog522935502.html吕鹏-Roc吕鹏-RocSun, 10 Jul 2011 01:50:00 GMThttp://www.aygfsteel.com/BlogJava522935502/articles/JavaBlog522935502.htmlhttp://www.aygfsteel.com/BlogJava522935502/comments/354021.htmlhttp://www.aygfsteel.com/BlogJava522935502/articles/JavaBlog522935502.html#Feedback8http://www.aygfsteel.com/BlogJava522935502/comments/commentRss/354021.htmlhttp://www.aygfsteel.com/BlogJava522935502/services/trackbacks/354021.html阅读全文

吕鹏-Roc 2011-07-10 09:50 发表评论
]]>
վ֩ģ壺 | Ž| ϻ| | Ұ| | | | ƽ| İ| ѷ| | | | ˫| | º| Т| | | | | | ͬ| Ϫ| ɽ| Դ| Ҧ| | | | ʱ| Ϫ| | | ɽ| | ױ| ͺ| | ɳ|