create table t( id int identity(1000,1) not null content varchar(50) );insert into t(content) values ('hello, world');你不是这样使用的吗?
/crm/add1.jsp:56: incompatible types found : int required: java.sql.ResultSet ResultSet rs=Stmt.executeUpdate(sql); ^ 1 error 错误代码如下不知道为什么请大家帮忙解决
executeUpdate public int executeUpdate(String sql) throws SQLExceptionExecutes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement. Parameters: sql - an SQL INSERT, UPDATE or DELETE statement or an SQL statement that returns nothing Returns: either the row count for INSERT, UPDATE or DELETE statements, or 0 for SQL statements that return nothing Throws: SQLException - if a database access error occurs or the given SQL statement produces a ResultSet object你只是执行更新操作,怎么会得到一个结果集? 要多看java api doc
你有什么建议? 我要是去掉了就不好了 我还想让他自动增加呢
我看应该是去掉not null
id int identity(1000,1) not null
content varchar(50)
);insert into t(content) values ('hello, world');你不是这样使用的吗?
found : int
required: java.sql.ResultSet
ResultSet rs=Stmt.executeUpdate(sql);
^
1 error
错误代码如下不知道为什么请大家帮忙解决
public int executeUpdate(String sql)
throws SQLExceptionExecutes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement. Parameters:
sql - an SQL INSERT, UPDATE or DELETE statement or an SQL statement that returns nothing
Returns:
either the row count for INSERT, UPDATE or DELETE statements, or 0 for SQL statements that return nothing
Throws:
SQLException - if a database access error occurs or the given SQL statement produces a ResultSet object你只是执行更新操作,怎么会得到一个结果集?
要多看java api doc
不知道mysql支持与否?
ResultSet rs=Stmt.executeUpdate(sql);
-》
Stmt.executeUpdate(sql);
只能这样用的~
ResultSet rs=Stmt.executeQuery(sql);
found : int
required: java.sql.Statement
Statement rs=Stmt.executeUpdate(sql);
^
1 error
ResultSet rs=Stmt.executeQuery(sql1);
错误
/crm/add1.jsp:58: variable Stmt might not have been initialized
ResultSet rs=Stmt.executeQuery(sql1);
^
1 error
<%
String company_date=(String)request.getParameter("company_date");
String company_owner=(String)request.getParameter("company_owner");
String company_name=(String)request.getParameter("company_name");
String company_address1=(String)request.getParameter("company_address1");
String company_address2=(String)request.getParameter("company_address2");
String company_man1=(String)request.getParameter("company_man1");
String company_post1=(String)request.getParameter("company_post1");
String company_tel1=(String)request.getParameter("company_tel1");
String company_mobile1=(String)request.getParameter("company_mobile1");
String company_man2=(String)request.getParameter("company_man2");
String company_post2=(String)request.getParameter("company_post2");
String company_tel2=(String)request.getParameter("company_tel2");
String company_mobile2=(String)request.getParameter("company_mobile2");
String company_level=(String)request.getParameter("company_level");
String company_telphone=(String)request.getParameter("company_telphone");
String company_consultation=(String)request.getParameter("company_consultation");
String company_bank=(String)request.getParameter("company_bank");
String company_accounts=(String)request.getParameter("company_accounts");
String company_revenuer=(String)request.getParameter("company_revenuer");
String company_thing=(String)request.getParameter("company_thing");
String company_info=(String)request.getParameter("company_info");
String company_day=(String)request.getParameter("company_day");String sql="insert into company(company_date,company_owner,company_name,company_address1,company_address2,company_man1,company_post1,company_tel1,company_mobile1,company_man2,company_post2,company_tel2,company_mobile2,company_level,company_telphone,company_consultation,company_bank,company_accounts,company_revenuer,company_thing,company_info,company_day) values('"+company_date+"','"+company_owner+"','"+company_name+"','"+company_address1+"','"+company_address2+"','"+company_man1+"','"+company_post1+"','"+company_tel1+"','"+company_mobile1+"','"+company_man2+"','"+company_post2+"','"+company_tel2+"','"+company_mobile2+"','"+company_level+"','"+company_telphone+"','"+company_consultation+"','"+company_bank+"','"+company_accounts+"','"+company_revenuer+"','"+company_thing+"','"+company_info+"','"+company_day+"')";
try{
Statement Stmt.executeUpdate(sql);
out.print("Ìí¼Ó³É¹¦");
}
catch(SQLException e)
{
out.print("·¢Éú´íÎó£¡ÇëÄãÌîд±íµ¥ÊÇ·ñÕýÈ·!");
}
%> 你们帮看看吧我就是想把数据写入数据库中 我也改了可是就是不可以
Statement Stmt=conn.createStatement();
<%
String company_date=(String)request.getParameter("company_date");
String sql="insert into company(company_date) values('"+company_date+"')";
String sql1="select * from company";
try{
Statement rs=Stmt.executeUpdate(sql);
out.print("Ìí¼Ó³É¹¦");
}
catch(SQLException e)
{
out.print("·¢Éú´íÎó£¡ÇëÄãÌîд±íµ¥ÊÇ·ñÕýÈ·!");
}
%>
/crm/add1.jsp:58: incompatible types
found : int
required: java.sql.Statement
Statement rs=Stmt.executeUpdate(sql);
^
1 error
<%
String company_date=(String)request.getParameter("company_date");
String sql="insert into company(company_date) values('"+company_date+"')";
try{
Statement Stmt.executeUpdate(sql);
out.print("Ìí¼Ó³É¹¦");
}
catch(SQLException e)
{
out.print("·¢Éú´íÎó£¡ÇëÄãÌîд±íµ¥ÊÇ·ñÕýÈ·!");
}
%> 错误如下
/crm/add1.jsp:54: ';' expected
Statement Stmt.executeUpdate(sql);
^
/crm/add1.jsp:54: Stmt is already defined in _jspService(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)
Statement Stmt.executeUpdate(sql);
^
2 errors
Stmt.executeUpdate(sql);这样就OK了~
慢慢来,莫急!
给你看个查询和修改的例子:数据库连接:
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/sample";
Connection conn= DriverManager.getConnection(url,"root","");
Statement stmt=conn.createStatement(); 查询:
String sql="select * from userinfo";
ResultSet rs=stmt.executeQuery(sql);修改
String sql="update userinfo set user=\"zcjl\" where id=1";
stmt.executeUpdate(sql);
<%@ page contentType="text/html;charset=gb2312"%>;
<%@ page import="java.sql.*"%>;
<%@ page import="java.util.*"%>;
<% Class.forName("com.microsoft.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=crm";
String user="";
String password="";
//Á¬½Ó¶ÔÏó
java.sql.Connection Conn;
//Óï¾ä¶ÔÏó
java.sql.Statement Stmt;
//½á¹û¼¶¶ÔÏó
java.sql.ResultSet Rst;//¼ÓÔØÇý¶¯³ÌÐò
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
try{
Conn=DriverManager.getConnection("url","user","password");
Stmt=Conn.createStatement();
}
catch(Exception e)
{
out.println("ÎÞ·¨Á¬½ÓÊý¾Ý¿â");
}
%>
文件二
<%@ include file="data.jsp"%>
<%
String company_date=(String)request.getParameter("company_date");
String sql="insert into company(company_date) values('"+company_date+"')
try{
Stmt.executeUpdate(sql);
out.print("Ìí¼Ó³É¹¦");
}
catch(SQLException e)
{
out.print("·¢Éú´íÎó£¡ÇëÄãÌîд±íµ¥ÊÇ·ñÕýÈ·!");
}
%>
错误如下
/crm/add1.jsp:58: variable Stmt might not have been initialized
Stmt.executeUpdate(sql);
^
1 error