<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="sqlbean" scope="page" class="news.sql_data"/>
<HTML>
<head><title>抓取规则设定</title></head>
<body>
<%
String web_id=request.getParameter("web_id");
if(web_id==null) web_id="";
String inner_id=request.getParameter("inner_id");
if(inner_id==null) inner_id="";
String outer_key=request.getParameter("outer_key");
if(outer_key==null) outer_key="";
String author=request.getParameter("author");
if(author==null) author="";
String resource=request.getParameter("resource");
if(resource==null) resource="";
String time=request.getParameter("time");
if(time==null) time="";
String img=request.getParameter("img");
if(img==null) img="";
String next=request.getParameter("next");
if(next==null) next="";
String start=request.getParameter("start");
if(start==null) start="";
String end=request.getParameter("end");
if(end==null) end="";
//sqlbean.executeUpdate("insert into catcher.capture_rule(outer_id,inner_id,keyword,author,fromwhere,time_publish,picture,next_page,content_end) values('0002','','outer_key','author','resource','time','img','next','end')");
String sql="insert into catcher.capture_rule(outer_id,inner_id,keyword,author,fromwhere,time_publish,picture,next_page,content_start,content_end) values('"+web_id+"',"+inner_id+",'"+outer_key+"','"+author+"','"+resource+"','"+time+"','"+img+"','"+next+"','"+start+"','"+end+"')";
sqlbean.executeUpdate(sql);
%>
保存成功了!网页5秒钟内将自动跳转到网站维护页面,如果您的浏览器不支持自动跳转,可以点击下面的链接:
<META HTTP-EQUIV="REFRESH" CONTENT="5;url=regular1.jsp">
<a href="regular1.jsp">跳转</a>
</body>
</HTML>运行没有错误提示,可是数据没有存到数据库里,怎么回事啊,大家帮我看看!!!
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="sqlbean" scope="page" class="news.sql_data"/>
<HTML>
<head><title>抓取规则设定</title></head>
<body>
<%
String web_id=request.getParameter("web_id");
if(web_id==null) web_id="";
String inner_id=request.getParameter("inner_id");
if(inner_id==null) inner_id="";
String outer_key=request.getParameter("outer_key");
if(outer_key==null) outer_key="";
String author=request.getParameter("author");
if(author==null) author="";
String resource=request.getParameter("resource");
if(resource==null) resource="";
String time=request.getParameter("time");
if(time==null) time="";
String img=request.getParameter("img");
if(img==null) img="";
String next=request.getParameter("next");
if(next==null) next="";
String start=request.getParameter("start");
if(start==null) start="";
String end=request.getParameter("end");
if(end==null) end="";
//sqlbean.executeUpdate("insert into catcher.capture_rule(outer_id,inner_id,keyword,author,fromwhere,time_publish,picture,next_page,content_end) values('0002','','outer_key','author','resource','time','img','next','end')");
String sql="insert into catcher.capture_rule(outer_id,inner_id,keyword,author,fromwhere,time_publish,picture,next_page,content_start,content_end) values('"+web_id+"',"+inner_id+",'"+outer_key+"','"+author+"','"+resource+"','"+time+"','"+img+"','"+next+"','"+start+"','"+end+"')";
sqlbean.executeUpdate(sql);
%>
保存成功了!网页5秒钟内将自动跳转到网站维护页面,如果您的浏览器不支持自动跳转,可以点击下面的链接:
<META HTTP-EQUIV="REFRESH" CONTENT="5;url=regular1.jsp">
<a href="regular1.jsp">跳转</a>
</body>
</HTML>运行没有错误提示,可是数据没有存到数据库里,怎么回事啊,大家帮我看看!!!
package news;
import java.sql.*;
public class sql_data{
String sDBDriver = "oracle.jdbc.driver.OracleDriver";
String url="jdbc:oracle:thin:@202.118.11.54:1521:webcatch"; String user="catcher";
String password="catcher";
Connection conn= null;
Statement stmt = null;
ResultSet rs = null;
public sql_data()
{
try
{Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("sql_data(): " + e.getMessage());
}
}
public void executeInsert(String sql)
{
try
{//conn = DriverManager.getConnection(url,user,password);
conn = DriverManager.getConnection(url,user,password);
stmt = conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
conn.close();
}
catch(SQLException ex)
{System.err.println("sql_data.executeUpdate:"+ex.getMessage());
}
}
public ResultSet executeQuery(String sql)
{
try
{
conn = DriverManager.getConnection(url,user,password);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("sql_data.executeQuery:"+ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql)
{
try {
conn = DriverManager.getConnection(url,user,password);
stmt = conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
}
public void executeDelete(String sql)
{
try
{conn = DriverManager.getConnection(url,user,password);
stmt = conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
}
catch(SQLException ex)
{
System.err.println("sql_data.executeDelete:"+ex.getMessage());
}
}
public void closeStmt(){
try{
stmt.close();
}
catch(SQLException e){
e.printStackTrace();
}
}public void closeConn(){
try{
conn.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
}
public void executeUpdate(String sql)
{
conn = DriverManager.getConnection(url,user,password);
stmt = conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
}
你把这个方法改成上面那样 再运行 看跑出什么异常
那样编译不了,说是没有异常处理
{
conn = DriverManager.getConnection(url,user,password);
stmt = conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
}这样改
??????????怎么改