mysql jdbc怎样用jdbc连接mysql数据库

jdbc是什么, 和mysql什么关系,需要下载什么吗

JDBC是连接数据库。这个数据库可以指派不同的数据库。写好的JDBC代码可以实现页面传值。 而MySql是数据库软件之一。

jdbc连接mysql的代码

public?Connection?con=null; public?PreparedStatement?pst=null; public?Connection?getCon()?throws?SQLException{ String?JDriver=.microsoft.sqlserver.jdbc.SQLServerDriver";?//SQL驱动 try?{ Class.forName(JDriver).newInstance(); String?url="jdbc:sqlserver://localhost:1433;DatabaseName=StudentManagement";//数据库的信息 con=DriverManager.getConnection(url,"登录名","密码"); }?catch?(InstantiationException?|?essException |?ClassNotFoundException?e)?{ //?TODO?Auto-generated?catch?block e.printStackTrace(); } return?con; }

怎样用jdbc连接mysql数据库

import?java.sql.*;?? public?class?MysqlTest?{?? ????public?static?void?main(String[]?args){?? ???????????????//?驱动程序名???????? ????????String?driver?=?.mysql.jdbc.Driver";?? ???????????????//?URL指向要访问的数据库名world???????? ????????String?url?=?"jdbc:mysql://127.0.0.1:3306/world";?? ???????????????//?MySQL配置时的用户名??????????? ????????String?user?=?"root";??????????? ????????//?MySQL配置时的密码?????????? ????????String?password?=?"123456";?? ????????String?name;?? ????????????????try?{??????????????? ?????????????????//?加载驱动程序???????? ????????????????Class.forName(driver);?? ????????????????????//?连续数据库??????? ???????????????Connection?conn?=?DriverManager.getConnection(url,?user,?password);?? ???????????????????if(!conn.isClosed())?????????? ??????????????????System.out.println("eeded?connecting?to?the?Database!");?? ??????????????????//?statement用来执行SQL语句????????????? ?????????????????????Statement?statement?=?conn.createStatement();?? ?????????????????//?要执行的SQL语句??????????? ???????????????????String?sql?=?"select?*?from?city";?? ????????????????//?结果集??????? ??????????????????ResultSet?rs?=?statement.executeQuery(sql);?? ????????????????while(rs.next())??{????????? ???????????????//?选择Name这列数据????? ???????????????name?=?rs.getString("Name");?? ??????????????????//?输出结果?????????????? ??????????????????System.out.println(rs.getString("CountryCode")?+?" "?+?name);??????????? ?????????????}?? ?????????rs.close();???????conn.close();??}??? ????????catch(ClassNotFoundException?e)?{?? ?????????System.out.println("Sorry,can`t?find?the?Driver!");?????????????? ?????????e.printStackTrace();?? ????????}?catch(SQLException?e)?{?? ?????????e.printStackTrace();?? ????????}?catch(Exception?e)?{?? ?????????e.printStackTrace();?? ????????}??? ????????}?? }