连接数据库 增加 删除 查询 修改 (swing中)

本文提供了一个使用Java进行数据库操作的示例,包括插入记录、查询所有记录、查询特定条件的记录以及批量插入记录的方法。通过具体的代码展示了如何利用Statement和PreparedStatement来实现这些功能。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

1. 插入
//插入语句连接数据库(按钮)
 public static Connection fetchconnection()
 {
  try{
         Class.forName("oracle.jdbc.driver.OracleDriver");
      String url ="jdbc:oracle:thin:@192.168.119.108:1521:orclcn";
   String user = "zenggan";
   String pwd = "zeng";
      return DriverManager.getConnection(url, user, pwd);
  }
  catch(Exception e)
  {
   e.printStackTrace();
   return null;
  }
 }

 
 private void addCourseButtonActionPerformed(ActionEvent evt) throws SQLException {
  /**
   * 插入语句
   */
  //---------------------------------
  Statement statement = null;
  Connection connection =null;
  //ResultSet resultSet = null;
  try{
   connection = fetchconnection();
   //System.out.println(connection);
   statement = connection.createStatement();
   
   String sql = "insert into subject(sub_id,sub_name,credit) values('"+this.sub_idTextField.getText()+"','"+this.sub_nameTextField.getText()+"','"+this.creditTextField.getText()+"')";
      statement.executeUpdate(sql);
     
  }
  catch(Exception e)
  {
      e.printStackTrace();
  }
  finally{
   //resultSet.close();
   statement.close();
   connection.close();
  }


2. 查询
Statement statement = null;
  Connection connection =null;
  ResultSet resultSet = null;
  try{
   connection = fetchconnection();
   //System.out.println(connection);
   statement = connection.createStatement();
   
  /* String sql = "insert into class values(120,'zeng')";
   int i = statement.executeUpdate(sql);
    System.out.println(i);  */
   
   String sql = "select * from class";
   resultSet = statement.executeQuery(sql);
   while(resultSet.next())
   {
     System.out.println("id: "+resultSet.getLong("id")+"| name: "+resultSet.getString("psd"));
   }   
  }
  catch(Exception e)
  {
      e.printStackTrace();
  }
  finally{
   resultSet.close();
   statement.close();
   connection.close();
  }

 }
 public static Connection fetchconnection()
 {
  try{
         Class.forName("oracle.jdbc.driver.OracleDriver");
      String url ="jdbc:oracle:thin:@192.168.119.108:1521:orclcn";
   String user = "zenggan";
   String pwd = "zeng";
      return DriverManager.getConnection(url, user, pwd);
  }
  catch(Exception e)
  {
   e.printStackTrace();
   return null;
  }
 }


3. 查询ID>5的数据库里面的信息
 public static void main(String[] args) throws Exception {
  
  PreparedStatement statement = null;
  Connection connection =null;
  ResultSet resultSet = null;
  try{
   connection = fetchconnection();
   
   String sql = "select * from class where id > ?";
   statement = connection.prepareStatement(sql); 
   statement.setLong(1, 5);//此处是最大区别
   resultSet = statement.executeQuery();
   while(resultSet.next())
   {
     System.out.println("id: "+resultSet.getLong("id")+"| name: "+resultSet.getString("psd"));
   }   
  }
  catch(Exception e)
  {
      e.printStackTrace();
  }
  finally{
   resultSet.close();
   statement.close();
   connection.close();
  }

 }
 public static Connection fetchconnection()
 {
  try{
         Class.forName("oracle.jdbc.driver.OracleDriver");
      String url ="jdbc:oracle:thin:@192.168.119.108:1521:orclcn";
   String user = "zenggan";
   String pwd = "zeng";
      return DriverManager.getConnection(url, user, pwd);
  }
  catch(Exception e)
  {
   e.printStackTrace();
   return null;
  }
 }
}

4.  插入多条语句时代码
public static void main(String[] args) throws Exception {
  
  Statement statement = null;
  Connection connection =null;
  ResultSet resultSet = null;
  try{
   connection = fetchconnection();
   connection.setAutoCommit(false);    //设置为手动提交
   String sql = "insert into class values(119,'火警')";
   statement = connection.createStatement(); 
   int updateline = statement.executeUpdate(sql); 
   sql = "insert into class values(110,'匪警')";
   statement.executeUpdate(sql);
   sql = "insert into class values(111,'不知111')";
   statement.executeUpdate(sql);
   connection.commit();
   
   sql = "insert into class values(112,'不知112')";
   statement.executeUpdate(sql);
   sql = "insert into class values(114,'据说咨询XX')";
   statement.executeUpdate(sql);
   sql = "insert into class values(115,'不知115')";
   statement.executeUpdate(sql);
   connection.rollback();
  }
  catch(Exception e)
  {
      e.printStackTrace();
  }
  finally{
   //resultSet.close();
   statement.close();
   connection.close();
  }

 }
 public static Connection fetchconnection()
 {
  try{
         Class.forName("oracle.jdbc.driver.OracleDriver");
      String url ="jdbc:oracle:thin:@192.168.119.108:1521:orclcn";
   String user = "zenggan";
   String pwd = "zeng";
      return DriverManager.getConnection(url, user, pwd);
  }
  catch(Exception e)
  {
   e.printStackTrace();
   return null;
  }
 }

评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值