java链接oracle数据库

package csu.lys.com;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Hashtable;

import javax.sql.StatementEvent;

public class ConnOracle {

    /**
     * @param args
     */
    public static void main(String[] args) {
        // TODO Auto-generated method stub
        //加载驱动
        String oracleDriverString = "oracle.jdbc.driver.OracleDriver";
        Hashtable<String, User> ht = new Hashtable<String, User>();
        try {
            //加载驱动
            Class.forName(oracleDriverString);
            //得到链接
            Connection ct = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:ORCLLYS", "SCOTT", "TIGER");
            //创建statement
            Statement statement = ct.createStatement();
            //查询
            ResultSet resultSet = statement.executeQuery("select * from users");
            
            if(resultSet.next()){
                int id = resultSet.getInt(1);
                String name = resultSet.getString(2);
                String passwd = resultSet.getString(3);
                User user = new User(id, name, passwd);
                ht.put("lys", user);
            }
            
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        System.out.println(ht.get("lys").toString());

    }

}