import java.sql.*;
public class DB_base {
public static void main(String[] args){
String conUrl ="jdbc:mysql://localhost:3306/test";
Connection conn=null;
ResultSet rs=null;
String DBDriver = "org.gjt.mm.mysql.Driver";
try{
Class.forName(DBDriver);
conn = DriverManager.getConnection(conUrl,"root","root");
Statement stmt=conn.createStatement();
rs = stmt.executeQuery("select * from mytable");
while(rs.next()){
System.out.println(rs.getString("ID") + " | " +rs.getString("name")+
" | " + rs.getString("age"));
}
conn.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
我用的mysql5数据库,同时使用的驱动也一定要下载for5.0的,不然会出错//
/我下载的是mysql-connector-java-5.0.0-beta.zip这个文件//