?? dataconn.java
字號:
/**
* title:數據庫連接、操作
* desciprion:數據庫連接、操作
* @author:victor
* @version:v1.0
* 2005-10-27
*/
package good;
import java.io.BufferedReader;
import java.io.File;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.net.URL;
import java.sql.*;
import java.util.List;
import org.jdom.Document;
import org.jdom.Element;
import org.jdom.JDOMException;
import org.jdom.adapters.*;
import org.jdom.input.SAXBuilder;
public class DataConn extends DataConfig {
private String JNDI;
private String className;
private String URL;
private String UID;
private String password;
/**
* 構造函數
*
*/
public DataConn() {
super();
//getConnection();
getInitParaFromXml();
}
/**
* 數據庫直連(FOR ORACLE)
*/
public void dataConnDerectForOracle() {
super.derectConnectForOracle(className, URL, UID, password);
}
/**
* 數據庫直連(FOR MYSQL)
*/
public void dataConnDerectForMySql() {
super.derectConnectForMySql(className, URL);
}
/**
* 連接池
*/
public void dataConnPool() {
super.setJNDI(JNDI);
}
/*
* 從xml讀取數據jndi值
*/
public Connection getConnection()
{
try
{
String URL = "jdbc:odbc:myDSN";
Connection c = DriverManager.getConnection(URL, "user", "pwd");
return c;
}
catch(Exception e)
{
e.printStackTrace();
System.exit(0);
}
return null;
}
private void getInitParaFromXml() {
try {
URL parentPath = getClass().getResource("DataConn.class");
String childPath = parentPath.getPath().substring(0,
parentPath.getPath().lastIndexOf('/'))
+ "/DataConfig.xml";
System.out.println(childPath);
File filePath = new File(childPath);
URL path = filePath.toURL();
InputStream in = path.openStream();
// InputStream in = getClass().getResourceAsStream(pathAbsolute);
InputStreamReader fi = new InputStreamReader(in);
BufferedReader bf = new BufferedReader(fi);
SAXBuilder builder = new SAXBuilder();
Document doc = builder.build(bf);
Element root = doc.getRootElement();
List books = root.getChildren();
//JNDI名稱
JNDI = ((Element) books.get(0)).getText().trim();
//驅動名稱
className = ((Element) books.get(1)).getText().trim();
//數據庫地址
URL = ((Element) books.get(2)).getText().trim();
//用戶名
UID = ((Element) books.get(3)).getText().trim();
//密碼
password = ((Element) books.get(4)).getText().trim();
//System.out.println(JNDI);
} catch (NullPointerException e) {
System.out.println("不能找到DataConfig.xml文件");
e.printStackTrace();
} catch (IOException e) {
System.out.println("生成DOC出錯!");
e.printStackTrace();
} catch (Exception e) {
System.out.println("讀取xml出現錯誤!");
e.printStackTrace();
}
}
/**
* main
*
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -