数据库如下:
id 自动编号
cinema 文本
movie_screen 文本
date 文本
time 文本
```````````````````````````````````````````````````
代码如下:
```````````````````````````````````````````````````
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>添加电影成功</title>
</head><body>
<jsp:include page="header.jsp"/>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:movie";
String user="";
String pwd="";
Connection con=DriverManager.getConnection(url,user,pwd);
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String cinema=request.getParameter("cin");
byte[] tmpbyte=cinema.getBytes("ISO8859_1");
cinema=new String(tmpbyte);
String movie_screen=request.getParameter("mov");
tmpbyte=movie_screen.getBytes("ISO8859_1");
movie_screen=new String(tmpbyte);
String date=request.getParameter("dat");
tmpbyte=date.getBytes("ISO8859_1");
date=new String(tmpbyte);
String time=request.getParameter("tim");
tmpbyte=time.getBytes("ISO8859_1");
time=new String(tmpbyte);
String sql="insert into cinemas (cinema,movie_screen,date,time)values ('"+cinema+"','"+movie_screen+"',"+date+","+time+")";
//将记录添加到数据库中
stmt.executeUpdate(sql);
out.print("<p> </p>");
out.print("<center>添加成功!</center>");
%>
<p> </p>
<p> </p>
<p> </p>
<p align="center">
<a href="cinema.jsp">继续添加</a>
<a href="cinema_info.jsp">返回首页</a>
</p>
<p> </p>
<jsp:include page="footer.JSP" flush="true" />
</body>
</html>
运行之后就提示,数据库insert into语句错误!!!!!!我找了很久都没发现错误在那里麻烦大虾们指点迷津~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
id 自动编号
cinema 文本
movie_screen 文本
date 文本
time 文本
```````````````````````````````````````````````````
代码如下:
```````````````````````````````````````````````````
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>添加电影成功</title>
</head><body>
<jsp:include page="header.jsp"/>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:movie";
String user="";
String pwd="";
Connection con=DriverManager.getConnection(url,user,pwd);
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String cinema=request.getParameter("cin");
byte[] tmpbyte=cinema.getBytes("ISO8859_1");
cinema=new String(tmpbyte);
String movie_screen=request.getParameter("mov");
tmpbyte=movie_screen.getBytes("ISO8859_1");
movie_screen=new String(tmpbyte);
String date=request.getParameter("dat");
tmpbyte=date.getBytes("ISO8859_1");
date=new String(tmpbyte);
String time=request.getParameter("tim");
tmpbyte=time.getBytes("ISO8859_1");
time=new String(tmpbyte);
String sql="insert into cinemas (cinema,movie_screen,date,time)values ('"+cinema+"','"+movie_screen+"',"+date+","+time+")";
//将记录添加到数据库中
stmt.executeUpdate(sql);
out.print("<p> </p>");
out.print("<center>添加成功!</center>");
%>
<p> </p>
<p> </p>
<p> </p>
<p align="center">
<a href="cinema.jsp">继续添加</a>
<a href="cinema_info.jsp">返回首页</a>
</p>
<p> </p>
<jsp:include page="footer.JSP" flush="true" />
</body>
</html>
运行之后就提示,数据库insert into语句错误!!!!!!我找了很久都没发现错误在那里麻烦大虾们指点迷津~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
movie_screen
date
time
換成固定的值試下~~~~
String date=request.getParameter("dat");String sql="insert into cinemas (cinema,movie_screen,date,time)values ('"+cinema+"','"+movie_screen+"',"+date+","+time+")";名都不一样
这应该没有问题吧
然后到Access里执行一下就知道了