在Java中实现Oracle的增删改查

sid="+sid.getText()); rset.close(); sql_stmt.close(); conn.close(); } sid.setText(""); sname.setText(""); sage.setText(""); scity.setText(""); } if(e.getSource()==button_alter) { area.setText(""); int id = 0; while (rset.next()) { id=rset.getInt("sid"); } if(id!=Integer.parseInt(sid.getText())) { JOptionPane.showMessageDialog(null, " No Message! ","JDBC ",JOptionPane.ERROR_MESSAGE); sid.setText(""); } else { rset = sql_stmt.executeQuery("update student set sname='"+sname.getText()+ "', sage="+sage.getText()+", scity='"+scity.getText()+"' where sid="+sid.getText()); String str="ID:"+sid.getText()+"\n Name:"+sname.getText()+"\n Age:"+sage.getText()+"\n Sity:"+scity.getText(); area.append(str); rset.close(); sql_stmt.close(); conn.close(); } sid.setText(""); sname.setText(""); sage.setText(""); scity.setText(""); } } catch (SQLException e1) { e1.printStackTrace(); } } public static void main(String[] args) throws SQLException { new JDBCExam(); } }
this.setDefaultCloseOperation( EXIT_ON_CLOSE); this.setVisible(true); } public void actionPerformed(ActionEvent e){ OracleDataSource ods = null; try { ods = new OracleDataSource(); ods.setURL("jdbc:oracle:thin:system/niit@192.168.4.20:1521:orcl"); Connection conn = ods.getConnection(); Statement sql_stmt = conn.createStatement(); ResultSet rset = sql_stmt.executeQuery("SELECT sid FROM student where sid="+sid.getText()); if(e.getSource()==button_add) { area.setText(""); int id = 0; while (rset.next()) { id=rset.getInt("sid"); } if(id==Integer.parseInt(sid.getText())) { JOptionPane.showMessageDialog(null, " Has exists ","JDBC ",JOptionPane.ERROR_MESSAGE); sid.setText(""); } else { rset = sql_stmt.executeQuery("insert into student values("+sid.getText()+",'" +sname.getText()+"',"+sage.getText()+",'"+scity.getText()+"')"); String str="ID:"+sid.getText()+"\n Name:"+sname.getText()+"\n Age:"+sage.getText()+"\n Sity:"+scity.getText(); area.append(str); rset.close();
批注本地保存成功开通会员云端永久保存去开通
import import import import import
java.awt.*; java.awt.event.*; java.sql.*; javax.swing.*; oracle.jdbc.pool.OracleDataSource;
@SuppressWarnings("serial") public class JDBCExam extends JFrame implements ActionListener{ private JTextArea area; private JButton button_add,button_search,button_delete,button_alter; private JLabel label_sid,label_sname,label_sage,label_scity; priபைடு நூலகம்ate JTextField sid,sname,sage,scity; public JDBCExam() { super("JDBC"); this.setSize(480,360); this.setLocationRelativeTo( null); this.setLayout(new GridLayout(1,2)); area=new JTextArea(); this.add(area); Container content=getContentPane(); content.add(new JScrollPane(area),BorderLayout.CENTER); area.setEditable(false); JPanel panel =new JPanel(new GridLayout(6,1)); this.add(panel); JPanel panel_id=new JPanel(new GridLayout(2,1)); panel.add(panel_id); JPanel panel_name= new JPanel(new GridLayout(2,1)); panel.add(panel_name); JPanel panel_age=new JPanel(new GridLayout(2,1)); panel.add(panel_age); JPanel panel_city= new JPanel(new GridLayout(2,1)); panel.add(panel_city); label_sid=new JLabel("ID:"); label_sname=new JLabel("NAME:"); label_sage=new JLabel("AGE:"); label_scity=new JLabel("CITY:"); sid=new JTextField(); sname=new JTextField(); sage=new JTextField(); scity=new JTextField(); panel_id.add(label_sid); panel_id.add(sid); panel_name.add(label_sname); panel_name.add(sname); panel_age.add(label_sage); panel_age.add(sage); panel_city.add(label_scity); panel_city.add(scity); button_add=new JButton("ADD");
sql_stmt.close(); conn.close(); } sid.setText(""); sname.setText(""); sage.setText(""); scity.setText(""); } if(e.getSource()==button_search) { area.setText(""); int id = 0; while (rset.next()) { id=rset.getInt("sid"); } if(id!=Integer.parseInt(sid.getText())) { JOptionPane.showMessageDialog(null, " No Message! ","JDBC ",JOptionPane.ERROR_MESSAGE); sid.setText(""); } else { rset = sql_stmt.executeQuery("SELECT sname,sage,scity FROM student where sid="+sid.getText()); while (rset.next()) { sname.setText(rset.getString("sname")); sage.setText(""+rset.getInt("sage")); scity.setText(rset.getString("scity")); } String str="ID:"+sid.getText()+"\n Name:"+sname.getText()+"\n Age:"+sage.getText()+"\n Sity:"+scity.getText(); area.append(str); } } if(e.getSource()==button_delete) { area.setText(""); int id = 0; while (rset.next()) { id=rset.getInt("sid"); } if(id!=Integer.parseInt(sid.getText())) { JOptionPane.showMessageDialog(null, " No Message! ","JDBC ",JOptionPane.ERROR_MESSAGE); sid.setText(""); } else { rset = sql_stmt.executeQuery("delete from student where
button_add.addActionListener( this); button_search=new JButton("SEARCH"); button_search.addActionListener( this); button_delete=new JButton("DELETE"); button_delete.addActionListener( this); button_alter=new JButton("UPDATE"); button_alter.addActionListener( this); JPanel panel_button1= new JPanel(new GridLayout(2,1)); panel.add(panel_button1); JPanel panel_button2= new JPanel(new GridLayout(2,1)); panel.add(panel_button2); panel_button1.add(button_add); panel_button1.add(button_search); panel_button1.add(button_delete); panel_button1.add(button_alter);