java-数据库连接方法.txt

百货商场信息管理系统

//数据库连接方法
import java.sql.*;
  Connection con;
  Statement st;

  try{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      String url="jdbc:odbc:shopping";
      String username="";
      String password="";
      con=DriverManager.getConnection(url,username,password);
    
  }catch(SQLException e) 
  {
      e.printStackTrace();
  }
  catch(ClassNotFoundException e1)
  {
      e1.printStackTrace();
  }

//数据库查询方法

     try{
       String sql="select * from 个人信用卡库 ";
       st=con.createStatement();
       ResultSet result=st.executeQuery(sql);
       while(result.next())
       {
        number=result.getInt("商品代号");
        price=result.getInt("商品单价");
        name=result.getString("商品名称");
       }
       st.close();
     }catch(SQLException e1)
     {
       JOptionPane.showMessageDialog(null,"数据库连接失败");
     }
//数据库更新方法
     try {
       st = con.createStatement();
       sql = "update 个人信用卡库 set 卡号='" + cardNumber + "',密码='" + password +
           "',姓名='" + name + "',金额=" + leftMoney + " where 卡号='" + cardNumber +
           "' ";
       st.executeUpdate(sql);
       JOptionPane.showMessageDialog(null, "更新成功!");
     }
     catch (SQLException e1) {
       JOptionPane.showMessageDialog(null, "数据库连接失败");

     }
//数据库删除方法
    String sql="delete * from 单价库 where 商品代号="+number;
      try {
        st = con.createStatement();
        st.executeUpdate(sql);
        JOptionPane.showMessageDialog(null, "删除成功！");
        st.close();
      }
      catch (SQLException e1) {
        JOptionPane.showMessageDialog(null, "数据库连接失败");
      }
    }
//数据库插入方法
     try {
       st = con.createStatement();
       sql = "insert into 个人信用卡库 values('" + cardNumber + "','" + password +
           "','" + name + "'," + Money + ")";
       st.executeUpdate(sql);
       JOptionPane.showMessageDialog(null, "添加成功!");
     }
     catch (SQLException e1) {
       JOptionPane.showMessageDialog(null, "数据库连接失败");
     }
   }