jdbc 增删改
来源:互联网 发布:淘宝详情页视频时间 编辑:程序博客网 时间:2024/05/16 13:53
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();
}
}
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();
}
}
0 0
- Jdbc 增删改查
- jdbc增删改查
- JDBC 增删改查
- jdbc增删改查
- jdbc增删查改
- JDBC 增删改查
- jdbc:增删改查
- jdbc 增删改
- jdbc---增删改查
- jdbc的增删改查
- JDBC 增删查改(1)
- JDBC 增删查改(2)
- JDBC增删改查实例
- JDBC---数据库连接增删改查
- JDBC 实现增删改查
- Struts2 jdbc 增删改查
- JDBC增删改查MVC
- JDBC增删查改3
- Android5.0之CardView
- 剑指offer面试题18:树的子结构
- NOIP2015运输计划 题解
- POJ 1204 Word Puzzles(AC自动机)
- Codeforces Round #164 (Div. 2) C. Beautiful Sets of Points【思维题】
- jdbc 增删改
- 数据结构实验之链表三:链表的逆置
- JavaIO之OJ上面的输入输出
- [leetcode]11. Container With Most Water
- POJ 3320 Jessica's Reading Problem (HASH, 尺取法)
- 【Python】Python_learning10_1:Python中的素数筛选(方法一)
- POJ 2139 Six Degrees of Cowvin Bacon(最短路)
- Manthan, Codefest 16 D. Fibonacci-ish
- 设计模式:法则篇