<%@ page import="java.sql.*"%>
<%!
public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver" ;
public static final String DBURL = "jdbc:oracle:thin:@localhost:1521:ORCL" ;
public static final String DBUSER = "scott" ;
public static final String DBPASS = "scott" ;
%>
<% Connection conn = null ;
PreparedStatement stmt = null ;
try{
Class.forName(DBDRIVER) ;
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASS);
String sql="insert into message(name,content) values(?,?);";
stmt=conn.createPreparedStatement();
stmt.setString(1,aa);
stmt.setString(2,bbbbbbbbbbb);
stmt.executeUpdate();
stmt.close();
conn.close();
}
catch(Exception e){}
%>
<%!
public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver" ;
public static final String DBURL = "jdbc:oracle:thin:@localhost:1521:ORCL" ;
public static final String DBUSER = "scott" ;
public static final String DBPASS = "scott" ;
%>
<% Connection conn = null ;
PreparedStatement stmt = null ;
try{
Class.forName(DBDRIVER) ;
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASS);
String sql="insert into message(name,content) values(?,?);";
stmt=conn.createPreparedStatement();
stmt.setString(1,aa);
stmt.setString(2,bbbbbbbbbbb);
stmt.executeUpdate();
stmt.close();
conn.close();
}
catch(Exception e){}
%>
String sql="insert into message(name,content) values(?,?);";
stmt=conn.createPreparedStatement();
--------------------------------------
改成stmt=conn.createPreparedStatement(sql);
stmt.setString(1,aa);
stmt.setString(2,bbbbbbbbbbb);
setString方法参数是字符串,所以要用""将参数引起来。
改成
stmt=conn.prepareStatement(sql);而且
stmt.setString(2,bbbbbbbbbbb);
字符串不需要双引号吗
这倒是真没在意,我把异常贴给你
org.apache.jasper.JasperException: Unable to compile class for JSP:
JSP FileName:/test/test.jsp
Java FileName:/E:/Tomcat 5.5/work/Catalina/localhost/demo//org/apache/jsp/test\test_jsp.javaAn error occurred at line: 8 in the jsp file: /test/test.jsp
Syntax error on tokens, delete these tokens
5: public static final String DBUSER = "scott" ;
6: public static final String DBPASS = "scott" ;
7: %>
8: <% Connection conn = null ;
9: PreparedStatement stmt = null ;
10: try{
11: Class.forName(DBDRIVER) ;
Syntax error on tokens, delete these tokens
5: public static final String DBUSER = "scott" ;
6: public static final String DBPASS = "scott" ; 改:
String DBUSER = "scott" ;
String DBPASS = "scott" ;
<%@ page import="java.sql.*"%>
<%
public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver" ;
public static final String DBURL = "jdbc:oracle:thin:@localhost:1521:ORCL" ;
String DBUSER = "scott" ;
String DBPASS = "scott" ;
%>
<%
Connection conn = null ;
PreparedStatement stmt = null ;
try{
Class.forName(DBDRIVER) ;
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASS);
String sql="insert into message(name,content) values(?,?);";
stmt=conn.createPreparedStatement();
stmt.setString(1,"aa");
stmt.setString(2,"bbbbbbbbbbb");
stmt.executeUpdate();
stmt.close();
conn.commit();
conn.close();
}
catch(Exception e){}
%>