连接数据库架包mysql-connector-java-5.1.7-bin.jar下载地址:https://pan.baidu.com/s/1i48wYiD
步骤:
1.加载驱动:Class.forName("com.mysql.jdbc.Dirve");
2.连接数据库 Connection con = DriverManager.getConnection(url,user,password);
3.创建Statement对象Statement st = con.createStatement();
4.向数据库发送SQL命令,并处理数据库返回的结果(使用ResultSet类)
ResultSet rs = st.executeQuery("select * from user");
while(rs.next()){
System.out.println(rs.getString("name") + " " + rs.getString("sex"));
}
具体代码如下:
public class TestJDBCc { public static void main(String[] args) throws ClassNotFoundException, SQLException { String URL="jdbc:mysql://127.0.0.1:3306/fangling?useUnicode=true&characterEncoding=utf-8"; String USER="root"; String PASSWORD="111111"; try { //1.加载驱动程序[可以动态加载mysql驱,也可以通过初始化来驱动起来】 Class.forName("com.mysql.jdbc.Driver"); //2.获得数据库链接 Connection con = DriverManager.getConnection(URL,USER,PASSWORD); //3.创建Statement对象 Statement st = con.createStatement(); //4.向数据库发送SQL命令并处理数据库的返回结果(使用ResultSet类) ResultSet rs = st.executeQuery("select * from user"); while(rs.next()){ System.out.println(rs.getString("name") + " " +rs.getString("sex")); } //关闭资源 rs.close(); st.close(); con.close(); }catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } }ok