import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class JDBCcon {
public static void main(String[] args) {
try{
Class.forName("com.ibm.db2.jcc.DB2Driver");
Connection conn = DriverManager.getConnection("jdbc:db2://localhost:50001/STAT","hamilton","512472226");
Statement st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet rs = st.executeQuery("select * from employee");
while(rs.next()){
int id = rs.getInt(1);
System.out.println("id="+id);
String name = rs.getString(2);
System.out.println("name="+name);
if (rs.wasNull()) {
System.out.println("name is null");
} else {
System.out.println("name is not null");
}
System.out.println("---------------");
}
rs.close();
st.close();
conn.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
a test JDBC/DB2
最新推荐文章于 2021-03-06 15:31:32 发布