package com.tengyang.oop.ch11;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 
public class Test3 {
 
    public static void main(String[] args) {
        Connection conn = null;
        Statement ste = null;
        try {
            //加载驱动
            Class.forName("com.mysql.jdbc.Driver");
            //创建Connection对象
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb", "root", "root");
            //编写Sql语句
            String sql = "select name,id from tablename1";
            //创建Statement
            ste = conn.createStatement();
            //执行sql语句
            ResultSet rs = ste.executeQuery(sql);
            while(rs.next()){
                int id = rs.getInt("id");
                String name = rs.getString("name");
                System.out.println("id:"+id+"name:"+name);
            }
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
     
}执行结果:<ConnectionProperties>
 <PropertyCategory name="Connection/Authentication">
  <Property name="user" required="No" default="" sortOrder="-2147483647" since="all versions">
    The user to connect as
  </Property>
  <Property name="password" required="No" default="" sortOrder="-2147483646" since="all versions">
    The password to use when connecting
  </Property>
……
……