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();        }    }}