Need jsp expertise to help...

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
jason101799Asked:
Who is Participating?
 
Naughton_JConnect With a Mentor Commented:
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
 
shyamkumarreddyCommented:
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
 
dorothy2Commented:
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
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
jason101799Author Commented:
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
 
Naughton_JCommented:
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
 
jason101799Author Commented:
John,

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


Cheers
Jason
0
 
Naughton_JCommented:
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
 
jason101799Author Commented:
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
 
jason101799Author Commented:
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
 
Naughton_JCommented:
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
 
jason101799Author Commented:
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
 
Naughton_JCommented:
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
 
jason101799Author Commented:
Thanks John,

Have a nice day ahead.


Cheers
Jason
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.