import java.sql.*;public class MetaTest
{
static final String dbURI = "jdbc:mysql://192.168.1.52/dm_db";
public static void main(String args[]) throws ClassNotFoundException , SQLException
{
Connection conn = null;
try
{
Class.forName("org.gjt.mm.mysql.Driver");
conn = DriverManager.getConnection(dbURI,"root","");
DatabaseMetaData dmd = conn.getMetaData();
if (dmd == null)
{ System.out.println("database meta data not available!");}
else
{ System.out.println("数据库产品名称 : " + dmd.getDatabaseProductName());
System.out.println("数据库产品版本 : " + dmd.getDatabaseProductVersion());
System.out.println("数据库驱动名称 : " + dmd.getDriverName());
System.out.println("数据库驱动版本 : " + dmd.getDriverVersion());
System.out.println();
}
}
finally
{
if (conn!=null)
{
try
{conn.close();}
catch(SQLException sqlEx){}
}
}
}
}
{
static final String dbURI = "jdbc:mysql://192.168.1.52/dm_db";
public static void main(String args[]) throws ClassNotFoundException , SQLException
{
Connection conn = null;
try
{
Class.forName("org.gjt.mm.mysql.Driver");
conn = DriverManager.getConnection(dbURI,"root","");
DatabaseMetaData dmd = conn.getMetaData();
if (dmd == null)
{ System.out.println("database meta data not available!");}
else
{ System.out.println("数据库产品名称 : " + dmd.getDatabaseProductName());
System.out.println("数据库产品版本 : " + dmd.getDatabaseProductVersion());
System.out.println("数据库驱动名称 : " + dmd.getDriverName());
System.out.println("数据库驱动版本 : " + dmd.getDriverVersion());
System.out.println();
}
}
finally
{
if (conn!=null)
{
try
{conn.close();}
catch(SQLException sqlEx){}
}
}
}
}
在那里可以找到?
参考这个
http://www.iitong.com/php/html/jsp/2004-03/23/130510.html
public class Test
{
public static void main(String[] args){
try{
Class.forName("com.mysql.jdbc.Driver");
System.out.println("Success loading MySql Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/idol","root","");
Statement sql=con.createStatement();
ResultSet rs=sql.executeQuery("select * from bill");
while(rs.next())
{
String name=rs.getString(1);
System.out.println(name);
System.out.print("");
}
con.close();
}
catch(Exception e)
{
System.out.println("Error");
e.printStackTrace();
}
}
}