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

}

}