Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JDBC JBBC ,MYSQL ND JAVA
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


anjuvijayan
JBBC ,MYSQL ND JAVA
2 Answer(s)      3 years and 9 months ago
Posted in : JDBC


import java.sql.*;
import javax.swing.JOptionPane;

public class NewJFrame extends javax.swing.JFrame {

Connection con=null;
 Statement st=null;
 ResultSet rs=null;

public NewJFrame() {
    initComponents();
}

private void initComponents() {


private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
    {
        try
            Class.forName("java.sql.Driver");
        con=DriverManager.getConnection("jdbc:mysql://localhost/ACCOUNT","root","ADMIN");
        st=con.createStatement();
        String query="SELECT * FROM BANK";
        rs=st.executeQuery(query);
        if(rs.next())

    {
            String n=rs.getString("name");
            String b=rs.getString("address");
             String s=rs.getString("phone");
             String t=rs.getString("branch");

    }
        else
        {
            JOptionPane.showMessageDialog(null,"no record");
        }

}
    }
    catch(Exception e)
    {
        JOptionPane.showMessageDialog(null,"error");
    }

CAN ANYONE HELP ME IN FINDING THE ERRORS IN DIS CODE AND WATS REALLY A PROBLEM WITH THIS?


Advertisement
View Answers

January 18, 2011 at 5:42 PM


Hi Friend,

We have modified your code, there were many errors.Try this:

import java.sql.*;
import javax.swing.*;
import java.awt.event.*;;

public class NewJFrame extends JFrame {
Connection con=null; 
Statement st=null;
ResultSet rs=null;

public NewJFrame() {
    initComponents();
}
private void initComponents() {
setLayout(null);
JButton b=new JButton("Retrieve");
b.setBounds(10,10,100,20);
add(b);
setSize(300,100);
setVisible(true);

b.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent evt) {
        try{
        Class.forName("com.mysql.jdbc.Driver");
        con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");
        st=con.createStatement();
        String query="SELECT * FROM employee";
        rs=st.executeQuery(query);
        int count=0;
        while(rs.next()){
            String n=rs.getString("name");
            String b=rs.getString("address");
            String s=rs.getString("contactNo");
            String t=rs.getString("email");
            System.out.println(n+" "+b+" "+s+" "+t);
            count++;
            }
            if(count<0){
            JOptionPane.showMessageDialog(null,"no record");
            }
        }
        catch(Exception e) {
        JOptionPane.showMessageDialog(null,"error"); 
        }
    }
});
}
public static void main(String[]args){
    new NewJFrame();
}
}

For more information, visit the following link:

JDBC Tutorial

Thanks



January 19, 2011 at 6:33 PM


thanks thankz... thnks a lot frnd.. actually dt code s printed in ma txt buk and wn i tryd to run on ma system oh god... wt to say full error... can u plz help me to design a gui programme with the help of d same.. i mean we'v to input data in a designed gui frame and d data which v input should get saved in a mysql table... plz if u've any such programmes kindly help me..



Related Tutorials/Questions & Answers:
JBBC ,MYSQL ND JAVA
JBBC ,MYSQL ND JAVA  import java.sql.*; import...:mysql://localhost/ACCOUNT","root","ADMIN"); st=con.createStatement...("com.mysql.jdbc.Driver"); con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test
write a program in java Adding up the subscript(st,nd,rd,th) to the number of days in a input string
write a program in java Adding up the subscript(st,nd,rd,th) to the number of days in a input string    write a program in java Adding up the subscript(st,nd,rd,th) to the number of days in a input string ex:If a user enters
Advertisements
JSP and XML .data store nd retrieve
JSP and XML .data store nd retrieve  I have made a form in jsp having emp id, projectname and emp name.I want to store data related to employee in xml file.How can i store data entered by user in XML file and later retrieve data
java-mysql
java-mysql  how i retrive all the values of a table in mysql to java forms or java table
Java and MySQL
Java and MySQL   I am doing a project on an accounting system. I need to know to things: How do I write reports using information in an MySQL database . How get multiple MySQL database rows and assign them to variables r
write a progam for bubble sort using file read nd write?
write a progam for bubble sort using file read nd write?  hi, please give the code
Java and Mysql
Java and Mysql  Sir, I want to connect my java program with mysql server (mysql server is situated on another windows machine ) ??? ???? ?????   Put mysql jar file in your jdk lib and set the classpath. After
mysql-java
mysql-java   i try to execute this code stmt1.executeUpdate("insert... the manual that corresponds to your MySQL server version for the right syntax to use...) at Mydb.main(Mydb.java:111) Java Result: 1 please help me to find the error  
java & mysql
java & mysql  I wrote the code as shown below, i am getting the error... to your MySQL server version for the right syntax to use near '' at line 1" my...("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql
java & mysql
java & mysql  I wrote the code as shown below, i am getting the error... to your MySQL server version for the right syntax to use near '' at line 1" my...("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql
java & mysql
java & mysql  I wrote the code as shown below, i am getting the error... to your MySQL server version for the right syntax to use near '' at line 1" my...("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql
java & mysql
java & mysql  I wrote the code as shown below, i am getting the error... to your MySQL server version for the right syntax to use near '' at line 1" my...("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql
java & mysql
java & mysql  I wrote the code as shown below, i am getting the error... to your MySQL server version for the right syntax to use near '' at line 1" my...("com.mysql.jdbc.Driver"); Connection con=DriverManager.getConnection("jdbc:mysql
java with mysql
java with mysql  Hi, Here is my code: import java.awt.*; import...=DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root","root...` VARCHAR(20) NOT NULL)"; con=DriverManager.getConnection("jdbc:mysql
MySql,java
MySql,java  In MySQL table i am adding the fields of name,photo,video,age,category.in the category i have some subjects.if one person login into my-site the he upload the one video under one subject.then i want the following
Java connectivity with MySQL
Java connectivity with MySQL  Java connectivity with MySQL
connection with MySQL to java.
connection with MySQL to java.   how to connect MySQL database with jsp
problem in adding a fullscreen frame nd adding a glass pane to it
problem in adding a fullscreen frame nd adding a glass pane to it  hi , here is my code import java.awt.*; import javax.swing.*; import java.awt.ToolKit; class MyFrame extends Jframe{ Container c; JPanel glass; MyFrame
JAVA & MYSQL - JDBC
JAVA & MYSQL  How can we take backup of MySQL 5.0 database by using...;Hi Friend, Please visit the following page for working example of MySQL backup. This may help you in solving your problem. www.roseindia.net/mysql/mysql
Mysql & java - JDBC
Mysql & java  Hi guys, please help! I'm new to mysql, I want to connect to mysql 5.1 using java. But it shows error about: Class.forName...) { System.out.println("MySQL Connect Example."); Connection conn = null
mysql jsp - Java Beginners
mysql jsp  how to insert values to mysql? i want to insert values from a combo box to mysql... how to perform that. pls help me in urgent.  Hi friend, Plz give full source code where you having the problem
jsp, mysql - Java Beginners
jsp, mysql  i want to store / insert the selected value in the combo box (jsp), into the mysql. how to do it?... pls help me in urgent
Connecting to MYSQL Database in Java
Connecting to MYSQL Database in Java  I've tried executing the code...("MySQL Connect Example."); Connection conn = null; String url = "jdbc:mysql://localhost/"; String dbName = "textbook"; String driver
mysql with jsp - Java Beginners
mysql with jsp  i wanted to insert a combo box value to mysql table usgin jsp. how to perform that. can anybody help me in urgent.  Hi friend, Code to help in solving the problem : Select
how to migrate java db to mysql
how to migrate java db to mysql  I have an aplication,for migrating java db to mysql db.how it will done
jsp mysql
........... like that all requests nd comments should be display through jsp and mysql...jsp mysql  actually i want a page that has two frames nd in 1 frame i'l add a textarea to post some help nd nw when he clicks on post button it has
MYSQL Java Connector Library
Where to download the MYSQL Java Connector Library and get the jar file This article discuss 'how to connect Java and MYSQL using MYSQL connector' in Java. The article will give you view on downloading and installing MYSQL Java
Java-mysql coding - Java Beginners
Java-mysql coding  Dear Sir, Suppose I have Employee master file in Mysql table format & I want to update that file thru JavaSwing Input format... employee joins, his master details are putted in Java-Swing Form, how I can insert
jdbc driver for mysql - Java Beginners
jdbc driver for mysql  I need jdbc driver program for connecting java progrma to mysql. Please any one send me the url to download the driver... of jdbc-mysql database connectivity and idea about jdbc and mysql driver
mysql
you need to download the mysql-connector jar file for connecting java program from mysql database.......   Hi friend, MySQL is open source database... is the link for the page from where you can understand how to Download and Install MySQL
Mysql Date To Java Date
Mysql Date To Java Date       Mysql Date To Java Date retrieve the records from Mysql and display... 'Mysql Date To Java Date'. To understand and grasp the example we create a table
Advertisements
 

 

 

DMCA.com