Solved

Need jsp expertise to help...

Posted on 2001-06-22
13
270 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 100 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
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to get all the API from website? 11 88
splitOdd10 challenge 5 105
difference of if loops 23 49
JavaFX TableView not displaying correctly 3 17
For customizing the look of your lightweight component and making it look lucid like it was made of glass. Or: how to make your component more Apple-ish ;) This tip assumes your component to be of rectangular shape and completely opaque. (COD…
INTRODUCTION Working with files is a moderately common task in Java.  For most projects hard coding the file names, using parameters in configuration files, or using command-line arguments is sufficient.   However, when your application has vi…
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…

776 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