java coding

Ads

 
 
 

Share on Google+Share on Google+

Ocean Pearl
java coding
1 Answer(s)      5 years and 3 months ago
Posted in : JDBC

can any one plez tell me how to retrive a row from access to each field of swing... i hav tried this but i am getting an SQL error "SQLExceptionOccurred[Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect".....

if(jTextField1.getText().equals(""))

{
    JOptionPane.showMessageDialog(null,"Please enter the Student name to be search","Error",0);
}
else
{
    try
    {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection con=DriverManager.getConnection("jdbc:odbc:college");
        Statement stm=con.createStatement();
        ResultSet rs=stm.executeQuery("select * from demo where name=?");
      while(rs.next())
      {


           String address1=rs.getString("address");
            String name=rs.getString("name");


        jTextArea1.setText(address1);
        jTextField1.setText(name);

      }  



        JOptionPane.showMessageDialog(null,"Searched Successfully");

        rs.close();
        stm.close();
        con.close();
    }
    catch(SQLException sqlex)
 {
     System.out.println("SQLExceptionOccurred"+sqlex.getMessage());
 }
 catch(ClassNotFoundException cnfex)
 {
     System.out.println("ClassNotFoundExceptionOccurred"+cnfex.getMessage());
 }

}

plez help me................:-(

Ads
View Answers

February 14, 2012 at 1:13 PM


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

class FormDemo{
    public static void main(String[]args){
    JFrame f=new JFrame();
    JPanel panel;
    JLabel label1,label2;
    final JTextField text1,text2;
    label1 = new JLabel();
    label1.setText("Name:");
    text1 = new JTextField(20);

    label2 = new JLabel();
    label2.setText("Address:");
    text2 = new JTextField(20);


    panel=new JPanel(new GridLayout(2,2));
    panel.add(label1);
    panel.add(text1);
    panel.add(label2);
    panel.add(text2);
    f.add(panel);
    try{
        String name=JOptionPane.showInputDialog(null,"Please enter the Student name to be search");

         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
         Connection con=DriverManager.getConnection("jdbc:odbc:college");

            Statement st=conn.createStatement();
            ResultSet rs=st.executeQuery("select * from data where name='"+name+"'");
            while(rs.next()){
            text1.setText(rs.getString("name"));
            text2.setText(rs.getString("address"));
            }
      }
    catch(Exception e){}
    f.pack();
    f.setVisible(true);
    }
    }

Ads









Related Tutorials/Questions & Answers:
Java Coding
Java Coding  Hello, Can u please tel me how to improve my coding techniques.I am feeling difficulty with coding but I am perfect with my theory part
coding in java
coding in java  write a code to calculate the product of odd integers from 1-15   class ProductOfOddIntegers { public static void main(String[] args) { long product=1; for(int i=1;i<=15;i
Advertisements
java coding
java coding  Hi sir, WRITE A PROGRAMME TO MAKE EMPLOYMENT MANAGMENT HAVING COLORS AND FRAME IN IT,???? CAN U SUGGEST ME HOW TO MAKE IT IN CORE JAVA
java coding
java coding  sir i need code for how to send meg from one system to another system
java coding
java coding  i am using netbean to my project and it is Desktop Application.i want my textfield to accept only numbers or only alphabets .........plez plez plez do help me..........i am just beginner to java codes
java coding
java coding  i need to to a project in java and the title is file parsing. i need to read a file or if a particular file is given i have to count the no of vowels, pick out some terms, and to display the details about that file
java coding
java coding  Hai,I am having order table in mysql database.when user click download button the order table data shows in csv format.Its very urgent.please help me. Thanks in advance
java coding
java coding  i have source code for my project virtual classroom. i need a little guidance to run that code..do help me out
java coding
java coding  using swing i want to give an exit button which on clicking ask a msg "JOptionPane" is select "yes" then it should exit or else not....plez help me...... JOptionPane.showConfirmDialog(null,"DO YOU REALLY WANT
JAVA coding
JAVA coding  using classes and arrays implement the following create classes, inheritance, object and execute methods. there are 5 students in a class, capture the surname, first name, age and sex. capture their marks of a given
java coding
java coding  plz correct this one ....i want to retrive data row from databse ...all its working but for combobox it not.......plz plz plz help me...... private void jButton4ActionPerformed(java.awt.event.ActionEvent evt
java coding
java coding  can any one plez tell me how to retrive a row from access to each field of swing... i hav tried this but i am getting an SQL error "SQLExceptionOccurred[Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect
java coding
java coding  (person, student,employee, faculty and staff are classes) design a class named person and its two subclasses named student and employee    class Person { public String name; public String address; public
Java coding - WebSevices
Java coding for web services  How to start Java Coding for web services
java coding - Java Beginners
java coding  dear sir, i'm doing a java coding using with netbeans ide, so i'm trying to pass some text from one jframe to another jframe which is both are already opend on screen then how to do it? please send me
Image using Java coding
Image using Java coding  Hai, Display image in pdf file using Java coding through Xsl file.. Please help me.. xsl file generate the pdf file
color coding in java
color coding in java  hii..can anyone please help with auto coloring code in java swings..??a particular text field should have a particular color for a particular event..plzz help
coding - Java Beginners
coding  i need to start coding but i don't know how to start it so plz help me  Hi Friend, Please visit the following link: http://www.roseindia.net/java/ Thanks
single frame coding in java
single frame coding in java  sir, i am a beginner in java.i want to do a desktop application in java in which a single frame satisfies all needs.but i want changes in that frame only.how can i solve this?i think multiple frames
Coding - Java Beginners
Coding  How to do a coding to view employee name, salary and EPF. The EPF is calculated from the salary like 10% from their salary. and it also show... the technologies you create the application in Java/JSP/Servlet/JSF/Struts
coding - Java Beginners
coding  i need start coding but don't have any idea to start plz help me
coding related - Java Beginners
coding related  what is the purpose of using these line in a program? char units = args[1].charAt(0); units = Character.toUpperCase.../java/java-conversion
java coding - Java Beginners
java coding  how to create a window that contain a list of all files of specified directory
coding problem - Java Beginners
coding problem  hi friend! Im new to jasper reports.how can i start that coding inorder to generate reports.can u send some sample programs for reporting?im badly need some clearly mentioned example because im new to jasper
Java Coding - Java Beginners
Java Coding  Code a for loop that adds the integers that are multiples of 5 starting with 50 and ending with 5. Each time the sum is increased, print it on a line at the console. Be sure to declare and initialize any required
j2me coding - Java Magazine
in sms using j2me. i have a problem in coding for sending and receiving sms .i have a coding for receiving sms but it not work because that program need sending... a coding for sending and receiving sms in j2me
Java Coding - Java Beginners
Java Coding  What is the meaning of following statement in Java? Clasname objectname = another_object_name.method_name; The Example Code is Given Below public void sessionCreated(HttpSessionEvent sessionEvent
Java Coding - Java Beginners
Java Coding  How do I code the following: Code a while loop that calculates the sum of the integers that are multiples of 5 starting with 5... on Java visit to : http://www.roseindia.net/java/ Thanks
Java Coding - Java Beginners
Java Coding  Code a private static method named printMessage that accepts a String parameter that represents the message. The method should simply print the message followed by a blank line at the console. Write a statement
Java Coding - Java Beginners
Java Coding  Code nested for loops that calculate the area of a rectangle that can range in size from a length and width of 1 to a length and width of 10. Print the area for each width for a given length on a single line
Java Coding - Java Beginners
Java Coding  Two overloading methods that returns average using following headers A) public static int average(int[] array) B) public static double average(double[] array The program should prompt the user to enter
Tutorials   
Java Spring Hibernate Struts Training java.lang.classnotfoundexception com.mysql.jdbc.driver how to retrieve text and images from mysql database and show on html page using jsp servlet How to install Neo4j on Ubuntu 15.10? please help me in these prog MYSQL - mysql copy table to another table example by creating new table solution for mapping hibernate and pojos from net beans through database Connect GWT application with Oracle inventory System of Medical Store inventory System of Medical Store inventory System of Medical Store inventory System of Medical Store This code have created jTable that connected with a database.every cell of last column have a button.But this button doesn't work properly.Where is the error java program Java Database Program jdbc Database connection class in a live project ..?? What is JDBC architecture? Unable to Create DSN for excel to ms access importing data and edit that data Database Scrolling Buttons how to use foreign key in java How to delete content of a log file from linux terminal? JSP-Oracle connectivity Student Management System Java code for Saving Marathi (Indian local language ) in Mysql and retrieving the same crud operations with foreign key constraint. I really need help with this assignment question Please help me out Please Backup Failed Mysqldump Got Errno 28 On Write Upgrade MySQL 5.1 to 5.5 in cpanel mysqldump all databases com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jpa.sequence' doesn't exist persistence xml class element persistence.xml for MySQL MySQL JDBC Driver pom dependency code Blob column jdk6 and oracle 8i connexion oracle 8i et jdk6 java [ cannot retrive date from sql ] why?? Order Entry System How to threow timeout exception when DB is not responding How to threow timeout exception when DB is not responding This is the employee form to add data to mysql database but I got error of NullPointerException, Is this write code please give me feedback as soon as possible make a method which takes user name & pwd as parameter & validate them against the database. If the corresponding user exist return true otherwise false. prabhakar validating credentials and displaying error message in login .jsp if not valid JDBC jdbc jdbc code register servlet vibhu

Ads

 
Advertisement null

Ads