<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>"> <title>My JSP 'jdbc.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
--> </head>
<%@ page import = "java.sql.*" %>
<body bgcolor="#ffffff">
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:message_DSN"; // message_DSN 为你的用户数据源名称;
String user = "";
String password = ""; // 用户名和密码在此都设为空;
Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement();
//String sql = "select * from message"; //message1为数据源所在库中的一张表;
String sql3 = "insert into message values(?,?,?)";
//ResultSet rs = stmt.executeQuery(sql);
PreparedStatement psmt=conn.prepareCall(sql3);
psmt.clearParameters();
psmt.setString(1,"1");
psmt.setString(2,"dong");
psmt.setString(3,"插进去了么?????");
int i= psmt.executeUpdate();
//while (rs.next()) {
%>
the first String:
//<%=//rs.getString(1)%>
<br>
//<%=//rs.getString(2)%>
<br>
//<%=//rs.getString(3)%>
<%
//}
%>
<%
out.print("数据库操作成功,恭喜你");
%>
<%
//rs.close();
psmt.close();
stmt.close();
conn.close();
%> </body></html>
查询的操作没问题,但是插入数据老是出错!错哪儿啊?
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>"> <title>My JSP 'jdbc.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
--> </head>
<%@ page import = "java.sql.*" %>
<body bgcolor="#ffffff">
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:message_DSN"; // message_DSN 为你的用户数据源名称;
String user = "";
String password = ""; // 用户名和密码在此都设为空;
Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement();
//String sql = "select * from message"; //message1为数据源所在库中的一张表;
String sql3 = "insert into message values(?,?,?)";
//ResultSet rs = stmt.executeQuery(sql);
PreparedStatement psmt=conn.prepareCall(sql3);
psmt.clearParameters();
psmt.setString(1,"1");
psmt.setString(2,"dong");
psmt.setString(3,"插进去了么?????");
int i= psmt.executeUpdate();
//while (rs.next()) {
%>
the first String:
//<%=//rs.getString(1)%>
<br>
//<%=//rs.getString(2)%>
<br>
//<%=//rs.getString(3)%>
<%
//}
%>
<%
out.print("数据库操作成功,恭喜你");
%>
<%
//rs.close();
psmt.close();
stmt.close();
conn.close();
%> </body></html>
查询的操作没问题,但是插入数据老是出错!错哪儿啊?
psmt.clearParameters();
psmt.setString(1,"1");
psmt.setString(2,"dong");
psmt.setString(3,"插进去了么?????"); 改成
PreparedStatement psmt=conn.prepareStatement(sql3);
psmt.setString(1,"1");
psmt.setString(2,"dong");
psmt.setString(3,"插进去了么?????");
试试
--------------------------------------------------------------------------------
C:\bea\user_projects\domains\mydomain\.\myserver\.wlnotdelete\extract\myserver_kefu9_kefu9\jsp_servlet\__jdbc.java:171: ')' expected
(No more information available, probably caused by another error)C:\bea\user_projects\domains\mydomain\.\myserver\.wlnotdelete\extract\myserver_kefu9_kefu9\jsp_servlet\__jdbc.java:173: ')' expected
(No more information available, probably caused by another error)C:\bea\user_projects\domains\mydomain\.\myserver\.wlnotdelete\extract\myserver_kefu9_kefu9\jsp_servlet\__jdbc.java:175: ')' expected
(No more information available, probably caused by another error)C:\bea\user_projects\domains\mydomain\.\myserver\.wlnotdelete\extract\myserver_kefu9_kefu9\jsp_servlet\__jdbc.java:171: 'void' type not allowed here
(No more information available, probably caused by another error)C:\bea\user_projects\domains\mydomain\.\myserver\.wlnotdelete\extract\myserver_kefu9_kefu9\jsp_servlet\__jdbc.java:173: 'void' type not allowed here
(No more information available, probably caused by another error)C:\bea\user_projects\domains\mydomain\.\myserver\.wlnotdelete\extract\myserver_kefu9_kefu9\jsp_servlet\__jdbc.java:175: 'void' type not allowed here
(No more information available, probably caused by another error)
哈。。错误有点长。。
错误:
Compilation of 'C:\bea\user_projects\domains\mydomain\.\myserver\.wlnotdelete\extract\myserver_kefu9_kefu9\jsp_servlet\__jdbc.java' failed:
--------------------------------------------------------------------------------
C:\bea\user_projects\domains\mydomain\.\myserver\.wlnotdelete\extract\myserver_kefu9_kefu9\jsp_servlet\__jdbc.java:176: ')' expected
(No more information available, probably caused by another error)C:\bea\user_projects\domains\mydomain\.\myserver\.wlnotdelete\extract\myserver_kefu9_kefu9\jsp_servlet\__jdbc.java:178: ')' expected
(No more information available, probably caused by another error)C:\bea\user_projects\domains\mydomain\.\myserver\.wlnotdelete\extract\myserver_kefu9_kefu9\jsp_servlet\__jdbc.java:180: ')' expected
(No more information available, probably caused by another error)C:\bea\user_projects\domains\mydomain\.\myserver\.wlnotdelete\extract\myserver_kefu9_kefu9\jsp_servlet\__jdbc.java:176: 'void' type not allowed here
(No more information available, probably caused by another error)C:\bea\user_projects\domains\mydomain\.\myserver\.wlnotdelete\extract\myserver_kefu9_kefu9\jsp_servlet\__jdbc.java:178: 'void' type not allowed here
(No more information available, probably caused by another error)C:\bea\user_projects\domains\mydomain\.\myserver\.wlnotdelete\extract\myserver_kefu9_kefu9\jsp_servlet\__jdbc.java:180: 'void' type not allowed here
(No more information available, probably caused by another error)
--------------------------------------------------------------------------------
Full compiler error(s):
C:\bea\user_projects\domains\mydomain\.\myserver\.wlnotdelete\extract\myserver_kefu9_kefu9\jsp_servlet\__jdbc.java:176: ')' expected
_writeText(response, out, _wl_block5, _wl_block5Bytes);
^
C:\bea\user_projects\domains\mydomain\.\myserver\.wlnotdelete\extract\myserver_kefu9_kefu9\jsp_servlet\__jdbc.java:178: ')' expected
_writeText(response, out, _wl_block6, _wl_block6Bytes);
^
C:\bea\user_projects\domains\mydomain\.\myserver\.wlnotdelete\extract\myserver_kefu9_kefu9\jsp_servlet\__jdbc.java:180: ')' expected
_writeText(response, out, _wl_block7, _wl_block7Bytes);
^
C:\bea\user_projects\domains\mydomain\.\myserver\.wlnotdelete\extract\myserver_kefu9_kefu9\jsp_servlet\__jdbc.java:176: 'void' type not allowed here
_writeText(response, out, _wl_block5, _wl_block5Bytes);
^
C:\bea\user_projects\domains\mydomain\.\myserver\.wlnotdelete\extract\myserver_kefu9_kefu9\jsp_servlet\__jdbc.java:178: 'void' type not allowed here
_writeText(response, out, _wl_block6, _wl_block6Bytes);
^
C:\bea\user_projects\domains\mydomain\.\myserver\.wlnotdelete\extract\myserver_kefu9_kefu9\jsp_servlet\__jdbc.java:180: 'void' type not allowed here
_writeText(response, out, _wl_block7, _wl_block7Bytes);
^
6 errors