package com.ningmeng;
import java.sql.*;
public class Test07 {
  public static void main(String[] args) {
    // TODO Auto-generated method stub
    try {
      Class.forName("com.mysql.jdbc.Driver");//加載數(shù)據(jù)庫驅動
      System.out.println("加載數(shù)據(jù)庫驅動成功");
      String url="jdbc:mysql://localhost:3306/test";//聲明自己的數(shù)據(jù)庫test的url
      String user="root";//自己的數(shù)據(jù)庫用戶名
      String pass="123456";//自己的數(shù)據(jù)庫密碼
      //建立數(shù)據(jù)庫連接，獲得連接的對象conn
      Connection conn=DriverManager.getConnection(url,user,pass);
      System.out.println("連接數(shù)據(jù)庫驅動成功");
      Statement stmt=conn.createStatement();//創(chuàng)建一個Statement對象
      String sql="select * from users where username like '%別%' ";//生成sql語句
      ResultSet rs=stmt.executeQuery(sql);//執(zhí)行sql語句
      int id,age,sex;
      String username,password;
      System.out.println("id\t 用戶名\t 密碼\t 性別\t 年齡");
      while(rs.next()){
        id=rs.getInt("id");
        username=rs.getString(2);
        password=rs.getString("password");
        age=rs.getInt(4);
        sex=rs.getInt("age");
        System.out.println(id+"\t"+username+"\t"+password+"\t"
            +sex+"\t"+age);//輸出查詢結果
      }
      System.out.println("模糊查詢成功");
      conn.close();//關閉數(shù)據(jù)庫連接
      System.out.println("關閉數(shù)據(jù)庫連接成功");
    } catch (ClassNotFoundException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
  }
}