package sel;
import Bean.WaresBean;
import db.DBUtil;

import java.sql.Connection;
import java.util.ArrayList;

public class WaresSel {
    public ArrayList select(String s1,String s2,int row){
        Connection con= DBUtil.getConnection();
        java.sql.PreparedStatement ps=null;
        java.sql.ResultSet rs=null;
        ArrayList array=new ArrayList();
        String sql="select *from war order by ? ?";
        try{
            ps=con.prepareStatement(sql);
            ps.setString(1, s1);
            ps.setString(2, s2);
            rs=ps.executeQuery();
            
            rs.absolute(row);
                array.add(rs.getString(1));
                array.add(rs.getString(2));
                array.add(rs.getString(3));
                array.add(rs.getString(4));
                array.add(rs.getString(5));
        }catch (java.sql.SQLException e){
            e.printStackTrace();
        }finally{
            DBUtil.closeAll(con, ps, rs);
        }
        return array;
    }
    public int getRow(String s1,String s2){
        Connection con= DBUtil.getConnection();
        java.sql.PreparedStatement ps=null;
        java.sql.ResultSet rs=null;
        ArrayList array=new ArrayList();
        String sql="select *from war order by ? ?";
        try{
            ps=con.prepareStatement(sql);
            
            ps.setString(1, s1);
            
            ps.setString(2, s2);
            rs=ps.executeQuery();
            int row=rs.getRow();
            return row;
        }catch (java.sql.SQLException e){
            e.printStackTrace();
        }finally{
            DBUtil.closeAll(con, ps, rs);
        }
        return 0;
    }
}

    private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
        String s1 = jComboBox1.getSelectedItem().toString();
        String s2 = jComboBox2.getSelectedItem().toString();
        
        if(s1.equals("商品名称")){
            s1="waresName";
        }else if(s1.equals("商品价格")){
            s1="waresPrice";
        }else if(s1.equals("折扣额")){
            s1="rebate";
        }else{
            s1="surplusCount";
        }
        if (s2.equals("降序")) {
            s2 = "desc";
        } else {
            s1 = null;
        }
        
        ArrayList a2 = new ArrayList();
        WaresSel ws = new WaresSel();
        int row = ws.getRow(s1, s2) + 1;
        
        a2 = ws.select(s1, s2, row);

        if(a2.toString().length()<s1.length()){
            javax.swing.JOptionPane.showMessageDialog(this, "没有下一个商品","错误",0);
        }
        
        jTextArea1.setText(a2.get(1).toString());
        jTextField1.setText(a2.get(2).toString());
        jTextField2.setText(a2.get(3).toString());
        jTextField3.setText(a2.get(4).toString());
        jTextArea2.setText(a2.get(5).toString());

    }

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
        String s1 = jComboBox1.getSelectedItem().toString();
        String s2 = jComboBox2.getSelectedItem().toString();
        
        if(s1.equals("商品名称")){
            s1="waresName";
        }else if(s1.equals("商品价格")){
            s1="waresPrice";
        }else if(s1.equals("折扣额")){
            s1="rebate";
        }else{
            s1="surplusCount";
        }
        if (s2.equals("降序")) {
            s2 = "desc";
        } else {
            s1 = null;
        }
        
        ArrayList a1 = new ArrayList();
        WaresSel ws = new WaresSel();
        int row = ws.getRow(s1, s2) - 1;
        
        
        
        
        if (row <= 0) {
            javax.swing.JOptionPane
                    .showMessageDialog(this, "没有上一个商品。", "错误", 0);
            return;
        }
        a1 = ws.select(s1, s2, row);

        jTextArea1.setText(a1.get(1).toString());
        jTextField1.setText(a1.get(2).toString());
        jTextField2.setText(a1.get(3).toString());
        jTextField3.setText(a1.get(4).toString());
        jTextArea2.setText(a1.get(5).toString());

    }

    private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {
        this.dispose();
    }

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
        String s1 = jComboBox1.getSelectedItem().toString();
        String s2 = jComboBox2.getSelectedItem().toString();
        ArrayList a = new ArrayList();
        if(s1.equals("商品名称")){
            s1="waresName";
        }else if(s1.equals("商品价格")){
            s1="waresPrice";
        }else if(s1.equals("折扣额")){
            s1="rebate";
        }else{
            s1="surplusCount";
        }
        if (s2.equals("降序")) {
            s2 = "desc";
        } else {
            s1 = null;
        }
        WaresSel ws = new WaresSel();
        a =ws.select(s1, s2, 1);
        jTextArea1.setText(a.get(1).toString());
        jTextField1.setText(a.get(2).toString());
        jTextField2.setText(a.get(3).toString());
        jTextField3.setText(a.get(4).toString());
        jTextArea2.setText(a.get(5).toString());

    }