jdbc

jdbc连接数据库

import java.sql.*;
public class TestJDBC {
    Connection conn;
    Statement st;
    ResultSet rs;
    public TestJDBC(){
        try {
            //1.加载驱动
            Class.forName("oracle.jdbc.driver.OracleDriver");
            //2.获得连接
            conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl", "scott", "tiger");
            //3.发送SQL语句
            st = conn.createStatement();
            rs = st.executeQuery("select * from emp");
            //4.处理结果集
            while(rs.next()){
                int no = rs.getInt("empno");
                String name = rs.getString("ename");
                String job = rs.getString("job");
                int mgr = rs.getInt("mgr");
                String hiredate = rs.getString("hiredate");
                double sal = rs.getDouble("sal");
                double comm = rs.getDouble("comm");
                int deptno = rs.getInt("deptno");
                System.out.println(no+"\t"+name+"\t"+job+"\t\t"+mgr+"\t"+hiredate+"\t"+sal+"\t"+comm+"\t"+deptno);
            }
            //5.关闭资源
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
    public static void main(String[] args) {
        new TestJDBC();
    }
}