/*
描述:连接数据库检测
编写人:寇国庆
编写日期:20090414
*/
import java.sql.*;
public class TestConnect{
public static void main(String args[]){
try{
//装载驱动程序
Class.forName("com.informix.jdbc.IfxDriver");
String SourceURL="jdbc:informix-sqli://10.1.0.243:10001/business:INFORMIXSERVER=onjhmcis2;user=informix;password=info2004";
//建立连接
Connection databaseconnection = DriverManager.getConnection(SourceURL);
//System.out.println("Database Connection successfully!");
//关闭连接
//dc.close();
//声明一个语句
Statement stmt = databaseconnection.createStatement();
//数据集
ResultSet result = stmt.executeQuery("select id,name from shop where shoptype=11");
while (result.next()){
System.out.println(result.getString("id")+" "+result.getString("name"));
}
databaseconnection.close();
}catch(ClassNotFoundException cnfe){
System.err.println(cnfe);
}
catch(SQLException sqle){
System.err.println(sqle);
}
}
}