Java查询

Info.java

package info;
import dao.*;

public class Info {

public static void main(String[] args) {
 Dao.dao();
}

}

Dao.java

package dao;
import java.sql.*;

public class Dao {
public static Dao dao(){
String driverName=“com.mysql.jdbc.Driver”;
String dbURL=“jdbc:mysql://localhost:3306/db_database28”;
String USER=“root”;
String PASS=“root”;
try{
//注册 JDBC 驱动
Class.forName(driverName);
//连接
Connection conn=DriverManager.getConnection(dbURL,USER,PASS);
//查询
Statement stmt=conn.createStatement();
String sql=“SELECT name FROM tb_gysinfo”;
ResultSet rs=stmt.executeQuery(sql);
//检索字段
while(rs.next()){
String name = rs.getString(“name”);
// 输出数据
System.out.print(", 站点名称: " + name);

}

}
catch(Exception e){

}
return null;
}
}