java数据库连接

String PWD = "orcl";
try {
Class.forName(DbDriver);
conn = DriverManager.getConnection(DBURL, DBUser, PWD);
} catch (Exception e) {
System.out.println("数据库连接失败,请验证用户名及密码!");
import java.io.File;
import java.io.FileWriter;
import java.io.Writer;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
* =res.getString("empno");
* lst.add(i, strName + "," + strNo);
*/
// 方法二,
emp = new EmpStruct();
/*
* emp.strName = res.getString("ename"); emp.strNo =
Connection conn = null;
String DbDriver = "oracle.jdbc.driver.OracleDriver";
String DBURL = "jdbc:oracle:thin:@localhost:1521:orcl";
String DBUser = "scott";
EmpStruct emp = null;
try {
// int i = 0;
while (res.next()) {
// 方法一,直接进行存入list数组中,进行存取
/*
* String strName = res.getString("ename"); String strNo
} finally {
conn.setAutoCommit(false);
return conn;
}
}
public List getData() throws Exception {
Connection conn = getConn();
Statement stmt = null;
private String strNo = "";
public String getStrName() {
return strName;
}
public void setStrName(String strName) {
this.strName = strName;
System.out.println("列名有误!请验证!");
// TODO: handle exception
} finall);
return lst;
}
}
public static void main(String[] args) throws Exception {
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
public class MyConn {
class EmpStruct {
private String strName = "";
emp.setStrName(strName);
emp.setStrNo(strNo);
lst.add(emp);
// i++;
}
res.close();
} catch (Exception e) {
// e.printStackTrace();
}
public String getStrNo() {
return strNo;
}
public void setStrNo(String strNo) {
this.strNo = strNo;
}
}
public Connection getConn() throws Exception {
ResultSet res = null;
String SQL = "select empno,ename from emp";
//
stmt = conn.createStatement();
res = stmt.executeQuery(SQL);
List lst = new ArrayList();
/* out.write(emp.strName + "," + emp.strNo + "\r\n"); */
out.write(emp.getStrName() + " " + emp.getStrNo() + "\r\n");
}
out.close();
}
}
// TODO Auto-generated method stub
MyConn conn = new MyConn();
List lst = conn.getData();
File f = new File("d:/" + File.separator + "myName.txt");
* res.getString("empno");
*
* lst.add(emp);
*/
// 方法三,使用get ,set 方法,
String strNo = res.getString("empno");
String strName = res.getString("ename");
Writer out = new FileWriter(f);
for (int i = 0; i < lst.size(); i++) {
// out.write(lst.get(i) + "\r\n");
EmpStruct emp = (EmpStruct) lst.get(i);