Connection conn=null;
Statement st=null;
ResultSet rs=null;
Class.forName("com.informix.jdbc.IfxDriver");
conn =DriverManager.getConnection("jdbc:informix-sqli://10.86.175.52:6666/hr:informixserver=test_shm_1","informix","123456");
st = conn.createStatement();
rs=st.executeQuery("select parm_id,parm_name,parm_data from hr_parm");
if(rs.next()){}
Statement st=null;
ResultSet rs=null;
Class.forName("com.informix.jdbc.IfxDriver");
conn =DriverManager.getConnection("jdbc:informix-sqli://10.86.175.52:6666/hr:informixserver=test_shm_1","informix","123456");
st = conn.createStatement();
rs=st.executeQuery("select parm_id,parm_name,parm_data from hr_parm");
if(rs.next()){}
解决方案 »
- java不能做高端产品吗?请看截图!
- tomcat下直接输入ip(如192.168.1.15)就能打开在目录 Tomcat 5.5\webapps\bs 下的 login.jsp,如何做?请教了!!!
- web上报表,大家如何开发的,或者借用什么工具,调查。。。。
- 一个Tomcat的安装问题
- 搞网站开发,jsp j2ee asp asp.net c# php 哪种技术用得人多,好用啊 什么开发工具比较主流
- 请问服务端的handler怎么部署
- SAXReader的问题
- socket 客户端每调用一次都会自动关闭,能不能循环监听?
- Java 如何访问COM组件???
- tomcat 调用 jboss中的EJB的问题
- Struts 错误2!
- 在weblogic7.0中,如何将用domain configure wizard生成的user-project删除掉??
dbConnection=DriverManager.getConnection("jdbc:db2://192.168.35.8/MS","user","password"); 连接
/*
数据库基础通用JavaBean
设计人:王晋
开始设计时间2002.7.25
*/import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;class DataBaseOper
{
private String _JdbcDriver = null;
private String _JdbcURL = null;
private String _UserName = null;
private String _PassWord = null;
private Connection _con = null; public DataBaseOper(String JdbcDriver,String JdbcURL,String UserName,String PassWord)
{
_JdbcDriver = JdbcDriver;
_JdbcURL = JdbcURL;
_UserName = UserName;
_PassWord = PassWord;
ConnectionData();
} //创建数据库连接
private void ConnectionData()
{
try
{
Class.forName(_JdbcDriver);
_con = DriverManager.getConnection(_JdbcURL, _UserName, _PassWord);
}
catch(Exception e)
{
System.out.println(e);
}
} //执行一个SQL语句
public boolean ExecutiveSql(String Sql)
{
boolean ret = false;
Statement Stmt = null;
try
{
Stmt = _con.createStatement();
ret = Stmt.execute(Sql);
Stmt.close();
}
catch(Exception e)
{
System.out.println(e);
}
return ret;
} //执行一个SQL语句返回记录集
public ResultSet GetDataSet(String Sql)
{
ResultSet DataSet = null;
Statement Stmt = null;
try
{
Stmt = _con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
DataSet = Stmt.executeQuery(Sql);
}
catch(Exception e)
{
System.out.println(e);
}
return DataSet;
} //执行一个事务
public boolean ExecutiveTransaction(String[] Sqls)
{
boolean ret = false;
int i;
Statement Stmt = null; try
{
_con.setAutoCommit(false);
Stmt = _con.createStatement();
for(i = 0; i < (Sqls.length - 1); i++)
{
ret = Stmt.execute(Sqls[i]);
}
}
catch(Exception e)
{
System.out.println(e);
try
{
_con.rollback();
_con.setAutoCommit(true);
ret = false;
}
catch(Exception f)
{
System.out.println(f);
ret = false;
}
}
return ret;
}
}