import java.sql.*;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.awt.geom.Line2D;
import java.awt.Graphics2D;
import java.sql.Statement;
import java.applet.*;
import java.awt.*;
public class ConnectSQLite extends Applet
{
int x;
float y;
Graphics gr;
Connection connection = null;
ResultSet resultSet = null;
Statement statement = null;
@Override
public void init()
{
try
{
Class.forName("org.sqlite.JDBC");
connection = DriverManager.getConnection("jdbc:sqlite:///home/foss/Desktop//roads.db");
statement = connection.createStatement();
resultSet = statement
.executeQuery("SELECT * FROM coord");
}
catch (Exception e)
{
javax.swing.JOptionPane.showMessageDialog(null,e);
}
}
@Override
public void paint(Graphics g)
{
super.paintComponents(g);
try{
while (resultSet.next())
{
//omit this while running as i have procided the out put of this as the testdata.
System.out.println("id:"+ resultSet.getString("id"));
System.out.println("minX:"+ resultSet.getString("minX"));
System.out.println("minY:"+ resultSet.getString("minY"));
System.out.println("minX:"+ resultSet.getString("maxX"));
System.out.println("minY:"+ resultSet.getString("maxY"));
double x1=Double.parseDouble(resultSet.getString("minX"));
double y1=Double.parseDouble(resultSet.getString("minY"));
double x2=Double.parseDouble(resultSet.getString("maxX"));
double y2=Double.parseDouble(resultSet.getString("maxY"));
BasicStroke ll=new BasicStroke(1);
Graphics2D g2=(Graphics2D)g;
g2.setStroke(ll);
//this function doesnt work for me as i wanted plz provide me with a appropriate value for my test data.
g2.scale(2.0,2.0);
g2.draw(new Line2D.Double(x1, y1, x2, y2));
}
}
catch(Exception e)
{
javax.swing.JOptionPane.showMessageDialog(null,e);
}
}
}