Cioè io posso creare un database da zero facendo:
codice:
package web;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Main {
public static void main(String[] args) throws Exception
{
Class.forName("org.sqlite.JDBC");
Connection c = DriverManager.getConnection("jdbc:sqlite:prova1.db");
Statement s = c.createStatement();
//s.executeUpdate("create table pagecount(url VARCHAR(100) PRIMARY KEY, count INTEGER)");
//s.executeUpdate("insert into pagecount values('index.jsp',3)");
//s.executeUpdate("insert into pagecount values('pag1.jsp', 2)");
ResultSet rs = s.executeQuery("select * from pagecount");
while(rs.next())
{
String url = rs.getString("url");
Integer count = rs.getInt("count");
System.out.println(url+" --> "+count);
}
s.close();
c.close();
}
}
ma se ho già un database creato con Mysql, come devo fare per far capire ad Eclipse che si deve collegare a quel database ?