select.asp:
<%
Set con = Server.CreateObject("ADODB.Connection")
con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Database\MSAccess\Test.mdb;User Id=admin;Password=;"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "SELECT * FROM T1",con
Do While Not rs.EOF
%>
<%=rs("F1")%> <%=rs("F2")%><br>
<%
rs.MoveNext
Loop
Set rs = Nothing
Set con = Nothing
%>
insert.asp:
<%
Set con = Server.CreateObject("ADODB.Connection")
con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Database\MSAccess\Test.mdb;User Id=admin;Password=;"
con.Execute "INSERT INTO T1(F1,F2) VALUES(" & Request.Form("F1") & ",'" & Request.Form("F2") & "')"
Set con = Nothing
%>
DatabaseApplet.java:
import java.awt.*;
import java.awt.event.*;
import java.applet.*;
import java.io.*;
import java.net.*;
public class DatabaseApplet extends Applet implements ActionListener {
TextArea select = new TextArea();
TextField f1 = new TextField();
TextField f2 = new TextField();
Button insert = new Button();
public void init() {
select.setColumns(40);
select.setRows(20);
select.setText(select());
f1.setColumns(10);
f2.setColumns(20);
insert.setLabel("Add");
insert.addActionListener(this);
add(select, null);
add(f1, null);
add(f2, null);
add(insert, null);
setVisible(true);
}
public void actionPerformed(ActionEvent ev) {
insert(f1.getText(), f2.getText());
select.setText(select());
repaint();
}
private String select() {
StringBuffer res = new StringBuffer("");
try {
URL url = new URL("
http://localhost/select.asp");
HttpURLConnection con = (HttpURLConnection) url.openConnection();
con.setRequestMethod("GET");
con.connect();
if (con.getResponseCode() == HttpURLConnection.HTTP_OK) {
BufferedReader br = new BufferedReader(new InputStreamReader(con.getInputStream()));
String line;
while ( (line = br.readLine()) != null) {
res.append(line);
res.append("\r\n");
}
con.disconnect();
}
} catch (IOException ex) {
ex.printStackTrace();
}
return res.toString();
}
private void insert(String f1, String f2) {
try {
URL url = new URL("
http://localhost/insert.asp");
HttpURLConnection con = (HttpURLConnection) url.openConnection();
con.setRequestMethod("POST");
String info = "F1=" + f1 + "&F2=" + f2;
con.setDoOutput(true);
con.getOutputStream().write(info.getBytes());
con.connect();
if (con.getResponseCode() != HttpURLConnection.HTTP_OK) {
System.err.println("POST failed");
}
con.disconnect();
} catch (IOException ex) {
ex.printStackTrace();
}
}
}
