Untitled

import java.sql.DriverManager;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.ResultSetMetaData;public class ZyppCacheSearch{	private static final String FILENAME = "/var/cache/zypp/zypp.db";	public static void main(String... args) throws Exception	{		if (args.length < 1)		{			System.err.println("Usage: ZyppCacheSearch <Searchterm>");			System.exit(1);		}		System.out.println("Connecting to libzypp cache");		Class.forName("org.sqlite.JDBC");		Connection conn = DriverManager.getConnection("jdbc:sqlite:" + FILENAME);		System.out.println("Initializing queries");		PreparedStatement stmt = conn.prepareStatement("SELECT p.name,p.version,p.release,r.alias,t.name FROM resolvables p JOIN repositories r ON p.repository_id = r.id JOIN types t ON p.arch = t.id WHERE p.name LIKE ?");		System.out.println("Executing query");		stmt.setString(1,"%" + args[0] + "%");		ResultSet results = stmt.executeQuery();		System.out.println("Name\tVersion\tRelease\tRepository\tArch");		while (results.next())		{			System.out.println(results.getString(1) + "\t" + results.getString(2) + "\t" + results.getString(3) + "\t" + results.getString(4) + "\t" + results.getString(5));		}		conn.close();	}}