读书人

用sevrlet编撰的创建库的程序出错(

发布时间: 2011-12-24 23:03:24 作者: rapoo

用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 ");
还有要把具体的错误信息贴出来

读书人网 >Java Web开发

热点推荐