Hello everyone.
I have a problem I have searched too much but I can't solve this. I am using netbeans and I have an oracle database. This is my first time to connect an application with a database. Simply, I have a form at netbeans and a table at database.
http://www.imagetoo.com/images/ss1ksk.png[
^] In here I have 2 textboxes and a combobox whic has 2 items (administrator and instructor). I want to code under the add button. Namely, I want to save user name password and its role in a table. Here I have created a table.
http://www.imagetoo.com/images/ss2mdm.png[
^]
I am noob guys, please help me. If you teach me how to insert I will develop delete update etc.
//UPDATE// here is my button code
try {
Connection con=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection(
"jdbc:oracle:thin:@AND ALSO HERE:1521:O10G",
"plsql_staj",
"plsql_staj1");
Statement s=con.createStatement();
s.execute("INSERT INTO E_USER VALUES(""I HAVE PROBLEM HERE")");
s.close();
con.close();
}
catch(ClassNotFoundException | SQLException e){}
Thanks.