Here is the one...it looks lists.mysql.com is filtering the attachments.
--
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","vanuganti","
venu");
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());
}
}
}
--
> -----Original Message-----
> From: shane [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 19, 2001 10:15 PM
> To: Venu Anuganti; Ricardo Striquer Soares; shane
> Cc: [EMAIL PROTECTED]
> Subject: RE: MySQL JDBC
>
>
> think the attachment is wrong. the only thing i get is a text file
> containing
>
> Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> could you pls send us the samples again, thks
>
> shane
> -----Original Message-----
> From: Venu Anuganti [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 20, 2001 11:45 AM
> To: Ricardo Striquer Soares; shane
> Cc: [EMAIL PROTECTED]
> Subject: Re: MySQL JDBC
>
>
> Hi Ricardo / Shane
>
> If you are using mmmysql JDBC Driver, please find the attaches simple JDBC
> sample that can be used with this driver to connect to MySQL server and do
> some basic operations. Before compiling the sample, make sure you set the
> CLASSPATH variable to mmmysql JDBC driver installed/achieved directory.
>
> Hope this helps you. If you have any questions or feedback let us know.
>
> Thank you
> Venu Anuganti
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
