Connect to MySQL-database

1,247 Recognized Expert Top Contributor

Hey there,
Is it possible to let a java-applet read from and write to a mysql-database?
Or should I find a way to work around this?

Yarr

Nov 14 '07 #1

Subscribe Reply

1828

r035198x

13,262

MVP

Hey there,
Is it possible to let a java-applet read from and write to a mysql-database?
Or should I find a way to work around this?

Yarr

Why not use JSP/Servlet for this if you have a web application that you want to connect to the database.

Nov 14 '07 #2

YarrOfDoom

1,247

Recognized Expert Top Contributor

Why not use JSP/Servlet for this if you have a web application that you want to connect to the database.

Because I don't now what that is :D

Nov 14 '07 #3

YarrOfDoom

1,247

Recognized Expert Top Contributor

I've looked it up and JSP isn't quite suitable for what I had in mind. If it helps: I'm trying to create an applet to display images of which the paths and displayed info are stored in a database. My applet would have some buttons, which if clicked will get the applet to get/store data from the database and renew the content of some of the displayed items. The thing is, I don't want the webpage to be reloaded every time a button is clicked.

Yarr

Nov 14 '07 #4

r035198x

13,262

MVP

I've looked it up and JSP isn't quite suitable for what I had in mind. If it helps: I'm trying to create an applet to display images of which the paths and displayed info are stored in a database. My applet would have some buttons, which if clicked will get the applet to get/store data from the database and renew the content of some of the displayed items. The thing is, I don't want the webpage to be reloaded every time a button is clicked.

Yarr

All that can be done by JSPs of course with a bit of AJAX for the no reloading part.
If you want to stick to applets, you'd need to note that by default applets do not have access to databases (security), so you'll need to sign your applet accordingly and give it access to the database. The rest of it is just playing around with JDBC.

Nov 15 '07 #5

comando2929

New Member

I was tring something very similar a while back. I wanted a high score system for my Tetris but had a hell of a time tring a sign just a test applet. After a few days of struggling I ended up using a http connect function to a specific php page that would write the score into the database. I know, a little round about, but it works. Depending on how much activity you are panning on handling, something like that should work. An because it's not actualy a live connection to the database, signing is not necisary.

Nov 15 '07 #6

Similar topics

4777

Connect to MySQL

by: Mr Dygi | last post by:

Hi, PHP 4.3.4 installed manually from package *.zip and Apache 2. I have a problem with this simple code: <?php $link = mysql_connect("127.0.0.1","","") or die("Could not connect: " ....

PHP

5299

No connect - error 111

by: Figmo | last post by:

I have MySQL 4 running on a Win2K3 Server. I can connect to it from MySQL Control Center running on a client PC on our network. But I cannot connect to it from the outside world. Get the "can't...

MySQL Database

8994

Can't connect to remote host (10061)

by: Ryan Stewart | last post by:

I'm running MySQL server on a WinXP box at home. I have a cable modem/router. I've set up port forwarding on port 3306 to the machine running MySQL. I can connect locally just fine, but when I try...

MySQL Database

17787

MySQL-error : can't connect to local mysql server through socket

by: Pugi! | last post by:

On a freshly installed Fedora C3 (incl. webserver apache php mysql) i get the following problem when connecting to mysql through a browser (phpMyAdmin): : #2002 Can't connect to local MySQL...

MySQL Database

2729

Can not connect mysql from php

by: xiuchuanli | last post by:

I install Fedora 4 with web server, after that I installed mysql 5.0.15. Now I can connect to mysql from command line and mysql-administrator and mysql-query-browser. But when I try to test to...

MySQL Database

1811

can not connect mysql from php

by: xiuchuanli | last post by:

I install Fedora 4 with web server, after that I installed mysql 5.0.15. Now I can connect to mysql from command line and mysql-administrator and mysql-query-browser. But when I try to test to...

MySQL Database

4487

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

by: linux | last post by:

Sorry if this is a really dumb question. I am trying to connect to our remote MySQL server (which is running just fine). I have a perl script which worked just fine on my other Fedora 4 box (all...

MySQL Database

3831

Cannot connect to MySQL DB remotely

by: Ike | last post by:

Through Java, I am attempting to connect to a MySQL 4.12 server on a remote computer. I can connect fine via php. I cann connect fine via Java, through a servlet, when the servlet is on the same...

MySQL Database

2615

MySQL server running, PHP can't connect

by: scorpionbilli | last post by:

Hi, The local mysql server is running on my Macbook. I can access it through the console client: $ mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL...

PHP

8692

Can't connect to local MySQL server through socket on Ubuntu.

by: sasimca007 | last post by:

Hi friends, I installed mysql in ubuntu but, i don't know how to connect to that mysql. Actually we connect to postgresql by psql command, but when i tried to connect mysql with...

MySQL Database

7254

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7094

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

7519

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5079

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4743

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3218

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1585

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

796

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

452

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General