Jdbc连Oracle的程序,并实现数据查询

 

数据库服务器的IP：192.168.0.23，数据库名称：sample,

表名：test,字段：id-number(9),name-varchar2(20)

要求：查出所有姓“李”的人。
答案：代码如下：

import java.sql.*;

public class Test

{

       public static void main(String[] args)

       {

              String driver = "oracle.jdbc.driver.OracleDriver";

              String url = "jdbc:oracle:thin:@192.168.0.23:1521: sample ";

              String user = "j0501";

              String password = "j0501";

             

              Connection con = null;

              PreparedStatement ps = null;

              ResultSet rs = null;

              try

              {

                     //如果不行就用Class.forName(driver).newInstance();

                     Class.forName(driver);

                     con = DriverManager.getConnection(url,user,password);

                     ps = con.prepareStatement("select * from test WHERE name like '%李'");

                     rs = ps.executeQuery();

                     Test.dispResult(rs);

              }catch(Exception e)

              {

                     e.printStackTrace();

              }

              finally

              {

                     try

                     {

                            rs.close();

                     }catch(Exception e){}

                     try

                     {

                            ps.close();

                     }catch(Exception e){}

                     try

                     {

                            con.close();

                     }catch(Exception e){}

              }

       }

       //显示结果集

       private static void dispResult(ResultSet rs) throws Exception

       {

              //最处指向第一条记录的前面

              while(rs.next())

              {

                     System.out.print(rs.getString("id")+"    ");

                     System.out.print(rs.getString("name")+"    ");

                     System.out.println();

              }

       }

}