jdbc简单操作数据库实例

1.当然要把数据库以及表建好，为了方便测试，最好还要插些数据

create database day14 character set utf8 collate utf8_general_ci; 
create table employee(
id int,
name varchar(20),
gender varchar(4),
birthday date,
entry_date date,
job varchar(40),
salary double,
resume text


)character set utf8 collate utf8_general_ci;

insert into employee (id,name,gender,birthday,entry_date,job,salary,resume)values(1,'kaxifa','man','1992-01-11','2015-06-16','computer',5000,'title');
insert into employee (id,name,gender,birthday,entry_date,job,salary,resume)values(2,'Tom','man','1992-01-11','2015-06-16','computer',5000,'title');
insert into employee (id,name,gender,birthday,entry_date,job,salary,resume)values(3,'kaxifa2','man2','1992-01-11','2015-06-16','computer',5000,'title');
insert into employee (id,name,gender,birthday,entry_date,job,salary,resume)values(4,'kaxifa4','man4','1992-01-11','2015-06-16','computer',5000,'title 2016');

2.搭建开发数据库的环境，主要是导一个连接数据库的文件

3.在myeclipse里新建一个lib文件夹，然后把包复制进去

然后build path   点add jars

4.可以用jdbc操作您的数据库了

package cn.hubt.demo;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;


public class TestMysql {
        
  public static void main(String  [] args) throws Exception{
  //1.加载数据库驱动
 Class.forName("com.mysql.jdbc.Driver");
     //不建议使用这种方式，原因是注册了两次驱动 DriverManager.registerDriver(new com.mysql.jdbc.Driver());
  
  //2.创建数据库的连接对象
  Connection  con=null;
  String url="jdbc:mysql://localhost:3306/day14";
  String user="root";
  String password="root";
  con=DriverManager.getConnection(url, user, password);
  //3.通过con对象创建操作数据库的statement对象
     Statement st=  con.createStatement();
     String sql="select * from employee";
     
    //4.用statement对象执行sql语句，返回结果集result，可以进行迭代了
     ResultSet rs= st.executeQuery(sql);
     while(rs.next()){
     int id=(int) rs.getObject("id");
     String name=(String) rs.getObject("name");
     String  gender=(String) rs.getObject("gender");


     System.out.println("id="+id);
     System.out.println("name="+name);
     System.out.println("gender="+gender);
     System.out.println("---------------------------------");
     
    }
    
    //5.关闭连接
    rs.close();
    st.close();
    con.close();


  
  
  }
 
}