<%@ page contentType="text/html;charset=ISO8859_1"%>
<%@ page language="java" import="java.sql.*" %>
<%@ page language="java" import="java" %>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:online");
Statement stmt=con.createStatement();
String strSQL;
strSQL="INSERT INTO student(name,num) Values('"+request.getParameter("name")+"','"+request.getParameter("num")+"')";
stmt.executeUpdate(strSQL);
%>这样试一下,如果还不行,检查一下你的数据类型是不是不匹配?
<%@ page language="java" import="java.sql.*" %>
<%@ page language="java" import="java" %>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:online");
Statement stmt=con.createStatement();
String strSQL;
strSQL="INSERT INTO student(name,num) Values('"+request.getParameter("name")+"','"+request.getParameter("num")+"')";
stmt.executeUpdate(strSQL);
%>这样试一下,如果还不行,检查一下你的数据类型是不是不匹配?
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:online");
...........
}
catch(){
..........
}
有可能是空指针问题,看看错误信息是什么
与ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY的区别是什么?
我修改了之后还是不行报原来的错误?
我的代码如下:
<%@ page contentType="text/html;charset=ISO8859_1"%>
<%@ page language="java" import="java.sql.*" %>
<%@ page language="java" import="java" %>
<jsp:useBean id="workM" scope="page" class="online.onlineconn1" />
<%
String strSQL
strSQL="INSERT INTO student(name) Values('"+request.getParameter("name")+"')";
workM.executeUpdate(strSQL);
%>
javabean为:
package online;
import java.sql.*;
public class onlineconn1
{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:online";
Connection conn = null;
ResultSet rs = null;
public onlineconn1()
{
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("onlineconn(): " + e.getMessage());
}
}
public ResultSet executeQuery(String sql)
{
rs = null;
try {
conn = DriverManager.getConnection(sConnStr);
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery: " + ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql)
{
try {
conn = DriverManager.getConnection(sConnStr);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
stmt.executeUpdate(sql);
}
catch(SQLException ex)
{
System.err.println("aq.executeUpdate: " + ex.getMessage());
}
}
}我的数据库中除了name字段还有其他字段,这个会有影响吗?