Java jdbc增删改查操作 Java基于jdbc实现的增删改查操作示例

软件发布|下载排行|最新软件

当前位置:首页IT学院IT技术

Java jdbc增删改查操作 Java基于jdbc实现的增删改查操作示例

moliyiran   2021-03-30 我要评论

本文实例讲述了Java基于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程序设计有所帮助。

猜您喜欢

Copyright 2022 版权所有 软件发布 访问手机版

声明:所有软件和文章来自软件开发商或者作者 如有异议 请与本站联系 联系我们