JDBC简单查询实例

 

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

import com.neusoft.java275.dao.DBUtil;

public class StudentManager
{
    public static void main(String[] args)
    {
        StudentManager manager=new StudentManager();
        List<StudentVO> resultList=manager.queryStudentList();
        for(StudentVO student:resultList)
        {
            System.out.println(student.getId()+","+student.getName());
        }
    }
    public List<StudentVO> queryStudentList()
    {
        List<StudentVO> resultList=new ArrayList<StudentVO>();
        Connection con = null;
        Statement stmt = null;
        ResultSet rs = null;
        try
        {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.137.23:1521:orcl", "java", "java");
            stmt = con.createStatement();
            rs = stmt.executeQuery("SELECT id,name FROM student order by id asc");
            StudentVO studentVO=null;
            while (rs.next())
            {
                studentVO=new StudentVO();
                studentVO.setId(rs.getString("id"));
                studentVO.setName(rs.getString("name"));
                resultList.add(studentVO);
            }
        }
        catch (ClassNotFoundException e)
        {
            e.printStackTrace();
        }
        catch (SQLException e)
        {
            e.printStackTrace();
        }
        finally
        {
            DBUtil.closeQuietly(rs);
            DBUtil.closeQuietly(stmt);
            DBUtil.closeQuietly(con);
        }
        return resultList;
    }
}