- 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());
- }
- }
- View Code
来源: http://www.bubuko.com/infodetail-3300980.html