package com.test.an;

 import java.sql.Connection;

 import java.sql.DriverManager;

 import java.sql.PreparedStatement;

 import java.sql.ResultSet;

 import java.sql.SQLException;

 public class TestCon1{

     public static void main(String[] args)

     {

         Connection con = null;

         String sql;

         PreparedStatement pre;

         ResultSet rs;

         try {

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

             Class.forName(driver);

             String url="jdbc:mysql://localhost:3306/cui?useUnicode=true&characterEncoding=latin1";//utf-8也行

             con = DriverManager.getConnection(url, "root", "123456");

             sql = "select _id,username,password from test1" ;

             pre = con.prepareStatement(sql);

             rs = pre.executeQuery();

             while(rs.next()){

                 int id = rs.getInt(1);

                 String username = rs.getString(2);

                 String password = rs.getString(3);

                 System.out.println("id="+id+";username="+username+";password="+password);

             }

             con.close();

         } catch (SQLException e) {

             e.printStackTrace();

         } catch (ClassNotFoundException e) {

             e.printStackTrace();

         }

     }

 }