用sevrlet编写的创建库的程序，出错（HTTP Status 500），请高手执教
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class CreateDB extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
String driverClass=getInitParameter( "driverClass ");
url=getInitParameter( "driverClass ");
user=getInitParameter( "user ");
password=getInitParameter( "password ");
try
{
Class.forName(driverClass);
}
catch(ClassNotFoundException ce)
{
throw new UnavailableException( "加载数据库驱动失败！ ");
}
//--------------------------------------
Connection conn=null;
Statement stmt=null;
try
{
conn=DriverManager.getConnection(url, user, password);
stmt=conn.createStatement();
stmt.executeUpdate( "create database bookstore ");
stmt.execute( "use bookstore ");
stmt.execute( "create tableBookInfo( "
+ "id INT not null primary key "
+ "title VERCHAR(50)not null "
+ "author VACHAR(50) not null, "
+ "bookconcernVARCHAR(100) not null "
+ "publish_date not null "
+ "price FAOT(4,2) not null, "
+ "amount SMALLINT, "
+ "remarkVARCHAR(200))ENGINE=InnoDB) "
);
stmt.addBatch( "insert into values(1, 'ddd ', '张 ', 'eee ', '2004-6-1 ',34.00,35,null) ");
stmt.addBatch( "insert into values(2, 'fff ', '李 ', 'rrr ', '2005-3-1 ') ");
stmt.addBatch( "insert into values(3, ' 'ggg '， '王 ', 'yyy '， '2006-10-1 ',78.00,10,null) ");
stmt.executeBatch();
PrintWriter out=response.getWriter();
out.println( "seccess! ");
out.close();
}
catch(SQLException se)
{
se.printStackTrace();
}
finally
{
if(stmt!=null)
{
try
{
stmt.close();
}
catch(SQLException se)
{
se.printStackTrace();
}
stmt=null;
}
if(conn!=null)
{
try
{
conn.close();
}
catch(SQLException se)
{
se.printStackTrace();
}
conn=null;
}
}
}
// public void init() throws ServletException
// {
// String driverClass=getInitParameter( "driverClass ");
// url=getInitParameter( "driverClass ");
// user=getInitParameter( "user ");
// password=getInitParameter( "password ");
//
// try
// {
// Class.forName(driverClass);
// }
// catch(ClassNotFoundException ce)
// {
// throw new UnavailableException( "加载数据库驱动失败！ ");
// }
// }
private String url;
private String user;
private String password;
}
//web.xml
<servlet>
……
<init-param>
<param-name> driverClass </param-name>
<param-value> com.mysql.jdbc.Driver </param-value>
</init-param>
<init-param>
<param-name> url </param-name>
<param-value> jdbc:mysql://localhost:3306/mysql </param-value>
</init-param>
<init-param>
<param-name> user </param-name>
<param-value> root </param-value>
</init-param>
<init-param>
<param-name> password </param-name>
<param-value> 1 </param-value>
</init-param>
</servlet>
[解决办法]
String driverClass=getInitParameter( "driverClass ");
url=getInitParameter( "driverClass ");
老大...参数取错了吧.......
[解决办法]
把错贴出来，500肯定是编译错，也就是程序有问题
[解决办法]
String driverClass=getInitParameter( "driverClass ");
url=getInitParameter( "driverClass ");
---> url=getInitParameter( "url ");
还有要把具体的错误信息贴出来
