import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
/**
* @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_";//登陆密码陕北
queryData(url,user,pswd);
addData(url,user,pswd);
// 3、修改记录
updateData(url,user,pswd);
//4、删除记录
deleteData(url,user,pswd);
} catch (Exception e) {司法公信力
e.printStackTrace();
}
}
/**
* 查询数据
* @param url 连接串
* @param user 用户名称
* @param pwd 用户密码
*/
public static void queryData(String url,String user,String pwd){
try {
Connection conn = Connection(url, user, pwd);
//1、查询记录
String querySQL = "SELECT * FROM ENTERPRISE";
小学数学课堂教学的有效性 PreparedStatement ps1 = conn.prepareStatement(querySQL);
ResultSet rs1 = uteQuery();
()){
System.out.println("ID:"+String("ID")+" 名称:"+String("USERNAME")+" 性别:"+String("SEX"));
}
rs1.close();
ps1.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 添加记录
* @param url 连接串
* @param user 用户名称
* @param pwd 用户密码
*/
public static void addData(String url,String user,String pwd){
try {
Connection conn = Connection(url, user, pwd);
//1、查询记录
String updateSQL = "INSERT INTO ENTERPRISE(ID,USERNAME,SEX) VALUES(1006,'TOMERer','男')";
PreparedStatement ps1 = conn.prepareStatement(updateSQL);
ute();
ps1.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 更新记录
* @param url 连接串
* @param user 用户名称
* @param pwd 用户密码
*/
public static void updateData(String url,String user,String pwd){
try {
Connection conn = Connection(url, user, pwd);
//1、查询记录
String updateSQL = "UPDATE ENTERPRISE SET USERNAME='HANMEI' WHERE ID=1006";
PreparedStatement ps1 = conn.prepareStatement(updateSQL);
ute();
ps1.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 删除记录
* @param url 连接串
* @param user 用户名称
* @param pwd 用户密码
*/
public static void deleteData(String url,String user,String pwd){
5060lu try {
Connection conn = Connection(url, user, pwd);
武当一阳指
//1、查询记录
String delId = "1001";
String deleteSQL = "DELETE FROM ENTERPRISE WHERE ID ="+delId;
PreparedStatement ps1 = conn.prepareStatement(deleteSQL);
ute();
ps1.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}