1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
|
public class TestJdbc extends JFrame{
public static void main(String args[])throws Exception
{
String url = "jdbc:mysql://localhost/ter";
String user = "root";
String pass= "";
String query = "SELECT nom,img,tag FROM image INNER JOIN tags ON image.rowid = tags.tid;";
Class.forName("org.gjt.mm.mysql.Driver");
Connection con = DriverManager.getConnection
( url, user, pass );
Statement stmt = con.createStatement ();
ResultSet rs = stmt.executeQuery (query);
while(rs.next())
{
System.out.println(rs.getString(1)+"\n"+rs.getString(2)+"\n"+rs.getString(3));
}
rs.close();
stmt.close();
con.close();
}
} |
Partager