{{include_html javaApplet_html, "!kakutou"}} grant { permission java.net.URLPermission "http://blue-red.ddo.jp/~ao/-"; permission java.net.URLPermission "https://blue-red.ddo.jp/~ao/-"; }; {{category2 プログラミング言語,Java}} http://d.hatena.ne.jp/funatake/20100210/1265811725 http://d.hatena.ne.jp/funatake/20100210/1265811725 http://d.hatena.ne.jp/funatake/20100210/1265811725 aaa {{div_begin class="pre"}} aaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa {{div_end}} aaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaa {{code Java,2 import java.sql.*; import SQLite.*; public class SQLiteHello { public static void main(String[] args) { try { Class.forName("SQLite.JDBCDriver"); Connection c = DriverManager.getConnection("jdbc:sqlite:/testdatabase"); //これを入れない場合は、コミットしなくてもコネクションを切れば自動でコミットされるそうな。 c.setAutoCommit(false); Statement st = c.createStatement(); //INSERTなどのクエリを実行する場合は、こんなふうに。 //int rc = st.executeUpdate( "insert into testtable values(2,'Hello','World')" ); ResultSet rs = st.executeQuery( "select col1, col2, col3 from testtable" ); while ( rs.next() ) { int i = rs.getInt(1); String s1 = rs.getString(2); String s2 = rs.getString(3); System.out.println( i + " :" + s1 + s2 ); } rs.close(); st.close(); c.commit(); c.close(); } catch (java.lang.Exception e) { e.printStackTrace(); System.exit(0); } } } }} {{code Text,2 aaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa ssssssssssssssssssssssssssssssssssssssssssssssssss aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaassssssssssssssssssssssssssssssssssssss aaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa ssssssssssssssssssssssssssssssssssssssssssssssssss aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaassssssssssssssssssssssssssssssssssssss }} aaaaaa bbbbbb cccccc {{br}} :aaaa:bbbbbbccccccc ,a,b,c ,a,b,c ,{{include_html html_nbsp}} ,& , aaaa aaaa {{include_html html_nbsp}} :aa:aaa dddd aaaaa {{include_html html test}}