java mysql结果集_JAVA中显示MYSQL查询结果

刚开始学JAVA和MYSQL数据库已经建立好并可以链接用JAVA来编一个查询数据库的方法可是却不能显示出来代码如下请大家帮我看看packagenet.macroth.db;importjava.sql.*;publicclassDBTes...

刚开始学JAVA和MYSQL

数据库已经建立好并可以链接

用JAVA来编一个查询数据库的方法

可是却不能显示出来

代码如下 请大家帮我看看

package net.macroth.db;

import java.sql.*;

public class DBTest {

private static String driver="com.mysql.jdbc.Driver";

private static String url = "jdbc:mysql://localhost:3306/AAA";

private static String user = "AAA_root";

private static String password = "123456";

private static Statement stmt;

private static String sql = "SELECT * FROM AAA;";

private static Connection conn;

private static ResultSet rs;

public void init(){

try{

Class.forName(driver);

conn = DriverManager.getConnection(url,user,password);

if(!conn.isClosed())

System.out.println("Connection Completed!");

stmt = conn.createStatement();

}catch(ClassNotFoundException cnfe){

System.out.println("drive not found");

cnfe.printStackTrace();

}

catch(SQLException sqle){

sqle.printStackTrace();

}

}

public boolean close(){

try{

conn.close();

stmt.close();

rs.close();

}catch(SQLException sqlex){

sqlex.printStackTrace();

return false;

}

System.out.println("coon close");

return true;

}

public ResultSet executeQuery(String sql){

try {

rs=stmt.executeQuery(sql);

}catch (SQLException sqlex) {

sqlex.printStackTrace();

return null;

}

return rs;

}

public static void main(String[] args){

DBTest d = new DBTest();

d.init();

d.executeQuery(sql);

d.close();

}

}

展开