数据库获取数据servlet程序时出错 [英] Error in database fetching data servlet program
问题描述
C:\ J2ee \ Servlet> javac RequestServlet.java
RequestServlet.java:17:错误:< identifier>预期
class.forName(Oracle.jdbc.driver.OracleDriver);
^
RequestServlet.java:17:错误:无效方法声明;需要返回类型
class.forName(Oracle.jdbc.driver.OracleDriver);
^
RequestServlet.java:17:错误:非法启动类型
class.forName(Oracle.jdbc.driver.OracleDriver);
^
RequestServlet.java:24 :错误:< identifier>预期
out.println(
);
^
RequestServlet.java:24:错误:非法开始类型
out.println(
);
^
RequestServlet.java:25:错误:< identifier>预期
out.println();
^
RequestServlet.java:25:错误:非法启动类型
out.println();
^
RequestServlet.java:26:错误:非法启动类型
for (int i = 1; i< = rsmd.getColumnCount(); i ++)
^
RequestServlet.java:26:错误:')'预期
for(int i = 1; i< = rsmd.getColumnCount(); i ++)
^
RequestServlet.java:26:错误:非法启动类型
for(int i = 1; i< = rsmd.getColumnCount(); i ++)
^
RequestServlet.java:26:错误:< identifier>预期
for(int i = 1; i< = rsmd.getColumnCount(); i ++)
^
RequestServlet.java:26:错误:';'预期
for(int i = 1; i< = rsmd.getColumnCount(); i ++)
^
RequestServlet .java:26:错误:非法启动类型
for(int i = 1; i< = rsmd.getColumnCount(); i ++)
^
RequestServlet.java:26:错误:';'预期
for(int i = 1; i< = rsmd.getColumnCount(); i ++)
^
RequestServlet.java:26:错误:方法声明无效;返回类型需要
for(int i = 1; i< = rsmd.getColumnCount(); i ++)
^
RequestServlet.java: 26:错误:< identifier>预期
for(int i = 1; i< = rsmd.getColumnCount(); i ++)
^
RequestServlet.java:26:错误:非法启动类型
for(int i = 1; i< = rsmd.getColumnCount(); i ++)
^
RequestServlet .java:26:错误:< identifier>预期
for(int i = 1; i< = rsmd.getColumnCount(); i ++)
^
RequestServlet.java:27:错误:';'预计
{
^
RequestServlet.java:28:错误:非法启动类型
out.println(
);
^
RequestServlet.java:28:错误:非法启动类型
out.println(
);
^
RequestServlet.java:28:错误:')'预期
out.println(
);
^
RequestServlet.java:28:错误:' ;'预计
out.println(
);
^
RequestServlet.java:28:错误:非法启动类型
out.println(
);
^
RequestServlet.java:28:错误:< identifier>预期
out.println(
);
^
RequestServlet.java:28:错误: ';'预计
out.println(
);
^
26个错误>
我尝试过:
import javax.servlet。*;
import java.io. *;
import java.sql。*;
公共类RequestServlet扩展HttpServlet
{
public void doPost(HttpServletRequest req,HttpServletResponse res)抛出ServletException,IOException
{
res.setContentType(Text / Html);
PrintWriter out = res.getWriter();
out.println();
String name = req.getParameter(Name);
String pass = req.getParameter(Pa ss);
尝试
{
class.forName(oracle.jdbc.driver.OracleDriver);
连接c = DriverManager.getConnection(jdbc:Oracle:thin:@localhost:1521:xe,SYSTEM,oracle123);
语句s = c.createStatement() ;
int x = s.executeUpdate(插入emp101值('+ name +','+ pass +'));
ResultSet rs = s.executeQuery(select * from emp101);
ResultSetMetaData rsmd = rs.getMetaData();
out.println(
+ rsmd.getColumnName(i)+ | + rsmd。 getColumnName(ⅰ)+ 次> | + rsmd.getColumnName(ⅰ)+ 次> | + rsmd.getColumnName(ⅰ)+ 次> | +更正了RSMD .getColumnName(ⅰ)+ 次> | + rsmd.getColumnName(ⅰ)+ 次> | + rsmd.getColumnName(ⅰ)+次> |
---|
out.println();
for(int i = 1; i< = rsmd.getColumnCount(); i ++)
{
out.println();
}
while(rs.next())
{
out.println();
out.println();
out.println();
out.println();
}
}
catch(例外e)
{
}
out.println(
+ rsmd.getColumnName(i) + 次> | |
---|---|
+ rs.getString(1)+ | + rs.getString(2)+ |
}
}
C:\J2ee\Servlet>javac RequestServlet.java
RequestServlet.java:17: error: <identifier> expected
class.forName("Oracle.jdbc.driver.OracleDriver");
^
RequestServlet.java:17: error: invalid method declaration; return type required
class.forName("Oracle.jdbc.driver.OracleDriver");
^
RequestServlet.java:17: error: illegal start of type
class.forName("Oracle.jdbc.driver.OracleDriver");
^
RequestServlet.java:24: error: <identifier> expected
out.println("
");
^
RequestServlet.java:24: error: illegal start of type
out.println("
");
^
RequestServlet.java:25: error: <identifier> expected
out.println("");
^
RequestServlet.java:25: error: illegal start of type
out.println("");
^
RequestServlet.java:26: error: illegal start of type
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: ')' expected
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: illegal start of type
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: <identifier> expected
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: ';' expected
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: illegal start of type
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: ';' expected
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: invalid method declaration; return type required
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: <identifier> expected
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: illegal start of type
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:26: error: <identifier> expected
for(int i=1;i<=rsmd.getColumnCount();i++)
^
RequestServlet.java:27: error: ';' expected
{
^
RequestServlet.java:28: error: illegal start of type
out.println(""
);
^
RequestServlet.java:28: error: illegal start of type
out.println(""
);
^
RequestServlet.java:28: error: ')' expected
out.println(""
);
^
RequestServlet.java:28: error: ';' expected
out.println(""
);
^
RequestServlet.java:28: error: illegal start of type
out.println(""
);
^
RequestServlet.java:28: error: <identifier> expected
out.println(""
);
^
RequestServlet.java:28: error: ';' expected
out.println(""
);
^
26 errors
What I have tried:
import javax.servlet.*;
import java.io.*;
import java.sql.*;
public class RequestServlet extends HttpServlet
{
public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
{
res.setContentType("Text/Html");
PrintWriter out=res.getWriter();
out.println("");
String name=req.getParameter("Name");
String pass=req.getParameter("Pass");
try
{
class.forName("oracle.jdbc.driver.OracleDriver");
Connection c=DriverManager.getConnection("jdbc:Oracle:thin:@localhost:1521:xe","SYSTEM","oracle123");
Statement s=c.createStatement();
int x=s.executeUpdate("insert into emp101 values('"+name+"','"+pass+"')");
ResultSet rs=s.executeQuery("select * from emp101");
ResultSetMetaData rsmd=rs.getMetaData();
out.println("
"+rsmd.getColumnName(i)+" | "+rsmd.getColumnName(i)+" | "+rsmd.getColumnName(i)+" | "+rsmd.getColumnName(i)+" | "+rsmd.getColumnName(i)+" | "+rsmd.getColumnName(i)+" | "+rsmd.getColumnName(i)+" |
---|
out.println("");
for(int i=1;i<=rsmd.getColumnCount();i++)
{
out.println("");
}
while(rs.next())
{
out.println("");
out.println("");
out.println("");
out.println("");
}
}
catch(Exception e)
{
}
out.println("
"+rsmd.getColumnName(i)+" | |
---|---|
"+rs.getString(1)+" | "+rs.getString(2)+" |
}
}
推荐答案
你拼写了它class
,但它应该是Class
,大写字母C在beginnng。请参阅类(Java Platform SE 7) [ ^ ]。
You have spelled itclass
, but it should beClass
with upper case C at the beginnng. See Class (Java Platform SE 7 )[^].
这篇关于数据库获取数据servlet程序时出错的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!