Question

Can anybody help me out with Java program

Answer 1

what is your problem?

Answer 2

For database connections you need to make sure the JDBC is connected with ODBC.

Answer 3

you need to post your file path into ODBC under "System files."

Answer 4

import java.sql.*;
import java.io.*;
import javax.media.opengl.GL;
import javax.media.opengl.GLAutoDrawable;
class JdbcDemo1
{
Connection con;
Statement stmt;
ResultSet rs;

JdbcDemo1()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

con = DriverManager.getConnection( "Jdbc:Odbc:access", "","");

stmt = con.createStatement();

rs = stmt.executeQuery("SELECT * From Items");
while (rs.next())
{
String d = rs.getString("Description");
String u = rs.getString("UPC code");
//int s = rs.getInt("age");
System.out.println("Description: "+d + " UPC Code: " + u);
}

//System.out.println(i);


stmt.executeUpdate("INSERT INTO Items (Description, [UPC code]) VALUES ('Colombian', '101')");

}
catch(SQLException e)
{
System.out.println("Hello World!"+e);
}

catch(ClassNotFoundException e)
{
System.out.println("purni"+e);
}
}
}

class JdbcDemo
{

public static void main(String args[])
{
new JdbcDemo1();
}
}

Answer 5

k..

Answer 6

some of the code isn't needed, but this is basically what you need.

Answer 7

it needs to check the database exists, and you need SQL commands to process it.

Answer 8

oh i am not getting the one u told reg odbc tat u told

Answer 9

?

Answer 10

i have till now written the code which contains set of bean class and the managed beam class which performs the addition of 2 numbers.

Answer 11

now I have the jsp file for user interface

Answer 12

hmmokay lets see.

Answer 13

jsp file? or jar?

Answer 14

jsp file for user interface

Answer 15

now i want create a command promt for user to enter those 2 numbers

Answer 16

and result i want to desplay back in panel

Answer 17

I know question is very basic... but we are not able make the interaction between user interface and java code written

Answer 18

as we are new to this not able to understand most of your teminology used like odbc and all

Answer 19

you said you wanted a database...? For that you need the ODBC:JDBC which is Open Database Connectivity: Java Database Connectivity

Answer 20

Not sure why you ened JSP, this is for the web?

Answer 21

basically if you want to make a GUI you should use Swing.

Answer 22

JSP is for the web, so if you want that then go for it. I've never used JSp tho.

Answer 23

Swing??

Answer 24

now you say command prompt you could throw up a dialog box to add 2 numbers together.

Swing/AWT/FX are the names of the GUI Java types.

Answer 25

AWT is oldschool windows, SWing is newer and fancier, and FX is balling :).

Answer 26

Also why do you need beans?

Answer 27

k... the thing is tat i am not able to form right quetion

Answer 28

anyways i will tell my prob statement

Answer 29

can you post the code you have as well?

Answer 30

package mBLogin;

import toL.AddTo;
import wrapperLogin.Add_Wrapper;

public class AddMB {

private Integer Int1;
private Integer Int2;
public Integer getInt1() {
return Int1;
}
public void setInt1(Integer int1) {
this.Int1 = int1;
}
public Integer getInt2() {
return Int2;
}
public void setInt2(Integer int2) {
this.Int2 = int2;
}




public String addInts() throws Exception{
AddTo addTO=new AddTo();
addTO.setInt1(this.getInt1());
addTO.setInt2(this.getInt2());
Add_Wrapper wrapper = new Add_Wrapper();

Integer Result = wrapper.addIntegers(addTO);

System.out.println("The sum of the 2numbers is:"+Result);
return "Success";




}


}

Answer 31

It seems like your'e missing some code, and Idk what those imports are, or why they are needed.

Answer 32

YOu are on the right track, but basically you would want to throw up a dialog or some other sort of thing like a Jtextfield in which the user enters the value, and then you grab the value using Integer.parseInt(String);

Answer 33

actually there are 3 seperate classes in whihc it is done

Answer 34

may be our approach is wrong because we did not know how to start

Answer 35

I'll ask again, is this for the web, or for client side?

Answer 36

Jsp is for the web.

Answer 37

YOu could also make an applet.

Answer 38

k... let me form the problem statement ,,, u can guide us how to proceed

Answer 39

we have some stub api classes which performs addition ,substraction or some more operations.We want to create an user panel asking for the list of operations possible

Answer 40

user can choose one of them in the user interface. So for instance he chooses addition. We should give panel interface asking for 2 inputs to enter

Answer 41

does he click a button or what?

Answer 42

and again is this web or client side?

Answer 43

client side

Answer 44

ok so you dont' need JSp at all, nor do you need a bean.

Answer 45

Basically you would need to create the GUI itself(I personally like Netbeans because there is a gui form where you can build the gui components).

Answer 46

no need of database also??

Answer 47

I don't think so, unless you are storing something into the fields....

Answer 48

like result of operations and all

Answer 49

then you could pop up a dialog box asking them to input numbers, either 1 dialog per # or something like a ',' comma to delimeter.

Answer 50

will there be some interface libraries between gui panel and java code

Answer 51

Just the normal java ones.

Answer 52

nothing fancy needed.

Answer 53

private javax.swing.JTextField C1;
private javax.swing.JButton Calculate;
private javax.swing.JLabel Cart;

Answer 54

are a few I used.

Answer 55

do you any sample similar form done with u already.we will sue it as reference

Answer 56

oh ok....

Answer 57

go download netbeans, and go check out their sample gui form.

Answer 58

ok

Answer 59

will downlaod and do check out... Thanks very much for support

Answer 60

np come back when you have some more questions.

Answer 61

ya sure thanks

Answer 62

yup yup.