idea Mysql 数据连接

import com.mysql.jdbc.PreparedStatement;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * Created by Administrator on 2017/3/3.
 */
public class mysqltest {

    private static  final  String DBDRIVER = "org.gjt.mm.mysql.Driver";
    private static  final String DBURI = "jdbc:mysql://localhost:3306/mshop";
    private static final String USER = "root";
    private  static final String PASSWORD = "root";
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        try {
            Class.forName(DBDRIVER);
            Connection connection = DriverManager.getConnection(DBURI,USER,PASSWORD);
            String sql = "SELECT * FROM  item";
            PreparedStatement pstmt = (PreparedStatement) connection.prepareStatement(sql);
            ResultSet rs  = pstmt.executeQuery();
            while(rs.next()){
                System.out.println(rs.getString(2));
            }
        }catch (Exception e){
            e.printStackTrace();
        }







    }

}