JAVA 操作DB2 数据库实现增、删、改、查功能.docxVIP

importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;/** * 练习DB2 数据库中，实现增、删、改、查 * @author Administrator * */public class MainDemo {public static void main(String[] args) {try {//1、运行程序的时候要先把db2的驱动 db2java.zip, db2jcc.jar 加载到项目中//2、创建表 ENTERPRISE(ID INT,USERNAME VARCHAR(20),SEX VARCHAR(10));Class.forName(com.ibm.db2.jcc.DB2Driver).newInstance();String url = jdbc:db2://192.168.0.110:50000/MEIPDB;//端口：50000 数据库名称：MEIPDB String user = db2admin;//登陆用户String pswd = 888888aa_;//登陆密码//1、查询数据queryData(url,user,pswd);//2、添加记录addData(url,user,pswd);//3、修改记录updateData(url,user,pswd);//4、删除记录deleteData(url,user,pswd);} catch (Exception e) {e.printStackTrace();} }/** * 查询数据 * @paramurl连接串 * @param user 用户名称 * @parampwd用户密码 */public static void queryData(String url,Stringuser,Stringpwd){try {Connection conn = DriverManager.getConnection(url, user, pwd);//1、查询记录String querySQL = SELECT * FROM ENTERPRISE;PreparedStatement ps1 = conn.prepareStatement(querySQL);ResultSet rs1 = ps1.executeQuery();while(rs1.next()){System.out.println(ID：+rs1.getString(ID)+ 名称：+rs1.getString(USERNAME)+ 性别：+rs1.getString(SEX));}rs1.close();ps1.close();conn.close();} catch (Exception e) {e.printStackTrace();} }/** * 添加记录 * @paramurl连接串 * @param user 用户名称 * @parampwd用户密码 */public static void addData(String url,Stringuser,Stringpwd){try {Connection conn = DriverManager.getConnection(url, user, pwd);//1、查询记录String updateSQL = INSERT INTO ENTERPRISE(ID,USERNAME,SEX) VALUES(1006,TOMERer,男);PreparedStatement ps1 = conn.prepareStatement(updateSQL);ps1.execute();ps1.close();conn.close();} catch (Exception e) {e.printStackTrace();} }/** * 更新记录 * @paramurl连接串 * @param user 用户名称 * @parampwd用户密码 */public static void updateData(String url,Stringuser,Stringpwd){try {Connection conn = DriverManager.getConnection(url, user, pwd);//1、查询记录String updateSQL = UPDATE ENTERPRISE SET USERNAME=HANMEI WHERE ID=1006;PreparedStatement ps1 = conn.prepareStatement(updateSQL)