Advertisement
Guest User

Untitled

a guest
Jul 5th, 2016
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. public void widgetSelected(SelectionEvent e) {
  2. try
  3. {
  4. Class.forName("oracle.jdbc.driver.OracleDriver");
  5. Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","nikshay");
  6. Statement stmt=con.createStatement();
  7. stmt.executeUpdate("create table sbase(person varchar(20),year number(2),gender varchar(1))");
  8. PreparedStatement prepare=con.prepareStatement("insert into sbase (person,year,gender)values(?,?,?)");
  9. prepare.setString(1,text.getText());
  10. prepare.setString(2,text_1.getText());
  11. prepare.setString(3,text_2.getText());
  12. prepare.executeUpdate();
  13. }
  14. catch(Exception ex)
  15. {
  16. }
  17. }
  18.  
  19. CREATE TABLE IF NOT EXISTS
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement