Select MySQL Driver from Add Library menu.Ĭlick OK and run your program. Now look for MySQL JDBC Driver. Select that driver and add. html, servlet etc choose New from the same menu. Right click on your project name –> Properties. Also, to add new files like. Choose Java Web –> Web Application. Now you will see a list of files in the left pane. I had been using JDBC in swings previously. Now open NetBeans and create a new Application. Once the installation is done, it’s time to configure JDBC. Setup again was a breeze and require minimum number of clicks. Once done with this, a GUI wizard will start and will guide you for the rest of the setup. sh file, simply open terminal and type the following : Here are some steps to configure JDBC on Netbeans on Ubuntu. (You can download it from here and choose Linux(圆4/x86) version) I had Oracle 10g installed on my desktop but wasn’t able to get the database connected.īut things were working just fine on my net book(Ubuntu) I prefer Ubuntu for programming for the sole reason that setting up things on it is easy and quick ! As we are using Netbeans IDE at our college, I first installed it on Ubuntu. I had been trying Servlet program on my desktop and it worked fine until I had to add database connectivity to it. To start with, I have two systems, a Core i5 desktop running Windows 7 (64 bit) and an Atom Net book running Windows 8 + Ubuntu 12.04. However while working on something larger you should set up special folder for any external resources ("lib") and either manage linking to your project through IDE or with Ant or Maven configuration files (which IDE basically does for you on background).This is my first, to do, geeky post, hope this should help you all. If you creating just simple application you can keep JAR file in same directory as your source code for easy compiling. Putting anything in default Java installation directory is bad idea. Well for some back end processing i am using JAVA( NetBeans ) and PHP to create WEB UI in my project. I didn't see the all threads thats y i adopt only the first one solution but now its clear to me. Now the jar file in library folder of my project's folder. So, i also undo the option to save jar file in C:\Program Files\Java\jdk1.6.0_14\jre\lib\ext to enable DRIVER in my application. Yes peter, you are absolutely right, its not good practice to alter default editors folders. ("Database connection terminated") Ĭatch (Exception e) String url = "jdbc:mysql://localhost:3306/test" Ĭlass.forName("").newInstance() Ĭonn = DriverManager.getConnection(url, userName, password) String password = "" //change it to your password String userName = "root" //change it to your username Java MysqlTest -cp mysql-connector-java-5.0.8-bin.jarĬhange the name of the application and driver name in regards what you have. Javac MysqlTest.java -cp mysql-connector-java-5.0.8-bin.jar To beat this either set classpath or use following in command prompt/line //compile I need to restart the system to verify whether i wrote the right location for linux.Because i m working on windows right now.so forgive and work yourself to find the exact location ,but trust me i think i wrote the right y your self.Īhh hell, I forgot about connector and it dependency on classpath. " /usr/rohitsharmahome/lib/jvm/default-java/jre/lib/ext " On the following location.i m giving the location where i put it It will gonna work fine after this.create stattement object and Secondly when you will deploy your connectivity code into anĪpplication, then u will have to save the connectorĭeployed application will seek connector on this location. Our editors will seek connector on the above locationīut for deployed application read below. Simply paste the " mysql-connector-java-3.0.17-ga-bin.jar "įile over the above location relative to your machine.Īfter this execute the code it will gonna work fine. (You can get this file easily downloadable on Internet, Search by Here is the solution for this for windows If you will simply install the mysql and run the above code Mysql is installed by default on port 3306 This code on execution will create a database named payroll1. Stmt.executeUpdate("CREATE DATABASE payroll1") String url ="jdbc:mysql://localhost:3306/mysql" Ĭonnection con = DriverManager.getConnection(url,"root", "") I m done with its solution and writing the steps i followed. While connecting Java application to the mysql.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |