· 10 years ago · Jul 05, 2016, 12:27 PM
1public 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
19CREATE TABLE IF NOT EXISTS