import java.sql.*;
import java.util.*;
import java.util.Date;
public class DatabaseManupulate {
public static void main(String[] args) throws ClassNotFoundException
{
databaseConnection();
}
public static void forEachIterator(List<Emp> list)
{
Iterator<Emp> i = list.iterator();
while (i.hasNext())
{
Emp e = i.next();
System.out.println("Empno "+"Ename "+"Job "+"Mgr "+"HireDate "+"Sal "+"Comm "+"Deptno");
System.out.println(e.getEmpno()+" "+e.getEname()+" "+e.getJob()+" "+e.getMgr()+" "+e.getHireDate()+" "+e.getSal()+" "+e.getComm()+" "+e.getDeptno());
}
}
public static void forEachAdvFor(List<Emp> list)
{
for(Emp e : list)
{
System.out.println(e.toString());
}
}
public static void databaseConnection() throws ClassNotFoundException {
//成员变量声明在try catch外面为了在finally中释放资源
Connection conn = null;
Statement s = null;
ResultSet result = null;
String sqlDeptAll = null;
List<Emp> list = null;
try
{
//1.注册驱动
Class.forName("oracle.jdbc.OracleDriver");
//2.获取驱动对象
conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.10.150:1521:orcl11g","scott","scott");
System.out.println(conn);
//获取进行的sql
s = conn.createStatement();
//定义进行sql的内容
sqlDeptAll = "select * from scott.emp";
//获得结果集
result = s.executeQuery(sqlDeptAll);
ResultSetMetaData rsmd = result.getMetaData();
//遍历结果集,封装对象
list = new ArrayList<Emp>();
while (result.next())
{
int empno = result.getInt(1);
String ename = result.getString(2);
String job