一样的啊
void f()
{
Context ctx;
Connection myConn = null;
Statement st = null;
ResultSet rs = null;
String sSql;
try{
ctx = new InitialContext();
javax.sql.DataSource ds = (javax.sql.DataSource)ctx.lookup("java:/MySqlDS");
myConn = ds.getConnection();
st = myConn.createStatement();
sSql = "insert into DataInfo values('";
sSql += di.WebOSIP+"','";
sSql += di.WebOSStyle+"','";
sSql += di.DatabaseOSIP+"','";
sSql += di.DatabaseOSStyle+"','";
sSql += di.InitFile+"','";
sSql += di.DatabaseBackupDirectory+"','";
sSql += di.TableBackupDirectory+"','";
sSql += di.WebOSMysqlDirectory+"','";
sSql += di.DatabaseName+"','";
sSql += di.DatabaseUserName+"','";
sSql += di.DatabasePassword+"')";
sSql = new String(sSql.getBytes("GB2312"),"iso8859-1");
st.execute(sSql);
}
catch (Exception e)
{
throw new DataManagerException(MethodPrefix + e.getMessage());
}
finally{
try{
if (rs != null) rs.close();
if (st != null) st.close();
if (myConn != null) myConn.close();
}
catch(Exception e){
}
}
}
void f()
{
Context ctx;
Connection myConn = null;
Statement st = null;
ResultSet rs = null;
String sSql;
try{
ctx = new InitialContext();
javax.sql.DataSource ds = (javax.sql.DataSource)ctx.lookup("java:/MySqlDS");
myConn = ds.getConnection();
st = myConn.createStatement();
sSql = "insert into DataInfo values('";
sSql += di.WebOSIP+"','";
sSql += di.WebOSStyle+"','";
sSql += di.DatabaseOSIP+"','";
sSql += di.DatabaseOSStyle+"','";
sSql += di.InitFile+"','";
sSql += di.DatabaseBackupDirectory+"','";
sSql += di.TableBackupDirectory+"','";
sSql += di.WebOSMysqlDirectory+"','";
sSql += di.DatabaseName+"','";
sSql += di.DatabaseUserName+"','";
sSql += di.DatabasePassword+"')";
sSql = new String(sSql.getBytes("GB2312"),"iso8859-1");
st.execute(sSql);
}
catch (Exception e)
{
throw new DataManagerException(MethodPrefix + e.getMessage());
}
finally{
try{
if (rs != null) rs.close();
if (st != null) st.close();
if (myConn != null) myConn.close();
}
catch(Exception e){
}
}
}
解决方案 »
- 如何改写一个CSV文件
- ===求教:struts1.x 读服务器端文件,将文件内容输出到页面中===
- hibernate映射问题
- spring注入的属性不能被继承?
- HTTP Status 404 - /myweb/servlet/mypackage.forky
- 定位特定属性值的节点,再在这个节点里的末尾添加新的子节点
- 请教cookie的问题
- Jboss+JbuilderX连接数据库连接池!!和奇怪!我明明是用的OracleDS这个连接池的JNDI可是他怎么总是在SqlServer中访问数据??
- 根路径问题
- winxp下,applet在ie浏览器为何无法显示、
- 各位老大,给出每个标签是作什么用的!在线等待,全部答出立即给分,不够再加!多谢!!!1
- jsp连bean 为什么连不上呢,总说找不到bean?
create方法就是insert,
remove方法就是delete
setXXX()就是update啦