JAVA使用JDBC进行insert操作添加信息到数据库-----JDBC

骑猪看日落 2024-03-23 19:02 77阅读 0赞

>     import java.sql.Connection;
>     import java.sql.DriverManager;
>     import java.sql.SQLException;
>     import java.sql.Statement;
>     
>     public class JDBCTest02
>     {
>         public static void main(String[] args)
>         {
>             Connection connection = null;
>             Statement statement = null;
>             try
>             {
>                 DriverManager.registerDriver(new com.mysql.jdbc.Driver());
>                 connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:13306/mall","root","abc123");
>                 statement = connection.createStatement();
>                 String sql = "insert into users(username,email,pssword) values('Allan','abc123@123','123')";
>                 int result = statement.executeUpdate(sql);
>                 System.out.println(result == 1 ? "添加成功" : "添加失败");
>             }
>             catch(SQLException e)
>             {
>                 e.printStackTrace();
>             }
>             finally
>             {
>                 try
>                 {
>                     if (statement != null)
>                     {
>                         statement.close();
>                     }
>                 }
>                 catch (SQLException e)
>                 {
>                     throw new RuntimeException(e);
>                 }
>                 try
>                 {
>                     if (connection != null)
>                     {
>                         connection.close();
>                     }
>                 }
>                 catch (SQLException e)
>                 {
>                     throw new RuntimeException(e);
>                 }
>             }
>         }
>     }
> 
> import java.sql.Connection;  
> import java.sql.DriverManager;  
> import java.sql.SQLException;  
> import java.sql.Statement;  
>   
> public class JDBCTest02  
> \{  
> public static void main(String\[\] args)  
> \{  
> Connection connection = null;  
> Statement statement = null;  
> try  
> \{  
> DriverManager.registerDriver(new com.mysql.jdbc.Driver());  
> connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:13306/mall","root","abc123");  
> statement = connection.createStatement();  
> String sql = "insert into users(username,email,pssword) values('Allan','abc123@123','123')";  
> int result = statement.executeUpdate(sql);  
> System.out.println(result == 1 ? "添加成功" : "添加失败");  
> \}  
> catch(SQLException e)  
> \{  
> e.printStackTrace();  
> \}  
> finally  
> \{  
> try  
> \{  
> if (statement != null)  
> \{  
> statement.close();  
> \}  
> \}  
> catch (SQLException e)  
> \{  
> throw new RuntimeException(e);  
> \}  
> try  
> \{  
> if (connection != null)  
> \{  
> connection.close();  
> \}  
> \}  
> catch (SQLException e)  
> \{  
> throw new RuntimeException(e);  
> \}  
> \}  
> \}  
> \}