Brett,
This is my code
// This is my HTML which invokes the applet DbApplet.java
// All the 3 files I mean //dbApplet.html,DbApplet.class,DbServlet.class are stored
// in the same directory
<HTML>
<HEAD>
<TITLE>Database Query Interface</TITLE>
</HEAD>
<BODY>
<CENTER>
<H1>Database Query Interface</H1>
<HR>
<BR>
<!--"CONVERTED_APPLET"-->
<!-- CONVERTER VERSION 1.0 -->
<OBJECT classid="clsid:8AD9C840-044E-11D1-B3E9-00805F499D93"
WIDTH = "600" HEIGHT = "300" NAME = "DbApplet" codebase="/">
<PARAM NAME = CODE VALUE = "DbApplet.class" >
<PARAM NAME = NAME VALUE = "DbApplet" >
<PARAM NAME="type" VALUE="application/x-java-applet;version=1.1">
<COMMENT>
<EMBED type="application/x-java-applet;version=1.1" java_CODE = "DbApplet.class" NAME = "DbApplet" WIDTH = "600" HEIGHT = "300" pluginspage="http://java.sun.com/products/plugin/1.1.1/plugin-install.html">
<NOEMBED></COMMENT>
</NOEMBED></EMBED>
</OBJECT>
<!--
<APPLET CODE = "DbApplet.class" WIDTH = "600" HEIGHT = "300" NAME = "DbApplet" >
</APPLET>
-->
<!--"END_CONVERTED_APPLET"-->
</CENTER>
</BODY>
</HTML>
This is my Applet which calls the DbServlet.class in turn which accesses the database
import java.awt.*;
import java.applet.*;
import java.awt.event.*;
import java.io.*;
import java.net.*;
public class DbApplet extends Applet implements ActionListener {
TextField tfQuery;
TextArea taResults;
Button btnExecute;
public void init() {
Panel p1 = new Panel();
p1.setLayout(new FlowLayout(FlowLayout.LEFT));
p1.add(new Label("Query String:"));
tfQuery = new TextField("", 50);
p1.add(tfQuery);
btnExecute = new Button("Execute Query");
btnExecute.addActionListener(this);
p1.add(btnExecute);
add("North", p1);
taResults = new TextArea(10, 80);
add("Center", taResults);
}
public void executeQuery() {
/* This is part of the code I added in my trial and error but please dont count this
String webServerStr, protocol;
String hostName="localhost";
int port = 8080;
URL hostURL = getCodeBase();
protocol=hostURL.getProtocol();
hostName = hostURL.getHost();
port = hostURL.getPort();
if (port == -1)
{
port = 80;
}
End of trial and error code*/
String qryString = tfQuery.getText();
try {
webServerStr = "http://localhost/servlets/DbServlet";
URL url = new URL(webServerStr);
String qry = URLEncoder.encode("qry") + "=" +
URLEncoder.encode(qryString);
URLConnection uc = url.openConnection();
uc.setDoOutput(true);
uc.setDoInput(true);
uc.setUseCaches(false);
uc.setRequestProperty("Content-type",
"application/x-www-form-urlencoded");
DataOutputStream dos = new DataOutputStream(uc.getOutputStream());
dos.writeBytes(qry);
dos.flush();
dos.close();
InputStreamReader in = new InputStreamReader(uc.getInputStream());
int chr = in.read();
while (chr != -1) {
taResults.append(String.valueOf((char) chr));
chr = in.read();
}
in.close();
} catch(MalformedURLException e) {
taResults.setText(e.toString());
} catch(IOException e) {
taResults.setText(e.toString());
}
catch(Exception e) {
taResults.setText(e.toString());
}
}
public void actionPerformed(ActionEvent ae) {
executeQuery();
}
}
//This is my Servlet Program
//Import Servlet Libraries
import javax.servlet.*;
import javax.servlet.http.*;
//Import Java Libraries
import java.util.*;
import java.sql.*;
import java.io.*;
public class DbServlet extends HttpServlet {
Connection dbCon;
public void init() throws ServletException {
try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
dbCon = DriverManager.getConnection("jdbc
racle:thin:@localhost:1521
rcl","javauser","javauser");
} catch (Exception e) {
System.out.println("Database connect failed (init)");
System.out.println(e.toString());
return;
}
}
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
PrintWriter out = res.getWriter();
res.setContentType("text/html");
String qry = req.getParameter("qry");
try {
Statement s = dbCon.createStatement();
ResultSet rs = s.executeQuery(qry);
while (rs.next()) {
out.println(rs.getString(1) + " - " + rs.getString(2));
out.println(rs.getString(3));
out.println ("");
}
} catch (SQLException e) {
System.out.println(e.toString());
return;
}
out.println();
out.close();
}
public void destroy() {
/* Close database connection */
try {
dbCon.close();
} catch (Exception e) {
System.out.println("Error closing database (destroy)");
System.out.println(e.toString());
}
}
}
Ranch Hand Scavenger Hunt
Number Posts (19/100)
First Post
