stn3Ua60

1import java.sql.Connection;
2import java.sql.DatabaseMetaData;
3import java.sql.DriverManager;
4import java.sql.ResultSet;
5import java.sql.ResultSetMetaData;
6import java.sql.SQLException;
7import java.sql.Statement;
8
9public class SQLliteMain {
10
11	public static void main(String[] args) {
12		final String url ="klienci.db";
13		System.out.println("Nawiazuje polaczenie z baza "+url+"...");
14		try {
15			Connection con = DriverManager.getConnection("jdbc:sqlite:"+url);
16			System.out.println("OK");
17			
18			try(Statement st = con.createStatement()){
19				ResultSet res = st.executeQuery("select * from wojewodztwa");
20				
21//				st.execute("insert into wojewodztwa(nazwa) values('Mazowieckie')");
22//				res = st.executeQuery("select * from wojewodztwa");
23//				while(res.next()) {
24//					System.out.println(res.getString(2));
25//				}
26				
27//				String createSQL = "create table if not exists faktury("+
28//				"idfak integer primary key,"+
29//						"idzam integer not null,"+
30//				"val integer not null)";
31//				
32//				st.execute(createSQL);
33				
34				Statement fakSt = con.createStatement();
35				ResultSet fakRs = fakSt.executeQuery("select * from faktury");
36				
37				
38				DatabaseMetaData dbmd = con.getMetaData();
39				ResultSet tables = dbmd.getTables(null, null, null, null);
40				while(tables.next()) {
41					System.out.println(tables.getString("TABLE_NAME"));
42				}
43				
44				System.out.println("---------------------------------");
45				
46				ResultSetMetaData rsmd = res.getMetaData();
47				int colCount = rsmd.getColumnCount();
48				for(int i=1;i<colCount;i++) {
49					System.out.println(rsmd.getColumnName(i));
50				}
51			}
52		}
53		catch (SQLException e) {
54			e.printStackTrace();
55		}
56	}
57
58}