具體如圖，，我的圖書號(hào)無法輸入，沒有輸入的地方，，是我標(biāo)簽定義的有問題嗎，自己無解，求幫助，謝謝具體代碼如下：package com.zyp;import java.awt.event.*;import javax.swing.*;import java.awt.*;import java.awt.Container;import java.util.*;import java.sql.*;class QueryBook implements ActionListener{ ??? ? JFrame f3; Container cp; JPanel jp1,jp2,jp3,jp4,jp,jpanelWest; JButton ?jbt1,jbt2;//按鈕，確定、取消 JLabel label; //標(biāo)簽：請(qǐng)輸入圖書號(hào) JTextField tf,tf1,tf2,tf3,tf4,tf5,tf6; ? ?//定義文本框 JLabel label1,label2,label3,label4; ? ? QueryBook()? ?{? f3=new JFrame(); cp=f3.getContentPane(); // 初始化面板、按鈕、標(biāo)簽、文本框 jp1=new JPanel(); ? ? ?? jp2=new JPanel(); jp3=new JPanel(); jp4=new JPanel(); jpanelWest=new JPanel(); jp=new JPanel(); jbt1=new JButton("確定"); ?? jbt2=new JButton("取消"); label=new JLabel("<html><font color=#CC00FF size='4'>請(qǐng)輸入圖書號(hào)：</font>",SwingConstants.CENTER); label.setForeground(Color.blue); tf=new JTextField(20); tf1=new JTextField(20); tf2=new JTextField(20); tf3=new JTextField(20); tf4=new JTextField(20); tf5=new JTextField(20);? ? tf6=new JTextField(20); //布局,添加控件 JPanel jpanel=new JPanel(); jpanel.add(label); jpanel.add(tf); JPanel pp4=new JPanel();? ? JPanel jpane4=new JPanel(); cp.add(jpanel,"North"); JPanel pp2=new JPanel(new GridLayout(6,1)); JPanel pp3=new JPanel(); pp4.setLayout(new GridLayout(6,1)); pp4.add(new JLabel("圖書名",SwingConstants.CENTER)); pp2.add(tf1); pp4.add(new JLabel("圖書號(hào)",SwingConstants.CENTER)); pp2.add(tf2); pp4.add(new JLabel("單 ?價(jià)",SwingConstants.CENTER)); pp2.add(tf3); pp4.add(new JLabel("作 ?者",SwingConstants.CENTER)); pp2.add(tf4); pp4.add(new JLabel("出版社",SwingConstants.CENTER)); pp2.add(tf5); pp4.add(new JLabel("入庫(kù)時(shí)間",SwingConstants.CENTER)); pp2.add(tf6); pp3.add(jbt1);? ? pp3.add(jbt2);? ? cp.add(pp4,"West"); cp.add(pp2,"Center");? ? cp.add(pp3,"South"); ? cp.add(jpane4,"East"); ? ? ?Toolkit kit=Toolkit.getDefaultToolkit(); Dimension screen=kit.getScreenSize(); int x=screen.width; /*取得顯示器窗口的寬度*/ int y=screen.height; /*取得顯示器窗口的高度*/ f3.setSize(350,330); int xcenter=(x-350)/2; int ycenter=(y-330)/2; f3.setLocation(xcenter,ycenter);/*顯示在窗口中央*/ f3.setVisible(true);? ?? ? jbt1.addActionListener(this);//注冊(cè)監(jiān)聽器? ? jbt2.addActionListener(this);? ??? ??? ? f3.addWindowListener(new WindowAdapter(){ public void windowClosing(WindowEvent e){ System.exit(0); } } ); } public void showRecord() {? Connection con = null;? ? try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); ? }catch(ClassNotFoundException e){System.out.println("加載驅(qū)動(dòng)程序失敗!");} try{ String url = "jdbc:sqlserver://localhost:1433;databasename=DB";//直接使用當(dāng)前類目錄下的數(shù)據(jù)庫(kù)文件 String user= "zyp"; ? ? ? ? ? ? String password = "215"; ? ? ? ? ? ? con =DriverManager.getConnection(url, user, password); Statement sql; String ql=tf.getText().trim(); String s="select * from book ?where 圖書號(hào) ='"+ql +"'";? ? ? ? ? ? sql=con.createStatement(); ResultSet rs=sql.executeQuery(s); if(rs.next()) ? ? ? ? { ?? ? ? ? String bname=rs.getString(1); String bno=rs.getString(2); String price=rs.getString(3); String writer=rs.getString(4); String publish=rs.getString(5); String indate=rs.getString(6); tf1.setText(bname); tf2.setText(bno); tf3.setText(price); tf4.setText(writer); tf5.setText(publish); tf6.setText(indate); }??? ? ? ? ? ? ? ? else ? ? ? ? ? ? {JOptionPane.showMessageDialog(null,"您輸入的圖書號(hào)不存在，請(qǐng)重新輸入", "輸入錯(cuò)誤", JOptionPane.YES_NO_OPTION); } con.close();? ? ? ? ? ? }catch(SQLException g) { System.out.println("E Code"+g.getErrorCode()); System.out.println("E M"+g.getMessage()); ? ? }? ?? ?tf1.setEditable(false); ?tf2.setEditable(false);? ?tf3.setEditable(false); ?tf4.setEditable(false); ?tf5.setEditable(false); ?tf6.setEditable(false); } public void actionPerformed(ActionEvent e) { ? String cmd=e.getActionCommand(); ? ?if(cmd.equals("確定")) ? ? { ? ?showRecord(); tf.setText(""); ?}? ?? ? else if(cmd.equals("取消")) ? f3.hide(); ? ? ? ?? }public static void main(String []arg){ ?? ? QueryBook a=new QueryBook();}}
添加回答
舉報(bào)
0/150
提交
取消