MyEclipse使用jdbc连接MySQL

1.到MySQL官网下载mysql-connector-java-5.1.46

2.将文件名中含有bin的jar包拷贝到项目路径下。

3.编写JDBC模版：

package demo; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; //PrepareStatement的区别、excuteUpdate()、excute() public class MysqlDemo { public static void main(String[] args){ String user = "root";

String password = "root";

//URL编写方式：jdbc:mysql://主机名称：连接端口/数据库的名称?参数=值

String url = "jdbc:mysql://localhost:3306/game_design";   
String sql = "SELECT * FROM GAME";

try {
Class.forName("com.mysql.jdbc.Driver");
System.out.println("成功加载MySQL驱动程序！");
Connection con = DriverManager.getConnection(url, user, password);
System.out.println("成功连接到指定的数据库！");
Statement stm = con.createStatement();
ResultSet rs = stm.executeQuery(sql);
System.out.println("ID name type"); //制作表头
while(rs.next()){
System.out.print(rs.getInt(1)+" "); //数据库中的index是从1开始的
System.out.print(rs.getString("name")+" ");
System.out.println(rs.getString(3));
}
rs.close();
stm.close();
con.close();
} catch (ClassNotFoundException e) {
System.out.println("找不到驱动类！");
}catch (SQLException e) {
System.out.println("MySQL操作错误！");
}catch (Exception e){
e.printStackTrace();
}

}

}