JDBC高级查询实例

 

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import com.neusoft.java275.chaper10.Student;

public class FirstJDBC
{
    public static void main(String[] args) throws ClassNotFoundException, SQLException
    {
        Connection con = null;
        //Statement stmt = null;
        PreparedStatement prestmt=null;
        ResultSet rs = null;
        List<Student> list = new ArrayList<Student>();
        try
        {
            Class.forName("oracle.jdbc.driver.OracleDriver");//加载驱动
            con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.137.23:1521:unieap", "scott", "tiger");//连接数据库
            //stmt = con.createStatement(); //操作数据库
            prestmt=con.prepareStatement("select id,name from student where id=?");
            //rs = stmt.executeQuery("select id,name from student where id=1");//执行SQL
            prestmt.setString(1, "2");
            rs =prestmt.executeQuery();
            ResultSetMetaData metaData=rs.getMetaData();
            StringBuilder stringBuilder=new StringBuilder(32);
            for(int i=1;i<=metaData.getColumnCount();i++)
            {
                stringBuilder.append(metaData.getColumnName(i));
                stringBuilder.append(" ");
            }
            System.out.println(stringBuilder.toString());
            while (rs.next())
            {//获取结果
                int id = rs.getInt("id");//get id column
                String name = rs.getString("name");
                Student student = new Student(id, name, null, 0);
                list.add(student);
            }
            for (Student student1 : list)
            {
                System.out.println(student1.getId() + "," + student1.getName());
            }
        }
        catch (ClassNotFoundException e)
        {
            System.out.println("加载驱动Error");
            throw e;
        }
        catch (SQLException e)
        {
            System.out.println("access database error");
            throw e;
        }
        finally
        {
            if (rs != null)
            {
                try
                {
                    rs.close();
                }
                catch (SQLException e)
                {
                    e.printStackTrace();
                }
            }
//            if (stmt != null)
//            {
//                try
//                {
//                    stmt.close();
//                }
//                catch (SQLException e)
//                {
//                    e.printStackTrace();
//                }
//            }
            if (prestmt != null)
            {
                try
                {
                    prestmt.close();
                }
                catch (SQLException e)
                {
                    e.printStackTrace();
                }
            }
            if (con != null)
            {
                try
                {
                    con.close();
                }
                catch (SQLException e)
                {
                    e.printStackTrace();
                }
            }
        }
    }
}