sql - How to connect a java program to Derby in netbeans 7.2.1 -
im novice programmer , wanna know basic way connect java programme derby in netbeans 7.2.1. prof asked me create programme lets me add, delete, save, search , edit entries table. know how create gui java programme in netbeans , how create database on netbeans too. want know basic codes include in programme enable connect on database on netbeans 7.2.1. give thanks time reading question.
public void connection(){ try{ class.forname("org.apache.derby.jdbc.clientdriver"); string mydb = "jdbc:derby://localhost:1527/hwtrial"; connection dbconn = drivermanager.getconnection(mydb, "",""); s1 = dbconn.createstatement(resultset.type_scroll_sensitive, resultset.concur_updatable); result = s1.executequery("select * hwstud"); result.next(); result.last(); }catch(exception ex){ joptionpane.showmessagedialog(null,"cannot connect database", "error message", joptionpane.ok_option); }; }
the derby documentation contains first-class set of tutorials help started: http://db.apache.org/derby/docs/10.9/getstart/
java sql database derby
No comments:
Post a Comment