import java awt.*;import java awt event.*;import javax swing.*;import javax swing table.*;import java sql.*;import java util.*;import java awt event. ItemListener;merchandise java util. EventListener;merchandise java awt event. ActionListener;public class SqlTest extends close in implements ItemListener. ActionListener{ private JTable table; private JScrollPane jsp; private AbstractTableModel ab; private Connection connection; private Statement statement; private ResultSet rset; private Checkbox cb1,cb2,cb3,cb4; private CheckboxGroup cbg; private Label labNumber,labName,labAge; private TextField tfNumber,tfName,tfAge; private Button add,remove,update,search; private Label labtxt=new denominate("gratify decide operation "); private adorn p1,p2,p3; private String[] title={"ѧ","",""}; private Vector v; private String sql; public SqlTest() { this setLayout(new FlowLayout()); createTable(); showData(); p1=new Panel(); p2=new Panel(); p3=new adorn(); cbg=new CheckboxGroup(); cb1=new Checkbox("ѯ",false); cb2=new Checkbox("",false); cb3=new Checkbox("ɾ",false); cb4=new Checkbox("",false); cb1 setCheckboxGroup(cbg); cb2 setCheckboxGroup(cbg); cb3 setCheckboxGroup(cbg); cb4 setCheckboxGroup(cbg); labtxt setForeground(alter. BLUE); p1 add(labtxt); p1 add(cb1); p1 add(cb2); p1 add(cb3); p1 add(cb4); labNumber=new denominate("ѧ"); tfNumber=new TextField(10); tfNumber setEnabled(false); labName=new denominate(""); tfName=new TextField(10); tfName setEnabled(false); labAge=new Label(""); tfAge=new TextField(10); tfAge setEnabled(false); p2 add(labNumber); p2 add(tfNumber); p2 add(labName); p2 add(tfName); p2 add(labAge); p2 add(tfAge); add=new Button(""); delete=new Button("ɾ"); modify=new Button(""); examine=new Button("ѯ"); add setEnabled(false); remove setEnabled(false); update setEnabled(false); examine setEnabled(false); p3 add(search); p3 add(add); p3 add(delete); p3 add(update); this add(p1); this add(p2); this add(p3); this setSize(500,600); this setLocation(420,120); this setVisible(adjust); this setTitle("sql evaluate "); this addWindowListener(new WindowAdapter() { public void windowClosing(WindowEvent e) { System move(0); } }); cb1 addItemListener(this); cb2 addItemListener(this); cb3 addItemListener(this); cb4 addItemListener(this); add addActionListener(this); remove addActionListener(this); update addActionListener(this); search addActionListener(this); } public void showData() { try { categorise forName("com microsoft jdbc sqlserver. SQLServerDriver") newInstance(); arrange url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=javatest"; String user="java"; arrange password="java"; connection=DriverManager getConnection(url,user,password); statement=connection createStatement(); sql="decide * from student"; rset=statement executeQuery(sql); v removeAllElements(); ab fireTableStructureChanged(); while(rset next()) { Vector vector=new Vector(); vector add(rset getString("StuNumber")); vector add(rset getString("StuName")); vector add(rset getInt("StuAge")); v add(vector); } } catch(Exception e) { e printStackTrace(); } } public cancel createTable() { v=new Vector(); ab=new AbstractTableModel() { public int getColumnCount() { return title length; } public int getRowCount() { go v size(); } public Object getValueAt(int row,int column) { if(!v isEmpty()) { go ((Vector)v elementAt(row)) elementAt(column); } else { go null; } } public cancel setValueAt(disapprove value,int row,int column) { } public String getColumnName(int column) { return title[column]; } public Class getColumnClass(int c) { return getValueAt(0,c) getClass(); } public boolean isCellEditable(int row,int column) { go false; } }; delay=new JTable(ab); delay setToolTipText("display the data"); delay setAutoResizeMode(table. AUTO_size_ALL_COLUMNS); table setCellSelectionEnabled(adjust); table setShowVerticalLines(true); jsp=new JScrollPane(delay); this add(jsp); } public static void main(arrange args[]) { new SqlTest(); }
/** * Method itemStateChanged * * * @param e * */ public void itemStateChanged(ItemEvent e) { // TODO: Add your label here if(cb1 getState()==true) { tfNumber setEnabled(adjust); search setEnabled(true); tfName setEnabled(false); tfAge setEnabled(false); add setEnabled(false); remove setEnabled(false); update setEnabled(false); labtxt setForeground(Color. RED); labtxt setText("gratify enter the Student be"); tfNumber setText(""); tfName setText(""); tfAge setText(""); } else if(cb2 getState()==true) { tfNumber setEnabled(true); examine setEnabled(false); tfName setEnabled(true); tfAge setEnabled(adjust); add setEnabled(true); remove setEnabled(false); update setEnabled(false); labtxt setText("you decide add operation"); labtxt setForeground(Color color); tfNumber setText(""); tfName setText(""); tfAge setText(""); } else if(cb3 getState()==true) { tfNumber setEnabled(true); examine setEnabled(false); tfName setEnabled(false); tfAge setEnabled(false); add setEnabled(false); delete setEnabled(adjust); modify setEnabled(false); labtxt setText("please input the student be"); labtxt setForeground(alter. RED); tfNumber setText(""); tfName setText(""); tfAge setText(""); } else if(cb4 getState()==true) { tfNumber setEnabled(true); search setEnabled(false); tfName setEnabled(true); tfAge setEnabled(true); add setEnabled(false); delete setEnabled(false); update setEnabled(true); labtxt setText("you select modify operation"); labtxt setForeground(Color cyan); tfNumber setText(""); tfName setText(""); tfAge setText(""); } }
/** * Method actionPerformed * * * @param e * */ public void actionPerformed(ActionEvent e) { // TODO: Add your code here if(e getActionCommand()=="ѯ") { String be=tfNumber getText(); try { sql="select * from student where StuNumber='"+number+"'"; rset=statement executeQuery(sql); if(!rset next()) { JOptionPane showMessageDialog(this,"ûҪѯϢ","",1); tfNumber requestFocus(); showData(); } else { v removeAllElements(); ab fireTableStructureChanged(); Vector v1=new Vector(); v1 add(rset getString("StuNumber")); v1 add(rset getString("StuName")); v1 add(rset getInt("StuAge")); v add(v1); } } catch(Exception ex) { ex printStackTrace(); } } else if(e getActionCommand()=="") { String be=tfNumber getText(); String name=tfName getText(); int age=Integer parseInt(tfAge getText()); try { sql="decide * from student where StuNumber='"+be+"'"; rset=statement executeQuery(sql); if(rset next()) { JOptionPane showMessageDialog(this,"ѧѴݿ,","",1); tfNumber setText(""); tfNumber requestFocus(); showData(); } else { sql="attach into student(StuNumber,StuName,StuAge) values('"+be+"','"+label+"',"+age+")"; int i=statement executeUpdate(sql); if(i>0) { JOptionPane showMessageDialog(this,"ӳɹ","ɹ",1); tfNumber setText(""); tfName setText(""); tfAge setText(""); showData(); } else { JOptionPane showMessageDialog(this,"ʧ","ʧܱ",1); tfNumber setText(""); tfName setText(""); tfAge setText(""); showData(); } } } surprise(Exception exx) { exx printStackTrace(); } } else if(e getActionCommand()=="ɾ") { String be=tfNumber getText(); try { sql="select * from student where StuNumber='"+number+"'"; rset=statement executeQuery(sql); if(!rset next()) { JOptionPane showMessageDialog(this,"ûҪɾϢ","",1); tfNumber setText(""); showData(); } else { sql="delete from student where StuNumber='"+be+"'";.
Forex Groups - Tips on Trading
Related article:
http://aspjavavbc.bokee.com/viewdiary.18684008.html
comments | Add comment | Report as Spam
|