Java Sample Addition and Deletion Check Operation Based on jdbc Implementation

This paper describes an example of Java's add-delete check operation based on jdbc.Share it for your reference, as follows:

Add, delete and change actions:

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";
/**
*  insert 
*/
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  Auto-generated  catch  block 
e.printStackTrace();
} catch (SQLException e) {
// TODO  Auto-generated  catch  block 
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  Auto-generated  catch  block 
e.printStackTrace();
} catch (SQLException e) {
// TODO  Auto-generated  catch  block 
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  Auto-generated  catch  block 
e.printStackTrace();
} catch (SQLException e) {
// TODO  Auto-generated  catch  block 
e.printStackTrace();
}
}
public static void main(String[] args){
//insert();
//update();
delete();
}
}

Query operation:

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  Auto-generated  catch  block 
e.printStackTrace();
} catch (SQLException e) {
// TODO  Auto-generated  catch  block 
e.printStackTrace();
}
}
public static void main(String[] args) {
// TODO  Auto-generated method stub 
query();
}
}

More readers interested in java-related content can view this site's topics: Java Operation Database Skills Summary, Java+MySQL Database Programming Summary, Java Data Structure and Algorithms Tutorial, Java File and Directory Operation Skills Summary, Java Operation DOM Node Skills Summary, and Java Cache Operation Skills Summary.

I hope that the description in this paper will be helpful to everyone's java program design.