Dae pessoal blz … bom seguinte … gostaria d saber como conectar em um banco ODBC remotamente usando applet …
import java.applet.Applet;
import java.awt.Button;
import java.awt.Label;
import java.awt.TextArea;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class pricipal extends Applet implements ActionListener {
Button b = new Button("Iniciar");
Label prct = new Label("0.0 %");
Label contag = new Label ("...");
TextArea ta = new TextArea(5,50);
String caminho = "jdbc:odbc:kstudio";
static final String driver_class = "sun.jdbc.odbc.JdbcOdbcDriver";
int total;
public void actionPerformed(ActionEvent ae){
if (ae.getSource() == b){
CheckUrl checkUrl = new CheckUrl();
try {
Class.forName(driver_class);
Connection con = DriverManager.getConnection(caminho,"","");
Statement d = con.createStatement();
Statement d2 = con.createStatement();
Statement d3 = con.createStatement();
String query = "select url.url from url ";
String query2 = "select count(*) from url" ;
ResultSet rr = d.executeQuery(query);
ResultSet rcount = d3.executeQuery(query2);
rcount.next();
total = rcount.getInt(1);
double atual;
int i = 0;
while (rr.next()) {
System.out.println(i);
checkUrl.status = false;
String aux = rr.getString(1);
checkUrl.url = aux;
checkUrl.verificaUrl();
String update;
if (checkUrl.status == true){
update = "UPDATE url SET url.status = 'S' WHERE url.url = '" + aux +"'";
}
else
{
update = "UPDATE url SET url.status = 'N' WHERE url.url = '" + aux +"'";
}
d2.executeUpdate(update);
i++;
ta.append(checkUrl.linha + "\n");
atual = (i * 100) / 4953 ;
String strValue = String.valueOf(atual) + " %";
prct.setText(strValue);
contag.setText(String.valueOf(i) + " / " + String.valueOf(total));
}
checkUrl = null;
d.close();
con.close();
} catch (SQLException e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
} catch (ClassNotFoundException e) {
ta.append("ClassException: " + e.getMessage());
e.printStackTrace();
}
} }
public void init() {
setLayout(null);
setSize(550,200);
ta.setBounds(10,10,510,100);
b.setBounds(10,120,75,25);
prct.setBounds(400,120,75,25);
contag.setBounds(400,150,75,25);
b.setVisible(true);
ta.setVisible(true);
prct.setVisible(true);
add(b);
add(ta);
add(contag);
add(prct);
ta.append("entro1");
b.addActionListener(this);
}
}
parece q borta no class.ForName … desd ja agradeço a todos …