CODING EXPERT

 JFileChooser s;//creating object of JFileChoseor         s = new JFileChooser();        s.showOpenDialog(null);//opening dialog box        File F=s.getSelectedFile();//storing file to variable f        D.fp=F.getAbsolutePath();//storing file path to variable fp        path.setText(D.fp);//displaying path to textfield path

here now iam going to teach you how to import data to excel from database using java the code is the out put will be like

update tablename set fieldname=value where condition for example if i have a table h with field m to update the query will be update h set m='newvalue'(if its integer no single quates doesn't needed)

to install use the following command: sudo apt-get install mysql-server (make sure internet is active) to start using mysql use mysql -u root -p and enter password to install mysql in windows download mysql software downlode now and install by simply clicking it to uninstall mysql in ubantu use the command : sudo apt-get remove mysql-server  

(Ubuntu and Debian) Run the following command: sudo /etc/init.d/mysql stop (CentOS, Fedora, and Red Hat Enterprise Linux) Run the following command: sudo /etc/init.d/mysqld stop Start MySQL without a password Run the following command. The ampersand (&) at the end of the command is required. sudo mysqld_safe --skip-grant-tables & Connect to MySQL Run the following command: mysql -uroot Set a new MySQL root password Run the following command: use mysql; update user set password=PASSWORD("mynewpassword") where User='root'; flush privileges; quit Stop and start the MySQL service (Ubuntu and Debian) Run the following commands: sudo /etc/init.d/mysql stop ... sudo /etc/init.d/mysql start (CentOS, Fedora, and Red Hat Enterprise Linux) Run the following commands: sudo /etc/init.d/mysqld stop ... sudo /etc/init.d/mysqld start Log in to the database Test the new password by logging in to the database. mysql -u root -p

in this page i am going to tell you how to setup netbeans for jsp and creation of new project step1:first you need netbeans to install netbeans you will also need jdk for installing netbeans so install it frist  for ubantu type the following command in terminal make sure you are connected to internet command:           for Ubuntu go to download netbeans and you will get a tar file to install it goto terminal and the folder where the tar file is stored and use the following command:bash filename         for windows you can download the exe from download netbeans   and install it like a normal application  

               Excel To Mysql Database in this post i am going to tell you how to insert data from excel and export it to database the code is as follows you can see how i readed from an csv to an array and then i insert it to a database bufferedreader class is used to read data from the csv file D.p is the variable which holds the file path csv usually split columns using "," so split funtion is used to seperate the values from the column