package jdbc;

import java.sql.DriverManager;

import java.sql.SQLException;

import com.mysql.jdbc.Connection;

import com.mysql.jdbc.ResultSet;

import com.mysql.jdbc.Statement;

public class Test {

private static final String URL="jdbc:mysql://127.0.0.1:3306/imooc";

private static final String USER="root";

private static final String PASSWORD="123456";

private static java.sql.Connection conn= null;

static {

try {

Class.forName("com.mysql.jdbc.Driver");

?conn = DriverManager.getConnection(URL,USER,PASSWORD);

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

public static java.sql.Connection getconnection(){

return conn;

}

public static void main(String[] args) throws Exception{

java.sql.Statement stm =conn.createStatement();

? ? ?//Statement stm =(Statement) conn.createStatement();

? ? ? ResultSet rs=(ResultSet) stm.executeQuery("select user_name,age from imooc_goddess");

? ? ? ? ? while(rs.next()){

? ? ? ? ?System.out.println(rs.getString("user_name")+" ?"+rs.getInt("age"));

? ? ? ? ?

? ? ? ? ? }

}

}

package dao;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

import com.mysql.jdbc.Connection;

import com.mysql.jdbc.ResultSet;

import com.mysql.jdbc.Statement;

import jdbc.Test;

import mode.Goddess;

public class goddessdap {

public void add(){

}

public void Update(){

}

public void del(){

}

public ?List<Goddess> qurel() throws SQLException{

java.sql.Connection conn = Test.getconnection();

java.sql.Statement stm = conn.createStatement();

? ? ? ResultSet rs=(ResultSet) stm.executeQuery("select user_name,age from imooc_goddess");

? ? ? List<Goddess> gs = new ArrayList<Goddess>();

? ? ? Goddess g= null;

? ? ?

? ? ? while(rs.next()){

? ? ? ?System.out.println(rs.getString("user_name")+" ?"+rs.getInt("age"));

? ? ? ? g= new Goddess();

? ? ? g.setUser_name(rs.getString("user_name"));

? ? ? g.setAge(rs.getInt("age"));

? ? ? gs.add(g);

? ? ? ? }

return gs;

}

public Goddess qurel2(){

return null;

}

}

package Contral;

import java.sql.SQLException;

import java.util.List;

import dao.goddessdap;

import mode.Goddess;

public class Contral {

public static void main(String[] args) throws SQLException {

goddessdap g= ?new goddessdap();

List <Goddess> gsk = g.qurel();

for (Goddess goddess : gsk) {

System.out.println("goddess.getUser_name()"+",goddess.getAge()");

}

}

}

求指教！?。。。。。。。。。。。。。。。。。。。?/p>