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



Home Answers Viewqa Applet Applet to database error
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Valli
Applet to database error
0 Answer(s)      4 years and 6 months ago
Posted in : Applet


Hi...
I had an application where i need to connect to the database for the values to display in the applet....
Following is a part of that...
The code works fine in the local system..
but when its not working over the net..
When i placed this in the server,
The local system is displaying null values as the result...

<code>
public class circuit extends Applet implements MouseListener{
boolean rect1Clicked,rect1Clicked1,mouseEntered;
RTextLine text = new RTextLine();
Connection con=null;
Statement stmt,stmt1,stmt3;
ResultSet rs,rs2;
String str1,str2,str3,str4,s1,str5,str6;

public void init(){

setBackground(Color.black);
addMouseListener(this);
text.setDrawingComponent(this);

try{

Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb","username","password";);
stmt=con.createStatement();
stmt1=con.createStatement();
stmt3=con.createStatement();



}
catch(Exception e){
e.printStackTrace();
}



}

public void mouseClicked (MouseEvent me) {

int xpos= me.getX();
int ypos= me.getY();


if(xpos>=25 && xpos<=35 && ypos>=540 && ypos<=645)
{
s1="Feeder";
rect1Clicked=true;

}
else
rect1Clicked = false;
res(s1);
repaint();
}
public void paint(Graphics g) {
....Some Painting Lines Code Here....
if (rect1Clicked)
{

g.setColor(Color.red);
g.drawString("("+str1+", ",80,690);
...Some Painting Lines Code Here...
}
public void res(String s) {
try{
str1=null;;
String mid=null;

ResultSet rs3=stmt3.executeQuery("select mid from table1 where lname='"+s+"';");
if(rs3.next()){

mid=rs3.getString("mid");

}
ResultSet rs = stmt1.executeQuery("select Frequency,RPhaseVoltage,ActivePower from mydb.instantaneousdata where meterid='"+meterid+"';");
rs2 = stmt.executeQuery("SELECT ActiveExportTotal,StartDate,StartTime FROM mydb.energysnapshotdata where mid='"+mid+"';");

while(rs.next()){
str1 = rs.getString("Frequency");
str2 = rs.getString("RPhaseVoltage");
str3= rs.getString("ActivePower");


}
while(rs2.next())
{
str4=rs2.getString("ActiveExportTotal");
str5= rs2.getString("StartDate");
str6= rs2.getString("StartTime");
}

}
catch(Exception e){


}
}
}
</code>


This is my code....

There r some code left which i didn't included in the above code...as it is a very large code which isn't necessary for finding the error...
as itz only drawing strings or lines...

PLs help..
thanx in advance

Advertisement
View Answers

Related Tutorials/Questions & Answers:
Applet to database error - Applet
Applet to database error  Hi... I had an application where i need to connect to the database for the values to display in the applet.... Following... Applet implements MouseListener{ boolean rect1Clicked,rect1Clicked1,mouseEntered
Applet Error - Applet
Applet Error  Hi... I had an application where i designed an applet to get the database values into the applet when i clicked a line... It works... Applet implements MouseListener{ boolean
Advertisements
Applet database access - Applet
Applet database access  HI... I'm having an applet where we should display the database values in the applet... It works fine in the local system... but when its in the server, we r getting null values in the local system.. I
applet security error - Applet
applet security error  HI, Thanks for your reply. In the sample plugin code, the URL(nspluginurl) you have specified is for netscape navigator. ------------ ----------- Can you please tell me the same for IE url
applet security error - Security
applet security error  hi, i am using netbeans 6.0,apache tomcat server. I implemented the applet in my jsp page using plugin. when i execute my jsp page, the following security error occured. ERROR: Java Plug
java compilation error - Applet
java compilation error  I am getting compilation error in the following code.: public void paint(Graphics g) { switch(screen...; } } Error is: Illegal start of expression Plz. find why am I getting this error
java compilation error - Applet
java compilation error  hi friends the following is the awt front design program error, give me the replay E:\ramesh>javac product.java Note: product.java uses or overrides a deprecated API. Note
how to access database in applet
how to access database in applet  HI... I'm having an applet where we should display the database values in the applet... It works fine in the local... in java.security but came error below... java.sql.SQLException: JZ006: Caught IOException
java applet run time error - Applet
java applet run time error  Hi, Im new to java applet.please help me. i have create a MPEG movie player in applet. when i run that program it show the error that,"javax.media.NoPlayerException: Error instantiating class
error in compiling j2me apllication - Applet
error in compiling j2me apllication  hi, in my j2me application for video,m getting only the audio.i ll send the code. package src.video_streaming; import javax.microedition.media.Manager; import
how to add database in Java Applet
to add database in Java Applet below this code is my applet source code . thank...how to add database in Java Applet  hi every java master or Java... Applet implements ActionListener{ TextField
error while running the applet - Java Beginners
error while running the applet  import java.applet.Applet; import...); ++num; } } } } i have problem while running the code , error... prompt. You will be got definitily your output in a applet viewer. Thanks
error log and send Database
error log and send Database  hi my requirement is validate xml and xsd in java.If there is an errors then i will log error and store into error table. so plz if any one knows send code urgent. error table details
Database error - WebSevices
Database error  Hello, How i connect my database file& tables to Zend library file Using PHP language. In which library file i should change that code. Any one know the exact changes. Tell me.   http
connection database error
connection database error  import java.awt.EventQueue; // import packages import java.awt.event.ActionEvent; import java.awt.event.ActionListener...;which type of error occurs? Specify it. Is NWIND is your dsn
error oracle database connection?
error oracle database connection?  hi now i am trying to connect oracle database and also insert my data into table, but it's not working.. I created one user registration form. when i give values in the form, i want stored data
Database Error - Hibernate
Database Error  Hi, I am working with Struts 1.2---- AJAX-----Hibernate 3.0 --- MySQL 5.0. At the time of inserting/fetching from Database... exceeded; try restarting transaction That means the database becomes locked. Can
java database error - JDBC
java database error  hi all i am writing one swing application where i want to insert data into database(MS-Access) but dont know how to do... the following code to insert the data into MS-Access database: import java.sql.
Oracle Database error - JDBC
Oracle Database error   String query11 = "SELECT product_code, product_quantity, price FROM o"+orderid; ResultSet rs11 = stmt.executeQuery(query11); while(rs11.next()){ product_code[j
applet connected to table in MS Access database
applet connected to table in MS Access database   i have connected my java code with the MS access database and this is my code, can anyone tell me how to show the table in an applet...pls import java.sql.
error in accessing database - JSP-Servlet
error in accessing database  hiiii im tanushri im tryng to connect my database to the servlet i hv succeeded in connectivity but im stuck to nother error called Got minus one from read call although i hv feeded data to my
Applet
Applet  Write an applet to display a string in an applet. String should be passed as a parameter to an applet
Applet
Applet  Give the class hierarchy of an Applet class
applet
applet  Explain different stages in the lifecycle of an applet with figure.   Stages of Applet: Life cycle of an Applet: init(): This method is called to initialized an applet start(): This method is called after
Applet
Applet  how to run an applet on a web browser
applet
applet  What is the immediate superclass of the Applet class
Applet
Applet  Write a ava applet that sets blue color foreground and yellow color background at the start of an applet
Applet
Applet  Explain the start() and stop() methods of applet life cycle.   Start and Start method of Applet Life Cycle Start () method: The start method of an applet is called after the initialization method init
Display error message if data is already inserted in database
Display error message if data is already inserted in database   Display error message if data is already inserted in database Pls help me Thanks
Applet
Applet  I have a java applet that has a button. On clicking the button it should disappear and another applet should appear. How to write this code???? Also in login applet after successful login it should display admin applet
Applet
Applet  Write a short note on applet life cycle
 

 

 

DMCA.com