ʹÓÃdom4j¶ÁÈ¡xmlÎļþ
Ê×ÏȽ«dom4j-1.6.1.jar,jaxen-1.1.1.jarÁ½¸öjar°üµ¼Èëµ½ÏîÄ¿ÖÐ
reader_config.xml
<?xml version="1.0" encoding="UTF-8"?>
<config>
<db-info>
<driver-name>oracle.jdbc.driver.OracleDriver</driver-name>
<url>jdbc:oracle:thin:@192.168.1.100:1521:orcl</url>
<username>dys</username>
<password>dys</password>
</db-info>
</config>
ConfigReader.java
package com.deng.dys.util;
import org.dom4j.Document;
import org.dom4j.Element;
import org.dom4j.io.SAXReader;
public class ConfigReader {
private JdbcInfo jdbcInfo ;
// ¾²Ì¬µÄ˽ÓеijÉÔ±±äÁ¿
private static ConfigReader configReader = new ConfigReader();
// ²»ÔÊÐí±ðÈË·ÃÎÊ
private ConfigReader() {
try {
Document document = new SAXReader().read(Thread.currentThread()
.getContextClassLoader().getResourceAsStream(
"reader_config.xml"));
Element driverName = (Element)document.selectObject("/config/db-info/driver-name");
Element url = (Element)document.selectObject("/config/db-info/url");
Element username = (Element)document.selectObject("/config/db-info/username");
Element password = (Element)document.selectObject("/config/db-info/password");
jdbcInfo = new JdbcInfo();
jdbcInfo.setDriverName(driverName.getStringValue());
jdbcInfo.setPassword(password.getStringValue());
jdbcInfo.setUrl(url.getStringValue());
jdbcInfo.setUsername(username.getStringValue());
} catch (Exception e) {
e.printStackTrace();
}
}
// ¹«¹²µÄ¾²Ì¬µÄÈë¿Úµã·½·¨
public static ConfigReader getInstance() {
return configReader;
}
public JdbcInfo getJdbcInfo(){
return jdbcInfo;
}
//main method
public static void main(String args[]){
ConfigReader.getInstance().getJdbcInfo();
}
}
½«xmlµÄÐÅÏ¢·â×°ÔÚÒ»¸öÀàÖÐ
JdbcInfo.java
package com.deng.drp.util;
public class JdbcInfo {
private String driverName;
private String url;
private String usern
Ïà¹ØÎĵµ£º
Ó¦ÓÃJSP£¬XMLºÍCSS¼¼ÊõʵÏÖµ¯³öʽ²Ëµ¥µÄ¹¤³Ì¿ò¼Ü¡£
×ۺϲÉÓÃJSP£¬JavaBean£¬XML£¬XSL£¬CSS£¬JavaScript¶àÏî¼¼ÊõµÄÓŵ㡣
ÔÚJSPÖÐʹÓÃXMLÎĵµ£¬XML¶¨ÒåÊý¾Ý¸ñʽ£¬ÔÚJSPÖÐÖ±½ÓÉú³ÉXMLÎļþ£¬ËüÓëJavaBean½»»¥£¬JavaBean¸ºÔð¶ÁÈ¡´æ´¢²Ëµ¥ÏîµÄÎļþ¡£
XSLʵÏÖXMLµ½HTMLµÄת»¯£¬CSSÎļþ¸ºÔðÑùʽµ¥µÄ¶¨Ò壬¶øJavaS ......
sql2005ÖÐÒ»¸öxml¾ÛºÏµÄÀý×Ó ÊÕ²Ø
¸ÃÎÊÌâÀ´×ÔÂÛ̳ÌáÎÊ£¬ÑÝʾSQL´úÂëÈçÏÂ
--½¨Á¢²âÊÔ»·¾³
set nocount on
create table test(ID varchar(20),NAME varchar(20))
insert into test select '1','aaa'
insert into test select '1','bbb'
insert into test select '1','ccc'
insert into test select '2','ddd'
inser ......
ÔÚXMLÊý¾ÝÖУ¬Ò»Ð©ÌØÊâ×Ö·û±ØÐëÓÃתÒå·ûºÅÀ´´úÌ棬¶ø»Ø³µ»»ÐÐ×Ö·û¾ÍÊÇÊôÓÚÌØÊâ·ûºÅ¡£
¿Õ¸ñ ( )
Tab (	)
»Ø³µ (
)
»»ÐÐ (
)
ÏÂÃæÊÇÒ»¸ö±¨±íXMLÊý¾Ý£¬ÀïÃæ°üÀ¨Óлسµ»»ÐÐ×Ö·û£º
<report>
<NewDataSet>
<Table>
<CustomerID>BLONP</CustomerID& ......
WebService£¬¼òµ¥Ò»µã˵£¬¾ÍÊǸö¶ÔÍâµÄ½Ó¿Ú,ÀïÃæÓк¯Êý¿É¹©Íⲿ¿Í»§µ÷ÓÃ(×¢Òâ:ÀïÃæͬÑùÓпͻ§²»¿Éµ÷Óõĺ¯Êý).¼ÙÈôÎÒÃÇÊÇ·þÎñ¶Ë,ÎÒÃÇдºÃÁ˸öwebservice,È»ºó°ÑËü¸øÁË¿Í»§(ͬʱÎÒÃǸøÁËËûÃǵ÷ÓùæÔò),¿Í»§¾Í¿ÉÒÔÔÚ´Ó·þÎñ¶Ë»ñÈ¡ÐÅϢʱ´¦ÓÚÒ»¸öÏà¶Ô͸Ã÷µÄ״̬.¼´ÊÇ¿Í»§²»Á˽â(Ò²²»ÐèÒª)Æä¹ý³Ì,ËûÃÇÖ»»ñÈ¡Êý¾Ý. Webservice´«µ ......
public string GetPage(int page, int pages, string url)
{
if (pages == 0)
{
&n ......