yw.java~5~

JAVA实验图形 =各种 的 JAVA简单代码 出初学者必备！！！！！！！！！

        try {
            f.start(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        f.setSize(550, 300);
        f.setTitle("发票");
        f.setVisible(true);
    }

    public void chaxun4() {
        String sql = "select bno,bname from allbook";
        JDBCJTable f = new JDBCJTable();
        f.init();
        try {
            f.start(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        f.setSize(400, 300);
        f.setTitle("教材号与教材名查询表");
        f.setVisible(true);
    }

    public void chaxun() {
        String sql = "select * from allbook";
        JDBCJTable f = new JDBCJTable();
        f.init();
        try {
            f.start(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        f.setSize(550, 300);
        f.setTitle("教材一览表");
        f.setVisible(true);
    }

    public void chaxun2() {
        String sql = "select * from sellbook";
        JDBCJTable f = new JDBCJTable();
        f.init();
        try {
            f.start(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        f.setSize(550, 300);
        f.setTitle("学生申请教材表");
        f.setVisible(true);
    }

    public void chaxun3() {
        String sql = "select * from nobook";
        JDBCJTable f = new JDBCJTable();
        f.init();
        try {
            f.start(sql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        f.setSize(330, 250);
        f.setTitle("缺书一览表");
        f.setVisible(true);
    }


    public void y1() {
        {

            Button bbb = new Button("点击查看书号书名");
            Frame e = new Frame();
            e.setSize(600, 600);
            e.setBackground(Color.DARK_GRAY);
            e.setTitle("教材购销管理系统 ");
            e.add(bb);
            e.add(bbb);
            e.setVisible(true);
            Label pan = new Label("欢迎使用教材购销管理系统");
            Font w = new Font("TimesRoman", Font.CENTER_BASELINE, 20);
            b4.setSize(100, 20);
            b4.setEditable(true);
            b4.setText("书号");
            b4.setVisible(true);
            b5.setSize(100, 20);
            b4.setLocation(50, 350);
            b5.setEditable(true);
            b5.setLocation(300, 350);
            b5.setText("数量");
            b5.setVisible(true);
            e.add(b4);
            e.add(b5);
            b2.setSize(100, 20);
            b2.setEditable(true);
            b2.setText("学号");
            b2.setVisible(true);
            b6.setSize(100, 20);
            b6.setEditable(true);
            b6.setText("班级");
            b6.setVisible(true);
            e.add(b6);
            b6.setLocation(50, 250);

            e.add(b2);
            b2.setLocation(50, 300);
            bb.setSize(80, 20);
            bb.setVisible(true);
            e.add(bb);
            bb.setLocation(450, 350);
            bbb.setSize(150, 20);
            bbb.setVisible(true);
            b3.setSize(100, 20);
            bbb.setLocation(180, 200);
            b3.setEditable(true);
            b3.setText("姓名");
            b3.setVisible(true);
            pan.setFont(w);
            pan.setVisible(true);
            pan.setSize(300, 200);
            pan.setVisible(true);
            pan.setLocation(150, 50);
            e.add(pan);
            e.add(b3);
            b3.setLocation(300, 300);

            MenuBar mb = new MenuBar();
            Menu m1 = new Menu("申请教材");
            Menu m6 = new Menu("秘书系统");
            Menu m2 = new Menu("查看申请教材历史");
            MenuItem m61 = new MenuItem("查看待购教材记录");  MenuItem m63 = new MenuItem("删除教材记录");
            Menu m3 = new Menu("离开教材购销管理系统");
            Menu m4 = new Menu("采购员购书系统");
            MenuItem m11 = new MenuItem("申请教材登记");
            Menu m21 = new Menu("查看学生记录");
            MenuItem m211 = new MenuItem("查看学生申请记录");
            MenuItem m212 = new MenuItem("查看班级学生申请记录");
            MenuItem m22 = new MenuItem("查看教材");
            MenuItem m41 = new MenuItem("采购员根据书号进书");
            MenuItem m42 = new MenuItem("新近教材登记");
            m1.add(m11); m2.add(m21);m2.add(m22);m4.add(m41);
            m4.add(m42);m21.add(m211);m21.add(m212);m41.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {chaxun7();}}); m42.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent e) {insert();}
            }); e.setMenuBar(mb);
            MenuItem m62 = new MenuItem("秘书生成缺书单");
            bbb.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {
                    chaxun4();
                }
            }); m11.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {
                    jie();
                    System.out.println("num1:" + num1);
                } }); bb.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {
                    jie();
                    num1 = b2.getText();
                    System.out.println("num1:" + num1);
                } });m21.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {
                    chaxun2();
                }}); m22.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {
                    chaxun();
                }
            });m61.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {
                    chaxun3();
                }});m62.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {
                    goushubiao();}}); m63.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {
                    delete();
                } });mb.add(m1);mb.add(m2);m6.add(m61);m6.add(m62);m6.add(m63);
            mb.add(m6);mb.add(m4);mb.setHelpMenu(m3);e.addWindowListener(
            new WindowAdapter() {public void windowClosing(WindowEvent e) {
                    System.exit(0);
                } });} }public void init() {
        records = new Vector();
        tm = new AbstractTableModel() {
            public int getColumnCount() {
                return titles.length; //取得表格列数
            }public int getRowCount() {
                return records.size(); //取得表格行数
            } public Object getValueAt(int row, int column) {
                if (!records.isEmpty()) { //取得单元格中的属性值
                    return ((Vector) records.elementAt(row)).elementAt(column);
                } else { return null; }} public String getColumnName(int column) {
                return titles[column]; }
public void setValueAt(Object value, int row, int column) {}
public Class getColumnClass(int c) {
                return getValueAt(0, c).getClass();
            }  public boolean isCellEditable(int row, int column) {
                return false; }};}
public void start2(String sql) throws SQLException {
        Statement stmt;
        PreparedStatement pstmt;
        ResultSet rs;
        //加载JDBC-ODBC桥驱动
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            //定义JDBC URL
            String url = "jdbc:odbc:s";
            //得到与数据库的连接
            Connection con = DriverManager.getConnection(url, "system", "sys");
            //显示UPL和连接信息
            System.out.println("URL:" + url);
            System.out.println("Connection:" + con);
            //得到一个Statement对象
            stmt = con.createStatement();
            //执行SQL语句
            System.out.println("SQL:" + sql);
ResultSet p = stmt.executeQuery(sql);
            ResultSetMetaData meta = p.getMetaData();
            if (p.next()) { number = p.getInt("bnum");bookname = p.getString("bname");bj = p.getInt("bjiage");  }System.out.println("CBS：" + cbs);
        } catch (Exception e) {}}
public void start(String sql) throws SQLException {
        Statement stmt;
        PreparedStatement pstmt;
        ResultSet rs;
        //加载JDBC-ODBC桥驱动
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            //定义JDBC URL
            String url = "jdbc:odbc:s";
            //得到与数据库的连接
            Connection con = DriverManager.getConnection(url, "system", "sys");
            //显示UPL和连接信息
            System.out.println("URL:" + url);
            System.out.println("Connection:" + con);
            //得到一个Statement对象
            stmt = con.createStatement();
            //执行SQL语句
            System.out.println("SQL:" + sql);

            ResultSet p = stmt.executeQuery(sql);
            ResultSetMetaData meta = p.getMetaData();
            int cols = meta.getColumnCount();
            System.out.println(cols);
            titles = new String[cols];
            for (int i = 0; i < cols; i++) {
                if (meta.getColumnName(i + 1).equals("BNO")) {
                    titles[i] = "书号";
                }
                if (meta.getColumnName(i + 1).equals("BNAME")) {
                    titles[i] = "书名";
                }
                if (meta.getColumnName(i + 1).equals("BJIAGE")) {
                    titles[i] = "书单价(元)";
                }
                if (meta.getColumnName(i + 1).equals("CBS")) {
                    titles[i] = "出版社";
                }
                if (meta.getColumnName(i + 1).equals("CBSADD")) {
                    titles[i] = "出版社地址";
                }
                if (meta.getColumnName(i + 1).equals("CBSPHONE")) {
                    titles[i] = "出版社电话";
                }
                if (meta.getColumnName(i + 1).equals("CLASS")) {
                    titles[i] = "班级";
                }
                if (meta.getColumnName(i + 1).equals("BNO")) {
                    titles[i] = "书号";
                }
                if (meta.getColumnName(i + 1).equals("BNAME")) {
                    titles[i] = "书名";
                }
                if (meta.getColumnName(i + 1).equals("BNUM")) {
                    titles[i] = "书数量(本)";
                }
                if (meta.getColumnName(i + 1).equals("SNAME")) {
                    titles[i] = "学生姓名";
                }
                if (meta.getColumnName(i + 1).equals("SNO")) {
                    titles[i] = "学号";
                }
                if (meta.getColumnName(i + 1).equals("ALLBJIAGE")) {
                    titles[i] = "总金额";
                }

            }
            records.removeAllElements();
            while (p.next()) {
                Vector rec_vector = new Vector();
                for (int i = 0; i < cols; i++) {
                    rec_vector.addElement(p.getObject(i + 1).toString());
                }
                records.addElement(rec_vector);
            }
            table = new JTable(tm); //生成自己的数据模型
            table.setToolTipText("显示所有查询结果");
            table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); //设置表格调整尺寸
            table.setCellSelectionEnabled(false); //设置单元格选择方式
            table.setShowVerticalLines(true);
            table.setShowHorizontalLines(true);
            scollpane = new JScrollPane(table);
            add(scollpane);
            tm.fireTableStructureChanged();
//打印测试

        } catch (Exception e) {}
    }
}