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;    }}