建表语句:
create table test (id int,name varchar(20),password varchar(20))
插入一条数据:
insert into test values (1,'zhu','yan')
java 代码:
package com.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class ConnToDb2 {
//获得数据库连接
public static Connection getconn(String location,String username,String password)
{
Connection conn = null;
try {
Class.forName("com.ibm.db2.jcc.DB2Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
conn = DriverManager.getConnection(location,username,password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
//查询数据
public static void select()throws Exception
{
Connection conn = getconn("jdbc:db2://192.168.10.100:50000/yan", "db2inst1", "abc");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select *from test");
System.out.println("表中的数据如下:");
while (rs.next())
{
System.out.println(rs.getInt(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3));
}
stmt.close();
conn.close();
}
//插入数据
public static void insert()throws Exception
{
System.out.println("插入数据....");
Connection conn = getconn("jdbc:db2://192.168.10.100:50000/yan", "db2inst1", "abc");
Statement stmt = conn.createStatement();
int rs = stmt.executeUpdate("insert into test values (3,'li','si')");
stmt.close();
conn.close();
System.out.println();
}
//跟新数据
public static void update()throws Exception
{
System.out.println("更新数据....");
Connection conn = getconn("jdbc:db2://192.168.10.100:50000/yan", "db2inst1", "abc");
Statement stmt = conn.createStatement();
int rs = stmt.executeUpdate("update test set password='kkk' where name='li'");
stmt.close();
conn.close();
System.out.println();
}
//删除数据
public static void delete()throws Exception
{
System.out.println("删除数据....");
Connection conn = getconn("jdbc:db2://192.168.10.100:50000/yan", "db2inst1", "abc");
Statement stmt = conn.createStatement();
int rs = stmt.executeUpdate("delete from test where name='li'");
System.out.println();
stmt.close();
conn.close();
}
public static void main(String[] args)throws Exception {
ConnToDb2 con = new ConnToDb2();
con.select();
con.insert();
con.select();
con.update();
con.select();
con.delete();
con.select();
}
//获得数据库连接
public static Connection getconn(String location,String username,String password)
{
Connection conn = null;
try {
Class.forName("com.ibm.db2.jcc.DB2Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
conn = DriverManager.getConnection(location,username,password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
//查询数据
public static void select()throws Exception
{
Connection conn = getconn("jdbc:db2://192.168.10.100:50000/yan", "db2inst1", "abc");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select *from test");
System.out.println("表中的数据如下:");
while (rs.next())
{
System.out.println(rs.getInt(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3));
}
stmt.close();
conn.close();
}
//插入数据
public static void insert()throws Exception
{
System.out.println("插入数据....");
Connection conn = getconn("jdbc:db2://192.168.10.100:50000/yan", "db2inst1", "abc");
Statement stmt = conn.createStatement();
int rs = stmt.executeUpdate("insert into test values (3,'li','si')");
stmt.close();
conn.close();
System.out.println();
}
//跟新数据
public static void update()throws Exception
{
System.out.println("更新数据....");
Connection conn = getconn("jdbc:db2://192.168.10.100:50000/yan", "db2inst1", "abc");
Statement stmt = conn.createStatement();
int rs = stmt.executeUpdate("update test set password='kkk' where name='li'");
stmt.close();
conn.close();
System.out.println();
}
//删除数据
public static void delete()throws Exception
{
System.out.println("删除数据....");
Connection conn = getconn("jdbc:db2://192.168.10.100:50000/yan", "db2inst1", "abc");
Statement stmt = conn.createStatement();
int rs = stmt.executeUpdate("delete from test where name='li'");
System.out.println();
stmt.close();
conn.close();
}
public static void main(String[] args)throws Exception {
ConnToDb2 con = new ConnToDb2();
con.select();
con.insert();
con.select();
con.update();
con.select();
con.delete();
con.select();
}
}
访问结果:
表中的数据如下:
1 zhu yan
插入数据....
1 zhu yan
插入数据....
表中的数据如下:
1 zhu yan
3 li si
更新数据....
1 zhu yan
3 li si
更新数据....
表中的数据如下:
1 zhu yan
3 li kkk
删除数据....
1 zhu yan
3 li kkk
删除数据....
表中的数据如下:
1 zhu yan
1 zhu yan
转载于:https://blog.51cto.com/mervin/188669