public<\/span> void<\/span> initTables<\/span>()<\/span> {<\/span><\/div> Statement<\/span> statement1<\/span> =<\/span> null<\/span>;<\/span><\/div> PreparedStatement<\/span> statement2<\/span> =<\/span> null<\/span>;<\/span><\/div> <\/div>
try<\/span> {<\/span> <\/div> statement1<\/span> =<\/span> connection<\/span>.<\/span>createStatement<\/span>();<\/span> <\/div> statement1<\/span>.<\/span>execute<\/span>(<\/span>"create table people(name varchar(40) not null, age int)"<\/span>);<\/span><\/div> connection<\/span>.<\/span>commit<\/span>();<\/span><\/div> <\/div>
statement2<\/span> =<\/span> connection<\/span>.<\/span>prepareStatement<\/span>(<\/span>"insert into people values (?, ?)"<\/span>);<\/span><\/div> statement2<\/span>.<\/span>setString<\/span>(<\/span>1<\/span>,<\/span> "foo"<\/span>);<\/span><\/div> statement2<\/span>.<\/span>setInt<\/span>(<\/span>2<\/span>,<\/span> 20<\/span>);<\/span><\/div> statement2<\/span>.<\/span>executeUpdate<\/span>();<\/span><\/div> connection<\/span>.<\/span>commit<\/span>();<\/span><\/div> <\/div>
}<\/span> catch<\/span> (<\/span>SQLException<\/span> sqle<\/span>)<\/span> {<\/span><\/div> sqle<\/span>.<\/span>printStackTrace<\/span>();<\/span><\/div> <\/div>
}<\/span> finally<\/span> {<\/span><\/div> try<\/span> {<\/span><\/div> statement1<\/span>.<\/span>close<\/span>();<\/span><\/div> statement2<\/span>.<\/span>close<\/span>();<\/span><\/div> <\/div>
}<\/span> catch<\/span> (<\/span>SQLException<\/span> e<\/span>)<\/span> {<\/span><\/div> e<\/span>.<\/span>printStackTrace<\/span>();<\/span><\/div> }<\/span><\/div> }<\/span><\/div>}<\/span><\/div><\/pre><\/div>\n \n <\/div>\n\n