你知道java jdbc如何实现增删改查吗?下面要给大家分享的就是这个方面的一个实例，一起来了解一下吧!
jdbc实现增删改查：
增删改操作
package java_web;
import java.sql.DriverManager;
import java.sql.SQLException;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
/**
* jdbc CURD
* @author Administrator
*
*/
public class rbacDemo
{
public final static String URL = "jdbc:mysql://localhost:3306/test";
public final static String USERNAME = "root";
public final static String PASSWORD = "";
public final static String DRIVER = "com.mysql.jdbc.Driver";
/**
* 插入
*/
public static void insert()
{
try
{
Class.forName(DRIVER);
Connection conn = (Connection) DriverManager.getConnection(URL, USERNAME, PASSWORD);
String sql = "insert into test(name,sex)values('fifi2',1),('fifi3',3)";
Statement state = (Statement) conn.createStatement();
int result = state.executeUpdate(sql);
state.close();
conn.close();
System.out.println(result + "success");
}
catch (ClassNotFoundException e)
{
// TODO 自动生成的 catch 块
e.printStackTrace();
}
catch (SQLException e)
{
// TODO 自动生成的 catch 块
e.printStackTrace();
}
}
public static void update()
{
try
{
Class.forName(DRIVER);
Connection conn = (Connection) DriverManager.getConnection(URL, USERNAME, PASSWORD);
String sql = "update test set name='fifi3aaa' where name='fifi3'";
Statement state = (Statement) conn.createStatement();
int result = state.executeUpdate(sql);
state.close();
conn.close();
System.out.println(result + "success");
}
catch (ClassNotFoundException e)
{
// TODO 自动生成的 catch 块
e.printStackTrace();
}
catch (SQLException e)
{
// TODO 自动生成的 catch 块
e.printStackTrace();
}
}
public static void delete()
{
try
{
Class.forName(DRIVER);
Connection conn = (Connection) DriverManager.getConnection(URL, USERNAME, PASSWORD);
String sql = "delete from test where name='fifi3aaa'";
Statement state = (Statement) conn.createStatement();
int result = state.executeUpdate(sql);
state.close();
conn.close();
System.out.println(result + "success");
}
catch (ClassNotFoundException e)
{
// TODO 自动生成的 catch 块
e.printStackTrace();
}
catch (SQLException e)
{
// TODO 自动生成的 catch 块
e.printStackTrace();
}
}
public static void main(String[] args)
{
//insert();
//update();
delete();
}
}查询操作
package java_web;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
public class jdbcQueryDemo
{
public final static String URL = "jdbc:mysql://localhost:3306/test";
public final static String USERNAME = "root";
public final static String PASSWORD = "";
public final static String DRIVER = "com.mysql.jdbc.Driver";
public static void query()
{
try
{
Class.forName(DRIVER);
Connection conn = (Connection) DriverManager.getConnection(URL, USERNAME, PASSWORD);
String sql = "select id,name,sex from test where id=3";
Statement state = (Statement) conn.createStatement();
ResultSet rs = state.executeQuery(sql);
while (rs.next())
{
//rs.getInt("id");
int id = rs.getInt(1);
String name = rs.getString(2);
int sex = rs.getInt(3);
//String time=rs.getString("vtime");
System.out.println(id + "==" + name + "==" + sex + "==");
}
rs.close();
state.close();
conn.close();
}
catch (ClassNotFoundException e)
{
// TODO 自动生成的 catch 块
e.printStackTrace();
}
catch (SQLException e)
{
// TODO 自动生成的 catch 块
e.printStackTrace();
}
}
public static void main(String[] args)
{
// TODO 自动生成的方法存根
query();
}
}java用jdbc编写增删改查的内容你都了解了吗?这个还是比较简单的，更多的java程序代码例子，可以继续通过奇Q工具网来进行了解呢。
推荐阅读：