java jdbc查询操作_Java基于jdbc实现的增删改查操作示例

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