{{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 U4RBCIGS5hUkfWfctFWxRno4QVOOr4WcxNCf97wTSYCqSQkR1VWWdSzguy9uI1kNAUFK9rWGpTK3/1yY lfz8I7ZXh+jFPMM/NPaxaFOJPW6oaBwRRmr2ytBKYYy6BEo8QLyEH6lk+/Fo750+CNcPj4G3rCdLre6E QxrRD3Nv7L6TCRSQWnzVnIij4E+ll9zwPQieQ1oausSVvnixPV7epHG8wLRXUBhxZJr11S7DOVKI7ky+ K03Gi0X9gDUGugq3yRusiqYhEKPFtN0hhPNKaDG1wEdH4yHoOqOf0vthP72ystzKKsjSeCFTNp0pvCji tTMu+m7gqWzyyxSQgPkQrnH1+E60hzsu1qOa3yzRcVnfffr+P+T5/9DCjvONEb/74iunAHewyPz8FSYu iY8fkfKy+PX/OwkLj/30GSKzOzjvX9ITNv1FnJnwdL1RqvvVRZgTfwQKgkCQlYSSXRRnv+lDbGsqUJT8 ux5xZKs6LclWbsuCRFcvWkWuGsdxkNGpMkkRdu1MdCrSLGexTVWr2rAQVd/ewxMW8O5nycEwB67NeL0q ZEZpPz/IHZPdg1FLoZaBgZT5AVm13kv9gofAscZryWQdtZx37TTB3IQwn9GcjZjqnnf1YDc4GBHUXi36 B5gYwHlwjUpVjjnJiK5V0NDTyVA2GBSseccmoCPbuG9UqDn0WPmOcvCoKVkkpcCoaAgQ6N4JW/vtIEJ8 tcBfq/CQXmobcJRDWWRL+9Rvg2Dz6huLJWLIBZHyJkbOakQbkKPLXVVbvjTdPbFh6RXeBGMqvNp= {{include_html html test}}