jdbc连接mysql入门程序

1假设你已在MySQL数据库服务器中创建了jdbc数据库和users表，并且表中有记录

  select id,name,sal from users;

    2创建一个javase或javaweb应用

3创建com.aaa.jdbc包名

4将mysql-connector-java-5.1.7-bin.jar(版本无所谓)导入工程的classpath中去

5创建Demo01程序，查询所有用户

public class Demo01 { public static void main(String[] args) throws Exception{ DriverManager.registerDriver(new Driver());          //URL,数据库用户名,密码 Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/jdbc","root","root"); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("select * from users"); while(rs.next()){ Object id = rs.getObject("id"); Object name = rs.getObject("name"); Object sal = rs.getObject("sal"); System.out.println(id); System.out.println(name); System.out.println(sal); System.out.println("------------------------"); } rs.close(); stmt.close(); conn.close(); } }