About java and JDBC
Hello sir,
I am doing project on java thats on swings,and using the dbase as MSSQL.
what i want to know is i had created a name ,textfield ,calender(for DObirth selection),
this is displayed in GUI window.
Then i had created a table of Patient name ,DOBirth fields in MSSQL.Here assume three to four names are present.Has of now i had dispalyed a table in GUI window using jdbc-odbc separate program i had written.
Now what i want is after displaying only Patient name (label),and calender and search button,.By clicking the search after giving name and DOBirth, it has to display only according there respective Patient details how to achieve it sir.
Plz help me in this regard.
Thanks & Regards
Pradeep CBZ
View Answers
January 9, 2012 at 1:29 PM
import java.awt.*;
import java.sql.*;
import java.awt.event.*;
import javax.swing.*;
class DatePicker {
int month = java.util.Calendar.getInstance().get(java.util.Calendar.MONTH);
int year = java.util.Calendar.getInstance().get(java.util.Calendar.YEAR);;
JLabel l = new JLabel("", JLabel.CENTER);
String day = "";
JDialog d;
JButton[] button = new JButton[49];
public DatePicker(JFrame parent) {
d = new JDialog();
d.setModal(true);
String[] header = { "Sun", "Mon", "Tue", "Wed", "Thur", "Fri", "Sat" };
JPanel p1 = new JPanel(new GridLayout(7, 7));
p1.setPreferredSize(new Dimension(430, 120));
for (int x = 0; x < button.length; x++) {
final int selection = x;
button[x] = new JButton();
button[x].setFocusPainted(false);
button[x].setBackground(Color.white);
if (x > 6)
button[x].addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent ae) {
day = button[selection].getActionCommand();
d.dispose();
}
});
if (x < 7) {
button[x].setText(header[x]);
button[x].setForeground(Color.red);
}
p1.add(button[x]);
}
JPanel p2 = new JPanel(new GridLayout(1, 3));
JButton previous = new JButton("<< Previous");
previous.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent ae) {
month--;
displayDate();
}
});
p2.add(previous);
p2.add(l);
JButton next = new JButton("Next >>");
next.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent ae) {
month++;
displayDate();
}
});
p2.add(next);
d.add(p1, BorderLayout.CENTER);
d.add(p2, BorderLayout.SOUTH);
d.pack();
d.setLocationRelativeTo(parent);
displayDate();
d.setVisible(true);
}
public void displayDate() {
for (int x = 7; x < button.length; x++)
button[x].setText("");
java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat(
"MMMM yyyy");
java.util.Calendar cal = java.util.Calendar.getInstance();
cal.set(year, month, 1);
int dayOfWeek = cal.get(java.util.Calendar.DAY_OF_WEEK);
int daysInMonth = cal.getActualMaximum(java.util.Calendar.DAY_OF_MONTH);
for (int x = 6 + dayOfWeek, day = 1; day <= daysInMonth; x++, day++)
button[x].setText("" + day);
l.setText(sdf.format(cal.getTime()));
d.setTitle("Date Picker");
}
public String setPickedDate() {
if (day.equals(""))
return day;
java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat("dd-MM-yyyy");
java.util.Calendar cal = java.util.Calendar.getInstance();
cal.set(year, month, Integer.parseInt(day));
return sdf.format(cal.getTime());
}
}
January 9, 2012 at 1:29 PM
continue....
class SearchPatientInformation {
public static void main(String[] args) {
JLabel lab=new JLabel("Patient Name:");
JLabel label = new JLabel("Date of Birth:");
final JTextField t=new JTextField(20);
final JTextField text = new JTextField(20);
JButton b = new JButton("Search");
JPanel p = new JPanel(new GridLayout(3,2));
p.add(lab);
p.add(t);
p.add(label);
p.add(text);
p.add(b);
final JFrame f = new JFrame();
f.getContentPane().add(p);
f.pack();
f.setVisible(true);
text.addKeyListener(new KeyAdapter() {
public void keyPressed(KeyEvent ae) {
text.setText(new DatePicker(f).setPickedDate());
}
});
b.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
String name=t.getText();
String dob=text.getText();
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from patient where patientName='"+name+"' and dob='"+dob+"'");
String n="",d="",email="",address="";
int contact=0;
if(rs.next()){
n=rs.getString("patientName");
d=rs.getString("dob");
email=rs.getString("email");
address=rs.getString("address");
contact=rs.getInt("contactNo");
}
String data[]={n,address,Integer.toString(contact),email,d};
JFrame f=new JFrame();
JPanel p=new JPanel(new GridLayout(5,2));
String labels[]={"Patient Name","Address","Contact No","Email","Date Of Birth"};
JLabel l[]=new JLabel[5];
JTextField text[]=new JTextField[5];
for(int i=0;i<5;i++){
l[i]=new JLabel(labels[i]);
text[i]=new JTextField(20);
p.add(l[i]);
p.add(text[i]);
text[i].setText(data[i]);
text[i].setEnabled(false);
}
f.add(p);
f.setVisible(true);
f.pack();
}
catch(Exception ex){}
}
});
}
}
Related Tutorials/Questions & Answers:
About java and JDBCAbout java and JDBC Hello sir,
I am doing project on
java... in GUI window using
jdbc-odbc separate program i had written.
Now what i want...("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("
jdbc About java and JDBCAbout java and JDBC Hello sir,
I am doing project on
java... in GUI window using
jdbc-odbc separate program i had written.
Now what i want...("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("
jdbc Advertisements
about jdbc - JDBCabout jdbc Hello folks, I am very new
JDBC. I am doing a project on
java messaging service on the part of the project we are using
JDBC. In my project i am having two tables one is"person" table and other is"student" table
about jdbc - JDBCabout jdbc Hi folks, my previous question was when "i have a table with primary key then when i enter a value which is already there will cause a problem how to solve it." i know to retrieve all the attributes
About springs - JDBCAbout springs Hi,
My xml code is as follows :In this i have my id stored in results1(in tag).
And now
About JavaAbout Java Hi,
Can anyone tell me the
About Java programming language? How a c programmer can learn
Java development techniques?
Thanks
Hi,
Read
about java at http://www.roseindia.net/
java.
Thanks
About java About java how we insert our database data into the jTable in
java... in
java
Hi Friend,ADS_TO_REPLACE_1
Try the following code:
import... = DriverManager.getConnection("
jdbc:mysql://localhost:3306/test", "root", "root
about javaabout java how to get the value from the user like c, c++ program pls explain with example for me
JDBC ODBC Connection In JavaJDBC ODBC Connection In
Java
In this section we will read
about the various... a bridge between the
Java
Programming Language and the ODBC to use the
JDBC API... you
about how to
use the
JDBC API using
JDBC ODBC driver. In this example we
Java JDBC Java JDBC Is the
JDBC-ODBC Bridge multi-threaded
about jboss - Java Beginnersabout jboss can you please explain
about jboss...how to deploy,where the temp and lock is there...total information
about jboss to use in
java message services(JMS
about J2EE. - Java Beginnersabout J2EE. I know only core
Java ... what chapter I will be learn to know
about J2EE. Hi Friend,
Please visit the following link:
http://www.roseindia.net/
Thanks
java - JDBC these driver manager classes are belongs to Jdbcapi,What
about Odbc? Hi friend,
The
JDBC-ODBC Bridge uses synchronized methods to serialize all of the calls that it makes to ODBC. Multi-threaded
Java programs may use the Bridge
Java - JDBCJava and
JDBC programming Need to learn the kills to develop the application using
java and
jdbc Ask about javaAsk
about java Create a
java program for add and remove the details of a person, which is not using by database, a simply
java program.
If possible, please wil it in switch case
Java JDBCJava JDBC What is the fastest type of
JDBC driver
Java JDBCJava JDBC How to make pagination using
JDBC java - JDBC automatically loaded. The driver is loaded by calling the Class.forName() method.
JDBC drivers are designed to tell the DriverManager
about themselves automatically when... on
JDBC visit to :
http://www.roseindia.net/
jdbc/understanding-driver
about swings - Java Beginnersabout swings Dear sir,Good evening,
i am doing mca sir,i am doing the project in swings,so plz provide the material
about swings sir...:
http://www.roseindia.net/
java/example/
java/swing/
Hope
about c and java about c and
java i need
java and c language interview and objective questions with answers for the fresher.please provide to me
Please visit the following links:
http://www.roseindia.net/
java/
http
java servlets jdbc - JDBCjava servlets jdbc i am running the servlet program with
jdbc connections
in this porgram i used two 'esultset' objects.. in this wat ever coding is available in the first resultset is executed like updating and retrieiving
java - JDBCjava hello,
i have oracle 8i,i am a
java-learner, i would like to run a
jdbc programs.
please tell me the steps how to run the
jdbc program For the complete reference and tutorial on
Java Database Connectivity visit
about java - Java Beginnersabout java hello, being a begineer in
Java i would like know that as we read the value entered by user through cin>> in c++ how we did it with
java. Hi Friend,
There are lot of ways to input data.You can use
JAVA(JDBC) - JDBCJAVA(
JDBC) Hello friends, please tel me, how can we retrieve...";
String driverName = "com.mysql.jdbc.Driver";
String url = "
jdbc:mysql... for more information.
http://www.roseindia.net/
jdbc/save_image.shtml
about package - Java Beginnersabout package as i am programming a question based on creating own... in the root directory.In my system
java is installed in c:\ibm\java142\bin how can i run...://www.roseindia.net/
java/master-
java/
java-package.shtml
Hope
java - JDBC have to use
JDBC and oracle. plz send the details for connecting "
java... sending data inserting code into database using
JDBC with jsp... for database connectivity:
http://www.roseindia.net/
jdbc/
jdbc-mysql
about interface - Java Beginnersabout interface can anyone explain to me the implementation of the given line
Set si=new HashSet();
Problem is that Set is an interface...://www.roseindia.net/
java about array in javaabout array in java speed of a vehicle is measured using the total time and the distance by using the equation
given bellow
speed(km/hour)=distance...
Vehicle 02 = 5 hours
Write a
JAVA class to represent the Vehicle. The program should
about JAVA - Java Beginnersabout JAVA i have to create a program that will sort the given numbers using bubble sort. the user will enter the number of inputs as well...;
}
}
}
}
}
-------------------------------------------
Read for more information,
http://www.roseindia.net/
java about coding - Java Beginnersabout coding hello sir,
I want to create session expair, when user is not enter anything in login page session wil expair after 10 min.if user enter its go to success page.plz send me full code
about this.
thanks
java - JDBCjava how to get connectoin to database server from mysql through
java programme Hi Friend,
Please visit the following link for more detailed information
http://www.roseindia.net/
jdbc/
jdbc-mysql
About inheritanance in JAVAAbout inheritanance in JAVA What is need foe the Inheritance in though we can access any method of any class declared publicly in simple class calling
Java JDBCJava JDBC Is
JDBC-ODBC bridge multi-threaded? NO. The
JDBC-ODBC Bridge uses synchronized methods to serialize all of the calls made.... The
JDBC-ODBC Bridge uses synchronized methods to serialize all of the calls
about instance of javaabout instance of java 1> what is an instance
2> what is an object
3>what is difference between above two
Hi Friend,
An Instance creates the reference of an object.
An object is a run time entity
about JVM - Java Beginnersabout JVM Hello Rose india.net team
I want to ask that why JVM is platform dependent
is it automatically installs whenever we install jdk or is it automatically installed whenever we install operating system on our machine
Java jdbc class.forName error - JDBCJava jdbc class.forName error HI: how is possible that my
JDBC connection to an MYSQL instance works inside the IDE (Netbeans) and not when I start it from the jar file? Could some please give some pointers please? Higly
Java Example projects about STRUTSJava Example projects
about STRUTS Hai...
I completed MCA but i have no job in my hands.
But i do some small projects
about STRUTS.
Please send me some example projects
about STRUTS.
Please visit the following link
java - JDBCjava how can i connect
jdbc with oracle 9i.please give detailed procedure. Hi Friend,
Use
JDBC with Oracle
Follow these steps:
1) Import the following packages in your
java file:***********
import
about swing - Java Beginnersabout swing how implement a program of adding two numbers by entering two numbers separately by other user on the input dialog box and after that also show the result of the addition in other dialog box...
your regardly