Alexandre:
te envio un ejemplo.
Es el ejemplo de JDK modificado para MySql.
import java.sql.*; //import all the JDBC classes
public class CreateJoltData {
static String[] SQL = {
"insert into JoltData values ('Gilbert',
'Mon', 1);",
"insert into JoltData values ('Wally', 'Mon',
2);",
"insert into JoltData values ('Edgar', 'Tue',
8);",
"insert into JoltData values ('Wally', 'Tue',
2);",
"insert into JoltData values ('Eugene', 'Tue',
3);",
"insert into JoltData values ('Josephine',
'Wed', 2);",
"insert into JoltData values ('Eugene', 'Thu',
3);",
"insert into JoltData values ('Gilbert',
'Thu', 1);",
"insert into JoltData values ('Clarence',
'Fri', 9);",
"insert into JoltData values ('Edgar', 'Fri',
3);",
};
public static void main(String[] args) {
try {
Class.forName("org.gjt.mm.mysql.Driver");
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (Exception e) {
System.out.println("Failed to load MySql
JDBC driver.");
return;
}
Statement stmt = null;
Connection con=null;
try {
con = DriverManager.getConnection
("jdbc:mysql://localhost:3306/CafeJolt");
stmt = con.createStatement();
} catch (Exception e) {
System.err.println("problems connecting to
");
}
try {
// execute SQL commands to create table,
insert data
stmt.execute(SQL);
} catch (Exception e) {
System.err.println("problems with SQL sent
to "+e.getMessage());
}
}
}
Sorte
Daniel
_________________________________________________________
¿Lo probaste?
Correo gratis y para toda la vida en http://correo.yahoo.com.ar
------------------------------ LISTA SOUJAVA ----------------------------
http://www.soujava.org.br - Sociedade de Usuários Java da Sucesu-SP
dúvidas mais comuns: http://www.soujava.org.br/faq.htm
regras da lista: http://www.soujava.org.br/regras.htm
para sair da lista: envie email para [EMAIL PROTECTED]
-------------------------------------------------------------------------
