Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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 {
- Connection con = ConnectionFactory.getConnection();
- CallableStatement cs = con
- .prepareCall("{? = CALL your_function_here(?,?,?)}");
- int count = 1;
- cs.registerOutParameter(count++, Types.VARCHAR);
- cs.setString(count++, "java");
- cs.setString(count++, "is");
- cs.setString(count++, "easy");
- cs.executeUpdate();
- Object returnCall = cs.getObject(1);
- con.close();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- ${: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 {
- Connection con = ConnectionFactory.getConnection();
- CallableStatement cs = con
- .prepareCall("{CALL your_procedure_here(?,?,?)}");
- int count = 1;
- cs.setString(count++, "java");
- cs.setString(count++, "is");
- cs.setString(count++, "easy");
- cs.executeUpdate();
- con.close();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- ${: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",
- JOptionPane.OK_OPTION);
-
- ${: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 {
- Scanner scanner = new Scanner(new File("file.txt"));
- while (scanner.hasNext()) {
- System.out.println(scanner.nextLine());
- }
- scanner.close();
- } catch (IOException e) {
- e.printStackTrace();
- }
- ${: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 {
- FileWriter fw = new FileWriter(new File("file.txt"), true);
- fw.append("insert your text here"
- + System.getProperty("line.separator"));
- fw.flush();
- fw.close();
- } catch (IOException e) {
- e.printStackTrace();
- }
- ${: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 {
- Connection con = ConnectionFactory.getConnection();
- PreparedStatement psmt = con
- .prepareStatement("INSERT INTO your_table VALUES (?,?,?,?)");
- int count = 1;
- psmt.setInt(count++, 0001);
- psmt.setString(count++, "java");
- psmt.setString(count++, "is");
- psmt.setString(count++, "easy");
- psmt.execute();
- psmt.close();
- con.close();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- ${:import(java.sql.Connection, java.sql.PreparedStatement, java.sql.SQLException)}
-
- </template><template autoinsert="true" context="java" deleted="false" description="create a select block" enabled="true" name="select">try {
- Connection con = ConnectionFactory.getConnection();
- PreparedStatement ps = con
- .prepareStatement("SELECT * FROM YOUR_TABLE_OR_YOUR_VIEW");
- ResultSet rs = ps.executeQuery();
- while (rs.next()) {
- System.out.println(rs.getObject(1));
- }
- rs.close();
- ps.close();
- con.close();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- ${: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() {
- @Override
- public void run() {
- ${line_selection}${cursor}
- }
- };
- 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 {
- ${line_selection}${cursor}
- } catch (${Exception} ${exception_variable_name}) {
- // ${todo}: handle exception
- }</template></templates>
Advertisement
Add Comment
Please, Sign In to add comment