JAVA在JDBC中Statement的具体应用-----JDBC

今天药忘吃喽~ 2024-03-23 19:46 45阅读 0赞

>     package com.powernode.jdbc;
>     
>     import java.sql.*;
>     import java.util.ResourceBundle;
>     import java.util.Scanner;
>     
>     public class JDBCTest01
>     {
>         public static void main(String[] args)
>         {
>             //用户在控制台输入desc就是降序,输入ASC就是升序
>             Scanner in = new Scanner(System.in);
>             System.out.println("请输入ASC或DESC");
>             String order = in.nextLine();
>     
>             ResultSet resultSet = null;
>             Statement statement = null;
>     //        PreparedStatement preparedStatement = null;
>             Connection connection = null;
>     
>             ResourceBundle resourceBundle = ResourceBundle.getBundle("JDBC");
>             String url = resourceBundle.getString("url");
>             String user = resourceBundle.getString("user");
>             String password = resourceBundle.getString("password");
>     
>             try
>             {
>                 Class.forName(resourceBundle.getString("Driver"));
>                 connection = DriverManager.getConnection(url,user,password);
>                 String sql = "select actor_id from actor order by actor_id " + order;
>                 statement = connection.createStatement();
>     //            preparedStatement = connection.prepareStatement(sql);
>     //            preparedStatement.setString(1, order);
>                 System.out.println(sql);
>     //            resultSet = preparedStatement.executeQuery();
>                 resultSet = statement.executeQuery(sql);
>                 while (resultSet.next())
>                 {
>                     System.out.println(resultSet.getString("actor_id"));
>                 }
>             }
>             catch (Exception e)
>             {
>                 throw new RuntimeException(e);
>             }
>             finally
>             {
>                 if (resultSet != null)
>                 {
>                     try
>                     {
>                         resultSet.close();
>                     }
>                     catch (SQLException e)
>                     {
>                         throw new RuntimeException(e);
>                     }
>                 }
>                 if (statement != null)
>                 {
>                     try
>                     {
>                         statement.close();
>                     }
>                     catch (SQLException e)
>                     {
>                         throw new RuntimeException(e);
>                     }
>                 }
>     //            if (preparedStatement != null)
>     //            {
>     //                try
>     //                {
>     //                    preparedStatement.close();
>     //                }
>     //                catch (SQLException e)
>     //                {
>     //                    throw new RuntimeException(e);
>     //                }
>     //            }
>                 if (connection != null)
>                 {
>                     try
>                     {
>                         connection.close();
>                     }
>                     catch (SQLException e)
>                     {
>                         throw new RuntimeException(e);
>                     }
>                 }
>             }
>         }
>     }
> 
> package com.powernode.jdbc;  
>   
> import java.sql.\*;  
> import java.util.ResourceBundle;  
> import java.util.Scanner;  
>   
> public class JDBCTest01  
> \{  
> public static void main(String\[\] args)  
> \{  
> //用户在控制台输入desc就是降序,输入ASC就是升序  
> Scanner in = new Scanner(System.in);  
> System.out.println("请输入ASC或DESC");  
> String order = in.nextLine();  
>   
> ResultSet resultSet = null;  
> Statement statement = null;  
> // PreparedStatement preparedStatement = null;  
> Connection connection = null;  
>   
> ResourceBundle resourceBundle = ResourceBundle.getBundle("JDBC");  
> String url = resourceBundle.getString("url");  
> String user = resourceBundle.getString("user");  
> String password = resourceBundle.getString("password");  
>   
> try  
> \{  
> Class.forName(resourceBundle.getString("Driver"));  
> connection = DriverManager.getConnection(url,user,password);  
> String sql = "select actor\_id from actor order by actor\_id " + order;  
> statement = connection.createStatement();  
> // preparedStatement = connection.prepareStatement(sql);  
> // preparedStatement.setString(1, order);  
> System.out.println(sql);  
> // resultSet = preparedStatement.executeQuery();  
> resultSet = statement.executeQuery(sql);  
> while (resultSet.next())  
> \{  
> System.out.println(resultSet.getString("actor\_id"));  
> \}  
> \}  
> catch (Exception e)  
> \{  
> throw new RuntimeException(e);  
> \}  
> finally  
> \{  
> if (resultSet != null)  
> \{  
> try  
> \{  
> resultSet.close();  
> \}  
> catch (SQLException e)  
> \{  
> throw new RuntimeException(e);  
> \}  
> \}  
> if (statement != null)  
> \{  
> try  
> \{  
> statement.close();  
> \}  
> catch (SQLException e)  
> \{  
> throw new RuntimeException(e);  
> \}  
> \}  
> // if (preparedStatement != null)  
> // \{  
> // try  
> // \{  
> // preparedStatement.close();  
> // \}  
> // catch (SQLException e)  
> // \{  
> // throw new RuntimeException(e);  
> // \}  
> // \}  
> if (connection != null)  
> \{  
> try  
> \{  
> connection.close();  
> \}  
> catch (SQLException e)  
> \{  
> throw new RuntimeException(e);  
> \}  
> \}  
> \}  
> \}  
> \}