jdbc连接mysql完成增删改查

package jdbc;


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


import org.junit.Test;










public class Jdbc {
@Test
public void fun() throws ClassNotFoundException, SQLException {
/*>driverClassName!com.mysql.jdbc.Driver
* url:jdbc:mysql://localhost:3306/sfs
* username:root
* password:123456
* 
* 
*/
Class.forName("com.mysql.jdbc.Driver");//加载驱动类
String url="jdbc:mysql://localhost:3306/sfs";
String username="root";
String password="123456";
Connection con=DriverManager.getConnection(url, username,password);
Statement sta=con.createStatement();//得到sta，发送sql语句
String sql="INSERT INTO stu VALUES(18,'chaiyang')";
int r =sta.executeUpdate(sql);//sta.executeUpdate()发送DDL,DML完成增删改操作
r=sta.executeUpdate("UPDATE stu SET name='chaiyanga' WHERE id=18");
System.out.println(r);
sta.close();
con.close();
}
/*
 * 查询
 */
@Test
public void fun2() throws ClassNotFoundException, SQLException  {
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/sfs";
String username="root";
String password="123456";
Connection con=DriverManager.getConnection(url, username, password);
Statement sta=con.createStatement();
ResultSet rs=sta.executeQuery("SELECT * FROM stu");//得到结果集，必须为查询语句
//解析ResultSet
while(rs.next()) {
int id=rs.getInt(1);//rs.getObject(1)通过列编号获取列
String name=rs.getString("name");
System.out.println(id+","+name);
}
/*
* 关闭资源
*/
rs.close();
sta.close();
con.close();
}
/**
 * 
 * @throws SQLException
 * 规范化操作，防止程序中出现Exception使con,sta,rs不能关闭
 */
@Test
public void fun3() throws SQLException {
Connection con=null;
Statement sta=null;
ResultSet rs=null;
try {
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/sfs";
String username="root";
String password="123456";
con=DriverManager.getConnection(url, username, password);
/*
* 创建statement
*/
sta=con.createStatement();
String sql="select * from stu";
/*
* 得到结果集
*/
rs=sta.executeQuery(sql);
/*
* 循环遍历rs
*/
while(rs.next()) {
int id=rs.getInt(1);//rs.getObject(1)通过列编号获取列
String name=rs.getString("name");
System.out.println(id+","+name);
}

}catch(Exception e) {}
finally {
if(rs!=null)rs.close();
if(sta!=null)sta.close();
if(con!=null)con.close();

}
}


}