You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Current »

Hello Jogetor guys,

I wrote beanshell script in beanshell tool plug-in. my question is how can call it in my form.

beanshell
        import java.util.*;
	import java.sql.*;
	import javax.sql.DataSource;
	import java.io.*;

	Connection conn = null;
        PreparedStatement stmt = null;
        try
        {
            String userName = "root";
            String password = "";
            String url = "jdbc:mysql://localhost:3307/jwdb?characterEncoding=UTF-8";
            Class.forName ("com.mysql.jdbc.Driver").newInstance ();
            conn = DriverManager.getConnection (url, userName, password);
            if(!conn.isClosed())
            {
            	String sql = "SELECT Count(*) FROM app_fd_application WHERE app_fd_application.c_companyName = '#form.application.companyName#'";
                stmt = conn.prepareStatement(sql);
                ResultSet rs = stmt.executeQuery(sql);
                rs.next();
                boolean exists;
                if( exists = rs.getInt("COUNT(*)") > 0)
                {
                	System.out.println("exists");
                }
                else
                {
                	System.out.println("not exists");
                }
            }
        }
        catch (Exception e)
        {
        	System.err.println("Exception: " + e.getMessage());
        }
        finally
        {
            try {
                if(conn != null)
                {
                    conn.close();
                }
            }
            catch(SQLException e)
            {
            }
        }   

BR

  • No labels