祈昕 Homy灬幻陨
DoitlikeaSamurai
关注数: 47 粉丝数: 1,398 发帖数: 5,728 关注贴吧数: 45
问一下为什么我的jtable不显示? package tie;import java.awt.*; import java.sql.*; import javax.swing.*; import javax.swing.JFrame; import javax.swing.JTable; import javax.swing.JButton; import java.awt.Font; import javax.swing.JLabel; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.awt.event.ActionEvent;public class gys { public static void main(String[] args) { JFrame frame = new JFrame(); frame.setTitle("\u836F\u623F\u7BA1\u7406\u7CFB\u7EDF"); frame.setBounds(100, 100, 780, 500); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); frame.getContentPane().setLayout(null); JButton button = new JButton("\u66F4\u6539\u4FE1\u606F"); button.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { } }); JLabel label = new JLabel("\u4F9B\u5E94\u5546\u4FE1\u606F\u8868"); label.setFont(new Font("宋体", Font.PLAIN, 15)); label.setBounds(111, 34, 107, 30); frame.getContentPane().add(label); JButton button_1 = new JButton("\u65B0\u589E\u4FE1\u606F"); button_1.setFont(new Font("宋体", Font.PLAIN, 15)); button_1.setBounds(354, 34, 97, 30); frame.getContentPane().add(button_1); button.setFont(new Font("宋体", Font.PLAIN, 15)); button.setBounds(471, 34, 97, 30); frame.getContentPane().add(button); JButton button_2 = new JButton("\u9009\u62E9\u5220\u9664"); button_2.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { } }); button_2.setFont(new Font("宋体", Font.PLAIN, 15)); button_2.setBounds(590, 34, 97, 30); frame.getContentPane().add(button_2); JTable table = new JTable(); table.setBounds(42, 95, 662, 331); JScrollPane JSP= new JScrollPane(table); JSP.setSize(616, 268); JSP.setLocation(71, 149); frame.getContentPane().add(JSP); try { // 链接数据库 Connection con = null; String dbURL = "jdbc:sqlserver://localhost:1433;DatabaseName=药房管理系统数据库"; String userName = "帖经明"; String userPwd = "tie1008611"; ResultSet rs = null; Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); System.out.println("数据库驱动加载成功"); con = DriverManager.getConnection(dbURL, userName, userPwd); System.out.println("数据库连接成功"); Statement sql = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); String sqls = "SELECT *FROM 供应商"; rs = sql.executeQuery(sqls); rs.last(); int lastNumber = rs.getRow(); Object a[][]; Object name[] = { "供应商名", "供应商编号" }; a = new Object[lastNumber][2]; int k = 0; rs.beforeFirst(); while (rs.next()) { a[k][0] = rs.getString(1); a[k][1] = rs.getString(2); k++; } } catch (Exception e) { e.printStackTrace(); System.out.print("连接失败"); } frame.setVisible(true); } }
1 下一页