swing界面与数据库查询操作.doc

Swing界面与数据库查询操作 import javax.swing.*; import javax.swing.border.*; import java.awt.*; import java.sql.*; import java.awt.event.*; public class jiemianchaxun extends JFrame implements ActionListener{ JTable table; Object[][] rowData=new Object[5][3]; String[] title={编号,标题,内容}; JLabel l1=new JLabel(); JLabel l2=new JLabel(); JTextField t0=new JTextField(); JButton b1=new JButton(); JButton b2=new JButton(); public jiemianchaxun(){ super(登入窗口); setBounds(200,200,360,310); setLayout(null); //不使用布局 l1.setForeground(Color.red); l1.setFont(new Font(,Font.BOLD,18)); l1.setText(新闻管理系统); l1.setBounds(39,28,170,36); add(l1); l2.setText(请输入查询编号:); l2.setBounds(38,83,100,15); add(l2); t0.setBounds(140,80,100,21); add(t0); b1.setText(退出); b1.setBounds(141,120,68,23); add(b1); b2.setText(确定); b2.setBounds(67,120,68,23); add(b2); setVisible(true); b2.addActionListener(this); b1.addActionListener(this); } public void actionPerformed(ActionEvent e){ if(e.getSource()==b2){ try { Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); String strCon = jdbc:odbc:xinwen; //连接字符串 String strUser = ; //数据库用户名 String strPwd = ; //口令 Connection conn=DriverManager.getConnection(strCon, strUser, strPwd); Statement stat = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); int id=Integer.parseInt(t0.getText()); ResultSet rs=stat.executeQuery(select * from xinwen where id=+id+); int count=0; while (rs.next()) {//遍历查询结果 rowData[count][0]=rs.getInt(ID); //初始化数组内容 rowData[count][1]=rs.getString(2); rowData[count][2]=rs.getString(3); count=c