Retrieve values from database using views
hi.........
I have a huge database so i have created views in database where i am selecting only the columns which are required.
As my front end is java swings i want to retrieve data from that created views and display on form . I am trying to do so but its giving me error .
So can u plz help???????
Can u tell me how to retrieve data from views?
plz help
thanks
in advance.
View Answers
February 10, 2012 at 3:38 PM
import java.awt.*;
import java.sql.*;
import java.util.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.table.*;
public class JTableDatabase{
public static void main(String[] args) {
JLabel lab1=new JLabel("Field1");
final JTextField text1=new JTextField(10);
JLabel lab2=new JLabel("Field2");
final JTextField text2=new JTextField(10);
JPanel panel=new JPanel(new GridLayout(3,2));
JButton b=new JButton("View");
panel.add(lab1);
panel.add(text1);
panel.add(lab2);
panel.add(text2);
panel.add(b);
b.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ev){
String v1=text1.getText();
String v2=text2.getText();
Vector columnNames = new Vector();
Vector data = new Vector();
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root" );
String sql = "Select "+v1+","+v2+" from data";
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery( sql );
ResultSetMetaData md = rs.getMetaData();
int columns = md.getColumnCount();
for (int i = 1; i <= columns; i++) {
columnNames.addElement( md.getColumnName(i) );
}
while(rs.next()){
Vector row = new Vector(columns);
for (int i = 1; i <= columns; i++){
row.addElement( rs.getObject(i) );
}
data.addElement( row );
}
rs.close();
stmt.close();
}
catch(Exception e){
System.out.println(e);
}
JTable table = new JTable(data, columnNames);
JScrollPane scrollPane = new JScrollPane( table );
JPanel p=new JPanel();
p.add( scrollPane );
JFrame fr=new JFrame();
fr.add(p);
fr.setSize(500,200);
fr.setVisible(true);
}
});
JFrame f=new JFrame();
f.add(panel);
f.pack();
f.setVisible(true);
}
}
Ads
Related Tutorials/Questions & Answers:
Retrieve values from database using views
Retrieve values from database using views hi.........
I have a huge
database so i have created
views in
database where i am selecting only...
from that created
views and display on form . I am trying to do so but its
retrieve data from database using jsf
retrieve data
from database using jsf Hello
I want an example of source code to
retrieve data
from database
i have a
database (oracle) name as db1...),, name ,and city
I want after enter value in textbox according idauthor i
retrieve
Advertisements
retrieve related data from database using jsp and mysql
retrieve related data
from database using jsp and mysql Hi sir,
please give some example of jsp code for retrieving mysql
database values in multiple dropdown list. if we change a value in a dropdown its related value must
how to display values from database into table using jsp
how to display
values from database into table
using jsp I want to display
values from database into table based on condition in query, how... the
values from database based on the bookname or authorname entered must be display
retrieve data from database with hyperlink
retrieve data
from database with hyperlink sir....i have one table called 'name' having two
values i have to
retrieve those data with a hyperlink... have
values
C
C++
i have to
retrieve and if i click C its sub categories should
retrieve from database........
retrieve from database........ <p>hi i am not able to
retrieve string
from database to a text box in web page my code is as follows:-</p>...("username");
re=stmt.executeQuery("select *
from userreg where username='"+username
edit values of database using jsp
edit
values of
database using jsp hi i want a code to edit the row
from tye
database and display in a page which containd radio buttons and drop down boxes
using jsp code
edit values of database using jsp
edit
values of
database using jsp hi i want a code to edit the row
from tye
database and display in a page which containd radio buttons and drop down boxes
using jsp code
How to retrieve image from database in Servlet?
How to
retrieve image
from database in Servlet? Hi,
How to
retrieve image
from database in Servlet?
Thanks
Hi,
Please check the tutorial
Retrieve image
from database using Servlet.
Thanks
How to retrieve image from database
How to
retrieve image
from database hi........
How to
retrieve image
from database when it is stored.
I have stored image in postgresql and want to
retrieve in java form.
Can u tel me hw to do?
I am trying n able to do also
get values from Excel to database
get
values from Excel to database hi i want to insert
values from Excel file into database.Whatever field and contents are there in excel file that should go to
database which exists. am
using SQL Server management studio
How to retrieve blob image from database in JSP?
the blog image
from database.
How to
retrieve blob image
from database in JSP?
Hi,
Please check the tutorial
Retrieve image
from database using...How to
retrieve blob image
from database in JSP? Hello,
JSP is used
How to store and retrieve image from database in JSP?
the image. Check this example:
Retrieve image
from database using Servlet.
Thanks...How to store and
retrieve image
from database in JSP? Hi,
In one... and
retrieve image
from database in JSP?
Thanks
HI,
You can use
How to retrieve image from mysql database in JSP?
How to
retrieve image
from mysql
database in JSP? Hi,
I need JSP... to
retrieve image
from mysql
database in JSP?
Thanks
Hi,
You can write SQL query to find the data
from database and get the image
from resultset
using