anexo arq ex
import java.sql.*;
public class TestMySQL
{
public static void main(String[] Args)
{
try {
// The newInstance() call is a work around for some
// broken Java implementations
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
}
catch (Exception E) {
System.err.println("Unable to load driver.");
E.printStackTrace();
}
try {
/* Connection Management */
//Here test is the database name
//vanuganti--UID
//venu--PWD
Connection conn =
DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","");
conn.setAutoCommit(true);
/* Create stmt and process some basic SQL statements */
Statement stmt = conn.createStatement();
stmt.execute("drop table test_mysql");
stmt.execute("create table test_mysql(col1 int, col2 varchar(25))");
stmt.execute("insert into test_mysql values(100,'mysql')");
stmt.execute("insert into test_mysql values(200,'myjdbc')");
/* Result set */
ResultSet rs = stmt.executeQuery("SELECT * FROM test_mysql");
while (rs.next())
{
System.out.println("COL1:"+rs.getInt(1));
System.out.println("COL2:"+rs.getString(2));
}
// Clean up after ourselves
rs.close();
stmt.close();
conn.close();
}
catch (SQLException E) {
System.out.println("SQLException: " + E.getMessage());
System.out.println("SQLState: " + E.getSQLState());
System.out.println("VendorError: " + E.getErrorCode());
}
}
}
------------------------------ 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]
-------------------------------------------------------------------------
