JAVA使用PreparedStatement进行增删改查-----JDBC

你的名字 2024-03-23 19:48 72阅读 0赞

>     package com.powernode.jdbc;
>     
>     import java.sql.*;
>     import java.util.ResourceBundle;
>     
>     public class JDBCTest02
>     {
>         public static void main(String[] args)
>         {
>             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 = "insert into users(username,email,pssword) values(?,?,?)";
>     //            preparedStatement = connection.prepareStatement(sql);
>     //            preparedStatement.setString(1,"Alatus");
>     //            preparedStatement.setString(2,"1234567891@qq.com");
>     //            preparedStatement.setString(3,"123456");
>     //            String sql = "update users set pssword = ?,email = ? where username = ?";
>     //            preparedStatement = connection.prepareStatement(sql);
>     //            preparedStatement.setString(1,"sasd");
>     //            preparedStatement.setString(2,"asd@qq.com");
>     //            preparedStatement.setString(3,"Alatus");
>     //            int i = preparedStatement.executeUpdate();
>                 String sql = "delete from users where username = ?";
>                 preparedStatement = connection.prepareStatement(sql);
>                 preparedStatement.setString(1,"Alatus");
>                 int i = preparedStatement.executeUpdate();
>                 System.out.println(i);
>             }
>             catch(Exception e)
>             {
>                 e.printStackTrace();
>             }
>             finally
>             {
>                 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;  
>   
> public class JDBCTest02  
> \{  
> public static void main(String\[\] args)  
> \{  
> 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 = "insert into users(username,email,pssword) values(?,?,?)";  
> // preparedStatement = connection.prepareStatement(sql);  
> // preparedStatement.setString(1,"Alatus");  
> // preparedStatement.setString(2,"1234567891@qq.com");  
> // preparedStatement.setString(3,"123456");  
> // String sql = "update users set pssword = ?,email = ? where username = ?";  
> // preparedStatement = connection.prepareStatement(sql);  
> // preparedStatement.setString(1,"sasd");  
> // preparedStatement.setString(2,"asd@qq.com");  
> // preparedStatement.setString(3,"Alatus");  
> // int i = preparedStatement.executeUpdate();  
> String sql = "delete from users where username = ?";  
> preparedStatement = connection.prepareStatement(sql);  
> preparedStatement.setString(1,"Alatus");  
> int i = preparedStatement.executeUpdate();  
> System.out.println(i);  
> \}  
> catch(Exception e)  
> \{  
> e.printStackTrace();  
> \}  
> finally  
> \{  
> 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);  
> \}  
> \}  
> \}  
> \}  
> \}