<%@ page language="java" contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*" %>
<%
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url="jdbc:mysql://localhost/notebook?user=root&password=1234";
Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
out.println(stmt.execute("insert into users (username) values ('ht')"));
stmt.close();
conn.close();
}
catch(SQLException e)
{
out.println("发生异常:"+e.getMessage());
}
%>
新数据已经插入数据库中
为什么结果总是false?
<%@ page import="java.sql.*" %>
<%
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url="jdbc:mysql://localhost/notebook?user=root&password=1234";
Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
out.println(stmt.execute("insert into users (username) values ('ht')"));
stmt.close();
conn.close();
}
catch(SQLException e)
{
out.println("发生异常:"+e.getMessage());
}
%>
新数据已经插入数据库中
为什么结果总是false?
statement.executeUpdate()用在对数据库操作时成功的次数也就是行数,它返回的也不是真和假,但你可以自己判断一下,
sdfasd = false;
if(statement.executeUpdate(".........")>0)
{
sdfasd = true;
}
return sdfasd;