/**
* Insert channel
*
* @param channel_no channel no..
* @param channel_name channel name
* @param description description
* @param path channel path
* @param html_type html type
* @param igmp_addr_stb
* @param igmp_addr_pc500k
* @param igmp_addr_pc1500k
* @param chi_channel_name
*/
public void insertChannel(String channel_no,String channel_name,String description,
String path,String html_type,String igmp_addr_stb,
String igmp_addr_pc500k,String igmp_addr_pc1500k,String igmp_addr_vlc,
String chi_channel_name,String channel_type)
throws EPGException
{
String sql = "";
try
{
sql = "insert into p_channel " +
"(channel_no,channel_name,description,path," +
"html_type,igmp_addr_stb,igmp_addr_pc500k," +
"igmp_addr_pc1500k,igmp_addr_vlc,chi_channel_name,channel_type)" +
"values(?, ?, ?, ?," +
"?, ?, ?," +
"?, ?, ?, ?)";
/*
channel_no + "," + addquote(channel_name) + "," + addquote(description) + "," + addquote(path) + "," +
addquote(html_type) + "," + addquote(igmp_addr_stb) + "," + addquote(igmp_addr_pc500k) + "," +
addquote(igmp_addr_pc1500k) + "," + addquote(igmp_addr_vlc) + "," + addquote(chi_channel_name) + "," +
addquote(channel_type)+ ")";*/ pstmt = new LoggableStatement(con,sql);
pstmt.setString(1,channel_no);
pstmt.setString(2,channel_name);
pstmt.setString(3,description);
pstmt.setString(4,path);
pstmt.setString(5,html_type);
pstmt.setString(6,igmp_addr_stb);
pstmt.setString(7,igmp_addr_pc500k);
pstmt.setString(8,igmp_addr_pc1500k);
pstmt.setString(9,igmp_addr_vlc);
pstmt.setString(10,chi_channel_name);
pstmt.setString(11,channel_type); pstmt.executeUpdate();
pstmt.close();
/*
pstmt.executeUpdate();
st = con.createStatement();
st.executeUpdate(sql);*/ //System.out.println(sql);
}
catch(SQLException e)
{
throw new EPGException("Duplicated channel No..Insert channel in EPGDATA.insertChannel()" +
"SQLSTATMENT" + ((mfutil.LoggableStatement)pstmt).getQueryString() + "\n" + e.getMessage());
}
catch(Exception e)
{
throw new EPGException("Insert channel in EPGDATA.insertChannel()" +
"SQLSTATMENT" + ((mfutil.LoggableStatement)pstmt).getQueryString() + "\n" + e.getMessage());
}
}
* Insert channel
*
* @param channel_no channel no..
* @param channel_name channel name
* @param description description
* @param path channel path
* @param html_type html type
* @param igmp_addr_stb
* @param igmp_addr_pc500k
* @param igmp_addr_pc1500k
* @param chi_channel_name
*/
public void insertChannel(String channel_no,String channel_name,String description,
String path,String html_type,String igmp_addr_stb,
String igmp_addr_pc500k,String igmp_addr_pc1500k,String igmp_addr_vlc,
String chi_channel_name,String channel_type)
throws EPGException
{
String sql = "";
try
{
sql = "insert into p_channel " +
"(channel_no,channel_name,description,path," +
"html_type,igmp_addr_stb,igmp_addr_pc500k," +
"igmp_addr_pc1500k,igmp_addr_vlc,chi_channel_name,channel_type)" +
"values(?, ?, ?, ?," +
"?, ?, ?," +
"?, ?, ?, ?)";
/*
channel_no + "," + addquote(channel_name) + "," + addquote(description) + "," + addquote(path) + "," +
addquote(html_type) + "," + addquote(igmp_addr_stb) + "," + addquote(igmp_addr_pc500k) + "," +
addquote(igmp_addr_pc1500k) + "," + addquote(igmp_addr_vlc) + "," + addquote(chi_channel_name) + "," +
addquote(channel_type)+ ")";*/ pstmt = new LoggableStatement(con,sql);
pstmt.setString(1,channel_no);
pstmt.setString(2,channel_name);
pstmt.setString(3,description);
pstmt.setString(4,path);
pstmt.setString(5,html_type);
pstmt.setString(6,igmp_addr_stb);
pstmt.setString(7,igmp_addr_pc500k);
pstmt.setString(8,igmp_addr_pc1500k);
pstmt.setString(9,igmp_addr_vlc);
pstmt.setString(10,chi_channel_name);
pstmt.setString(11,channel_type); pstmt.executeUpdate();
pstmt.close();
/*
pstmt.executeUpdate();
st = con.createStatement();
st.executeUpdate(sql);*/ //System.out.println(sql);
}
catch(SQLException e)
{
throw new EPGException("Duplicated channel No..Insert channel in EPGDATA.insertChannel()" +
"SQLSTATMENT" + ((mfutil.LoggableStatement)pstmt).getQueryString() + "\n" + e.getMessage());
}
catch(Exception e)
{
throw new EPGException("Insert channel in EPGDATA.insertChannel()" +
"SQLSTATMENT" + ((mfutil.LoggableStatement)pstmt).getQueryString() + "\n" + e.getMessage());
}
}
解决方案 »
- 急急急急!!!!soapUI 调用web服务 CDATA 问题!!!!在线等。。。。。
- struts.xml在myeclipse8.5下正常,但在myeclipse9下就有语法错误
- 在struts1中修改struts-config.xml时出错
- 神一般的if语句(100)分
- tomcat5.5中同时访问oracle和sql server有问题
- Publishing failed with multiple errors
- weblogic加载webwork 问题
- JSP程序有错,解决就给分。
- 请问各位大虾:如何判断一个字符串是不是中文
- 连续上传两张图片,jsp显示页面就刷新不了,只有重启tomcat才能显示
- 请问如何实现在线安装就想这种的,http://www.szicbc.com.cn/zxbz/webcall/installing.html
- Javabean 调用不到!FAQ已看了N遍。
可以先用转义符操作字符串.之后用Prepare statement