Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Need jsp expertise to help...

Posted on 2001-06-22
13
Medium Priority
?
291 Views
Last Modified: 2012-08-14
I am facing a problem with my jsp file. How can I intergrate a jsp file to call a unix shell script??? I needed this because I am using the Unix mailx function to send out mails. So if anyone knows how to invoke this function from jsp file, please help.


Thank you

Cheers
Jason
0
Comment
Question by:jason101799
13 Comments
 
LVL 3

Expert Comment

by:shyamkumarreddy
ID: 6217837
Use java.lang.Runtime
to call ur Shell Script.
But shell script should be present the location of http

Use

Runtime.exec("shell.sh");

From your program

Shyam
0
 
LVL 6

Expert Comment

by:dorothy2
ID: 6219733
Why don't you use Java Mail 1.2 AI? It's pretty easy to implement, and then you don't have problems trying to trap errors that you will if you call a third party utility.

We used a code sample I got off the Net as a start toward writing our Email utility. I can send you code if you're interested.

Dorothy
0
 

Accepted Solution

by:
Naughton_J earned 400 total points
ID: 6220554
As dorothy2 mentioned above, the Mail API is the way to go.  If you are interested in the mechanics,  you can read the RFC for the Simple Mail Transfer Protocol (SMTP) at http://www.cis.ohio-state.edu/cgi-bin/rfc/rfc0821.html.  I have included a very simple example below that makes a socket connection to your mail server then sends out the SMTP commands needed to send a mail.  You can telnet to port 25 on your mail server and hand type these commands in to get a feel for how the server replies.

import java.io.*;
import java.net.*;

public void sendMail( String mailServerHostName, String senderHostName, String sender, String receiver, String subjectText, String bodyText )
throws Exception
{
     Socket socket = new Socket( mailServerHostName, 25 );
     PrintStream ps = new PrintStream( socket.getOutputStream() );

     ps.println("HELO " + senderHostName );
     ps.println("MAIL FROM: " + sender );
     ps.println("RCPT TO: " + receiver );
     ps.println("DATA" );
     ps.println("Subject: " + subjectText );
     ps.println( bodyText );
     ps.println(".\r\n");
     socket.close();
}
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:jason101799
ID: 6233779
Naughton,

Do I have to write this codes in java??? Can I just put all ya codes in a JSP file instead?? Sorry I am new to Java and JSP cause I am use to ASP syntax. Mind if you can briefly explain your proposed answer.

Thank you.

Cheers
Jason
0
 

Expert Comment

by:Naughton_J
ID: 6235708
Jason,
 
The code that is within the body of the sendMail( ) method can be added directly to your JSP.  Just make sure you place the code within a set of <% %> tags and declare the variables before you use them.  I don't think you need to import java.io.* and java.net.* in the JSP since they are used by the JSP anyway.  Before you write any code, I do recommend using telnet to connect to your mail server on port 25 and hand type the SMTP commands so you can see exactly how your mail sever responds.  The socket connection you establish in your JSP just automates what you will do manually with telnet.  
You should also get the input stream from the socket so you can check the response from the mail server after each SMTP command.  You can do this with something like:
BufferedReader is = new BufferedReader( new inputStreamReader( socket.getInputStream() ) );
Then call is.readln() after each ps.println( ) to capture the server's response.  A response of 250 means everything is OK.  In general any response starting with a 2 or a 3 is positive, anything else is some sort of error.  You can check the RFC for the meaning of all the response codes.

Good Luck!
John
0
 

Author Comment

by:jason101799
ID: 6237080
John,

How do we know what type of page import we need when we copy the source from java to jsp?


Cheers
Jason
0
 

Expert Comment

by:Naughton_J
ID: 6238629
Jason,

The following line will include the two packages required for the mail example.  Just add it to the top of your JSP.
<%@ page import="java.io.*, java.net.* %>

John
0
 

Author Comment

by:jason101799
ID: 6243395
John,

Thanks for the useful information. Before I award you the points, I would like to seek your expertise in JSP. Actually how do I call a function in JSP?

Perhaps you can go thru my codes and brief me.

-----------------------------------------------------------
<%@ page language="java" %>
<%@ page import="java.util.*, java.io.*, java.net.*" %>
<%! public String getCountries() {                                              
String addText="";
String cntry_cd="";
String cntry_nm="";

Class.forName("com.sun.jdbc.driver");
String url= "jdbc:sqli://123.256.456:1234/test";

Connection conn = DriverManager.getConnection(url,"test","test");

DatabaseMetaData meta = conn.getMetaData();
Statement stmt = conn.createStatement();
String sql = "select * from country";
ResultSet rslt = stmt.executeQuery(sql);
while ( rslt.next() )
{
cntry_cd = rslt.getString("ctry_cd");
cntry_nm = rslt.getString("ctry_nm");

addText = addText + "<OPTION VALUE=\"" + cntry_cd + "\">" + cntry_nm + "</OPTION>\n";
}                    

stmt.close();
conn.close();
return addText;
}
%>
<HTML>
<HEAD>
<TITLE>Commodity Page</TITLE>                                        
</HEAD>                                                    <BODY>                                  
                  <center>                                                   <IMG SRC=/images/wsisupport/webshipping.gif
height=100>              
<HR>                                                       </center>                                
                  <FORM NAME="login" ACTION="test.jsp" METHOD="post">              
<TABLE BORDER=0 CELLSPACING=4 CELLPADDING=3 WIDTH="100%">
<TR>
<TH>Commodity Search</TH>
</TR>

<TR>                                                       <TD>Select Country</TD>
<TD><SELECT NAME="country"><%= getCountries() %></SELECT></TD>
</TR></TABLE>
</BODY>
</HTML>

-----------------------------------------------------------

Thank you.


Cheers
Jason

0
 

Author Comment

by:jason101799
ID: 6243560
John,

Thanks for the useful information. Before I award you the points, I would like to seek your expertise in JSP. Actually how do I call a function in JSP?

Perhaps you can go thru my codes and brief me.

-----------------------------------------------------------
<%@ page language="java" %>
<%@ page import="java.util.*, java.io.*, java.net.*" %>
<%! public String getCountries() {                                              
String addText="";
String cntry_cd="";
String cntry_nm="";

Class.forName("com.sun.jdbc.driver");
String url= "jdbc:sqli://123.256.456:1234/test";

Connection conn = DriverManager.getConnection(url,"test","test");

DatabaseMetaData meta = conn.getMetaData();
Statement stmt = conn.createStatement();
String sql = "select * from country";
ResultSet rslt = stmt.executeQuery(sql);
while ( rslt.next() )
{
cntry_cd = rslt.getString("ctry_cd");
cntry_nm = rslt.getString("ctry_nm");

addText = addText + "<OPTION VALUE=\"" + cntry_cd + "\">" + cntry_nm + "</OPTION>\n";
}                    

stmt.close();
conn.close();
return addText;
}
%>
<HTML>
<HEAD>
<TITLE>Commodity Page</TITLE>                                        
</HEAD>                                                    <BODY>                                  
                  <center>                                                   <IMG SRC=/images/wsisupport/webshipping.gif
height=100>              
<HR>                                                       </center>                                
                  <FORM NAME="login" ACTION="test.jsp" METHOD="post">              
<TABLE BORDER=0 CELLSPACING=4 CELLPADDING=3 WIDTH="100%">
<TR>
<TH>Commodity Search</TH>
</TR>

<TR>                                                       <TD>Select Country</TD>
<TD><SELECT NAME="country"><%= getCountries() %></SELECT></TD>
</TR></TABLE>
</BODY>
</HTML>

-----------------------------------------------------------

Thank you.


Cheers
Jason

0
 

Expert Comment

by:Naughton_J
ID: 6245721
Jason,

Your code looks fine.  You correctly defined your getCountries( ) method within the <%! %> tag.  Are you getting an error?  You could try changing your getCountries( ) method to return a simple string just to see if getCountries( ) is getting called correctly.  If your simplified method works then it may be a problem with your database connection.

<%! public String getCountries()
     {     return " Get Countries Worked!";
     } %>

John

p.s. Are two questions worth twice as many points?
0
 

Author Comment

by:jason101799
ID: 6246858
John,

If I get my answer, it's worth twice.:)
Anyway u should get your points for the mail question posted. Perhaps you can help me with the second qs. How do I display my results in pages?? It would be nice if you provide me some advice and source codes.


Cheers
Jason
0
 

Expert Comment

by:Naughton_J
ID: 6257065
Jason,

It does not look like you have a closing form tag </form>.  This could be why you do not see the list on your page.  Any elements that belong on a form, such as a selection list, will not be displayed if they are not surrounded by the form tags.

John
0
 

Author Comment

by:jason101799
ID: 6257927
Thanks John,

Have a nice day ahead.


Cheers
Jason
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After being asked a question last year, I went into one of my moods where I did some research and code just for the fun and learning of it all.  Subsequently, from this journey, I put together this article on "Range Searching Using Visual Basic.NET …
Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
Suggested Courses

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question