JDBC

 

JDBC

在程序中加载驱动：DrivreManger.reqisterDriver(driver)

建立连接:

Connection conn = DriverManger.getConnection(url,user,password)

创建Statement对象：

Statement st = conn.createStatement()

执行SQL语句，获取ResultSet

  ResultSet rs = st.executeQuery(sql)

从Result中获取数据，显示

 rs.next()

rs.getObject(columnLabel)

释放资源：

rs.close()

st.close()

conn.close()

 

Connection

Statement createStatement()

创建Statement对象，Statement对象可以向数据库发送SQL语句

Statament

ResultSet executeQuery(String sql) 执行查询语句，返回结果集

CRUD是指在做计算机处理时的增加（Create）,查询（Retrieve）(重新得到数据)，更新（Update）和删除（Delete）几个单词的首字母简写。

Create

Statement st = conn.createStatement();

String sql = “insert into user(name,password,email,birthday)

Values(‘zl’,’11111’,’zl@itcast.cn’,’2011-2-19’)”;

St.executeUpdate(sql);

Retrieve

Statement st = conn.createStatement();

String sql = "select id,name,password,email,birthday from user";

ResultSet rs = st.executeQuery(sql);

 while(rs.next()) {

   System.out.print(rs.getInt(1) + "\t");

   System.out.print(rs.getString(2) + "\t");

Update

Statement st = conn.createStatement();

String sql = " update user set password='123456' where id=4";

st.executeUpdate(sql);

Delete

Statement st = conn.createStatement();

String sql = " delete from user where id='4'";

st.executeUpdate(sql);