next »

[jurka]

In my current project i need to make database which can be used by Swing clients. So i didn't know any better solution then to use php $_GET variable for sending data from Java. If anyone has better ideas how to do this, then i am waiting for your post. I don't got any mysql table or any custom server, it all has to be free.

add.php

Code

GeSHi (php):
<?php
    define('EOL', "\n<br />");
 
    if (isset($_GET['name']) && isset($_GET['result'])
          && isset($_GET['field'])) {
 
        $array = array($_GET['name'], $_GET['result'], $_GET['field']);
        $fieldSizes = array(60, 60, 30);
 
        for ($i = 0 ; $i < count($array) ; $i++) {
            if (strlen($array[$i]) < $fieldSizes[$i]) {
                $remove = array('\n', '\r', '\t');
                $return = trim(htmlspecialchars(str_replace($remove, "", $array[$i])));
 
                $array[$i] = $return;
            } else {
                exit();
            }
        }
 
        //$line = $array[0] ."•". $array[1] ."•". $array[2];
        echo $line;
        require_once('TextFunctions.php');
        $t = new TextFunctions();
        $t->write_file($line);
    }
 
 
?>
 
//read.php
 
<?php
require_once('TextFunctions.php');
 
$t = new TextFunctions();
//$t->write_file("Kaiki");
//        print_r($t->read_file());
echo $t->read_file();
//        echo("Koik on korras");
?>
 
//TextFunctions.php
<?php
    class TextFunctions
    {
        var $filename;
 
        function TextFunctions( $_filename = 'tekst.txt') {
            $this->filename = $_filename;
        }
 
        function read_file() {
            if (is_readable($this->filename)) {
                $fp = fopen($this->filename, 'r');
                $array = array();
 
                while (!feof($fp)) {
                    $array .= fread($fp, 1024 * 4);
 
                }
                fclose($fp);
                return $array;
            } else {
                die("File is not readable!");
            }
        }
 
        function write_file($line) {
            if (is_writable($this->filename)) {
                $fp = fopen($this->filename, 'a');
 
                if (flock($fp, LOCK_EX)) {
                    fwrite($fp, $line ."\r\n", 1024 * 4);
                    flock($fp, LOCK_UN);
                    fclose($fp);
                } else {
                    die('Couldn\'t open or lock file!');
                }
            } else {
                die('You cant write in this fail!');
            }
 
        }
}
 
?>
 
 
Created by GeSHI 1.0.7.20

Code

GeSHi (java):
 
package applettesting;
 
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.net.MalformedURLException;
import java.net.URL;
import java.util.logging.Level;
import java.util.logging.Logger;
 
/**
 *
 * @author Risto
 */
public class DataReader {
 
    public void makeConnection(String site) {
        try {
            URL url = new URL(site);
            BufferedReader in;
            String inputLine;
 
            in = new BufferedReader(new InputStreamReader(url.openStream()));
 
            while ((inputLine = in.readLine()) != null) {
                System.out.println(inputLine);
            }
 
            in.close();
        } catch (MalformedURLException ex) {
            Logger.getLogger(DataReader.class.getName()).log(Level.SEVERE, null, ex);
        } catch (IOException ex) {
                Logger.getLogger(DataReader.class.getName()).log(Level.SEVERE, null, ex);
        }
 
    }
}
 
 
Created by GeSHI 1.0.7.20

Usage in java

Code

GeSHi (java):
        DataReader d = new DataReader();
        d.makeConnection("http://localhost/PHPproj/web/read.php");
 
        //lets add another entry
        d.makeConnection("http://localhost/PHPproj/web/add.php?name=Manni&field=programming&result=12121");
 
 
Created by GeSHI 1.0.7.20

[Arkie]

Uhm, what about using the JDBC to connect to a database? I'm no PHP coder but this doesn't seem right. You can use insert queries using:

Code

GeSHi (java):
Connection connect = getConnection();
Statement stmt = connect.createStatement();
String sqlStatement = "Your sql statement here";
stmt.executeUpdate(sqlStatement );
...
stmt.close();
con.close();
Created by GeSHI 1.0.7.20

[jurka]

yes but i cant use online any databases so i only got php safe mode to use.

[Arkie]

yes but i cant use online any databases so i only got php safe mode to use.

Well, how are you storing your data now? and what exactly do you want to do?

[jurka]

Basically it's internet database which can be accessed anywhere, not elegant solution, but should work if you don't have much data. I am going to use this example for hiscore.

I have added a graph for explanation.

[Arkie]

Basically it's internet database which can be accessed anywhere, not elegant solution, but should work if you don't have much data. I am going to use this example for hiscore.

I have added a graph for explanation.

I don't think there is a direct way to write a textfile from a java client to a file on the http server without ftp access but i've looked around and found this article that might help you: http://www.devdaily.com/java/edu/pj/pj010023/ but then again they are doing (almost) the same as you are doing now but instead of letting the php file manage the writing they are using a cgi script.

But it's pretty interesting to try to find a better way to write it to the http server, ill look into it when i have the time and write a demo.

ps: Happy new year!

[jurka]

Basically it's internet database which can be accessed anywhere, not elegant solution, but should work if you don't have much data. I am going to use this example for hiscore.

I have added a graph for explanation.

I don't think there is a direct way to write a textfile from a java client to a file on the http server without ftp access but i've looked around and found this article that might help you: http://www.devdaily.com/java/edu/pj/pj010023/ but then again they are doing (almost) the same as you are doing now but instead of letting the php file manage the writing they are using a cgi script.

But it's pretty interesting to try to find a better way to write it to the http server, ill look into it when i have the time and write a demo.

ps: Happy new year!

Happy new year to all who reads this !

I haven't found any good free hosts who would support mysql, this would give much wider possibilities. Searching and returning result would be used much more effectively, but due to the Estonian host providers there is no mysql support. :(

[Arkie]

What about installing a webserver including php/mysql etc on your local machine? With xampp all you need  to do is to install it and u have your own webserver http://sourceforge.net/projects/xampp/

[jurka]

What about installing a webserver including php/mysql etc on your local machine? With xampp all you need  to do is to install it and u have your own webserver http://sourceforge.net/projects/xampp/

Yeah this would be solution but i got problems with porting, because there is no open port so i have to pay for to get open ports.

[priya_gurnani166]

actualy i need help
i m making a software in java swing
i hv a problem in retriving values from database in JTable,
i m inserting values in database ms access it works,
following is my code one is for database another one for table
...
import java.sql.*;
public class JDta
{
public void putz(String x,String y)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:pproject","","");
PreparedStatement stmt=con.prepareStatement("insert into data values(?,?)");
stmt.setString(1,x);
stmt.setString(2,y);
stmt.executeUpdate();
stmt.close();
con.close();
}
catch(Exception er)
{
}
}

public boolean checking(String x,String y)
{
int coun=0;
boolean bb;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:exams","","");
PreparedStatement stmt=con.prepareStatement("select * from data where name=? and pass=?");
stmt.setString(1,x);
stmt.setString(2,y);
ResultSet rs=stmt.executeQuery();
while(rs.next())
{
coun++;
}
stmt.close();
con.close();
}
catch(Exception er)
{
}
if(coun>0)
bb=true;
else
bb=false;
return bb;
}
}
...
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
class Logger extends JFrame implements ActionListener
{
JButton jb1,jb2;
JLabel jl1,jl2,jl3;
JTextField jtf;
JPasswordField jp;
String x;
String y;
public Logger()
{
jl1=new JLabel("<html><center><font face=Maiandra GD size=5>Welcome to<p>School Management System</font></html>");
Container cont=getContentPane();
jl2=new JLabel("Enter Name");
jl3=new JLabel("Enter Password");
JPanel jpp=new JPanel();
jpp.setLayout(null);
jtf=new JTextField(10);
jp=new JPasswordField(10);
jpp.add(jl1);
jpp.add(jl2);
jpp.add(jl3);
jpp.add(jtf);
jpp.add(jp);
jb1=new JButton("Save");
jb1.addActionListener(this);
jpp.add(jb1);
jl1.setBounds(80,5,300,80);
jl2.setBounds(100,75,120,10);
jl3.setBounds(100,78,300,80);
jtf.setBounds(205,75,120,20);
jp.setBounds(205,105,120,20);
jb1.setBounds(205,135,70,29);
cont.add(jpp);
setTitle("Log In");
setSize(500,200);
setVisible(true);
}
public void actionPerformed(ActionEvent ae)
{
x=jtf.getText();
y=jp.getText();
JDta jxy=new JDta();
jxy.putting(x,y);
dispose();

}
public static void main(String aa[])
{
new Logger();
}
}
...

[Arkie]

actualy i need help
i m making a software in java swing
i hv a problem in retriving values from database in JTable,
i m inserting values in database ms access it works,
following is my code one is for database another one for table
...
code stripped
...

please make a new topic for your own question and don't make unrelevant posts in this topic. Thanks