mauricioadl

template para eclipse

Jul 8th, 2011
193
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 4.72 KB | None | 0 0
  1. <?xml version="1.0" encoding="UTF-8" standalone="no"?><templates><template autoinsert="true" context="java" deleted="false" description="create a callable block" enabled="true" name="callfunction">try {&#13;
  2.             Connection con = ConnectionFactory.getConnection();&#13;
  3.             CallableStatement cs = con&#13;
  4.                     .prepareCall("{? = CALL your_function_here(?,?,?)}");&#13;
  5.             int count = 1;&#13;
  6.             cs.registerOutParameter(count++, Types.VARCHAR);&#13;
  7.             cs.setString(count++, "java");&#13;
  8.             cs.setString(count++, "is");&#13;
  9.             cs.setString(count++, "easy");&#13;
  10.             cs.executeUpdate();&#13;
  11.             Object returnCall = cs.getObject(1);&#13;
  12.             con.close();&#13;
  13.         } catch (SQLException e) {&#13;
  14.             e.printStackTrace();&#13;
  15.         }&#13;
  16. ${:import(java.sql.Connection, java.sql.CallableStatement, java.sql.SQLException, java.sql.Types)}</template><template autoinsert="true" context="java" deleted="false" description="create a procedure block" enabled="true" name="callprocedure">try {&#13;
  17.             Connection con = ConnectionFactory.getConnection();&#13;
  18.             CallableStatement cs = con&#13;
  19.                     .prepareCall("{CALL your_procedure_here(?,?,?)}");&#13;
  20.             int count = 1;&#13;
  21.             cs.setString(count++, "java");&#13;
  22.             cs.setString(count++, "is");&#13;
  23.             cs.setString(count++, "easy");&#13;
  24.             cs.executeUpdate();&#13;
  25.             con.close();&#13;
  26.         } catch (SQLException e) {&#13;
  27.             e.printStackTrace();&#13;
  28.         }&#13;
  29. ${:import(java.sql.Connection, java.sql.CallableStatement, java.sql.SQLException)}</template><template autoinsert="true" context="java" deleted="false" description="create a message of error" enabled="true" name="errorpane">JOptionPane.showMessageDialog(null, "your message here", "title",&#13;
  30.                 JOptionPane.OK_OPTION);&#13;
  31. &#13;
  32. ${:import(javax.swing.JOptionPane)}</template><template autoinsert="true" context="java" deleted="false" description="create a block with scanner file reader" enabled="true" name="filereader">try {&#13;
  33.             Scanner scanner = new Scanner(new File("file.txt"));&#13;
  34.             while (scanner.hasNext()) {&#13;
  35.                 System.out.println(scanner.nextLine());&#13;
  36.             }&#13;
  37.             scanner.close();&#13;
  38.         } catch (IOException e) {&#13;
  39.             e.printStackTrace();&#13;
  40.         }&#13;
  41. ${:import(java.util.Scanner, java.io.File, java.io.IOException)}</template><template autoinsert="true" context="java" deleted="false" description="create block with FileWriter" enabled="true" name="filewriter">try {&#13;
  42.             FileWriter fw = new FileWriter(new File("file.txt"), true);&#13;
  43.             fw.append("insert your text here"&#13;
  44.                     + System.getProperty("line.separator"));&#13;
  45.             fw.flush();&#13;
  46.             fw.close();&#13;
  47.         } catch (IOException e) {&#13;
  48.             e.printStackTrace();&#13;
  49.         }&#13;
  50. ${:import(java.io.FileWriter, java.io.File, java.io.IOException)}</template><template autoinsert="true" context="java" deleted="false" description="create a insert block" enabled="true" name="insert">try {&#13;
  51.             Connection con = ConnectionFactory.getConnection();&#13;
  52.             PreparedStatement psmt = con&#13;
  53.                     .prepareStatement("INSERT INTO your_table VALUES (?,?,?,?)");&#13;
  54.             int count = 1;&#13;
  55.             psmt.setInt(count++, 0001);&#13;
  56.             psmt.setString(count++, "java");&#13;
  57.             psmt.setString(count++, "is");&#13;
  58.             psmt.setString(count++, "easy");&#13;
  59.             psmt.execute();&#13;
  60.             psmt.close();&#13;
  61.             con.close();&#13;
  62.         } catch (SQLException e) {&#13;
  63.             e.printStackTrace();&#13;
  64.         }&#13;
  65. ${:import(java.sql.Connection, java.sql.PreparedStatement, java.sql.SQLException)}&#13;
  66. &#13;
  67. </template><template autoinsert="true" context="java" deleted="false" description="create a select block" enabled="true" name="select">try {&#13;
  68.             Connection con = ConnectionFactory.getConnection();&#13;
  69.             PreparedStatement ps = con&#13;
  70.                     .prepareStatement("SELECT * FROM YOUR_TABLE_OR_YOUR_VIEW");&#13;
  71.             ResultSet rs = ps.executeQuery();&#13;
  72.             while (rs.next()) {&#13;
  73.                 System.out.println(rs.getObject(1));&#13;
  74.             }&#13;
  75.             rs.close();&#13;
  76.             ps.close();&#13;
  77.             con.close();&#13;
  78.         } catch (SQLException e) {&#13;
  79.             e.printStackTrace();&#13;
  80.         }&#13;
  81. ${:import(java.sql.Connection, java.sql.PreparedStatement, java.sql.SQLException, java.sql.ResultSet)}</template><template autoinsert="true" context="java" deleted="false" description="create a thread block " enabled="true" name="thread">Thread t = new Thread() {&#13;
  82.             @Override&#13;
  83.             public void run() {&#13;
  84.                 ${line_selection}${cursor}&#13;
  85.             }&#13;
  86.         };&#13;
  87.         t.start();</template><template autoinsert="false" context="java-statements" deleted="false" description="try catch block" enabled="true" id="org.eclipse.jdt.ui.templates.try" name="try">try {
  88.     ${line_selection}${cursor}
  89. } catch (${Exception} ${exception_variable_name}) {
  90.     // ${todo}: handle exception
  91. }</template></templates>
Advertisement
Add Comment
Please, Sign In to add comment