jsp中 insert数据的问题
环境:win2000prof +jb9
向mysql中,insert一条记录,代码如下:
<%@ page language="java" import="java.sql.*" %>
<html>
<head>
<title>
jspinsert
</title>
</head>
<body bgcolor="#ffffff">
<%
String DBDriver="com.mysql.jdbc.Driver";
String ConnStr="jdbc:mysql://localhost/swtest";
String MyUser="root";
String MyPassword="";
Connection conn = null;
ResultSet rs = null;
Statement stmt=null;
try
{
Class.forName(DBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("DBconn (): " + e.getMessage());
}
try
{
conn = DriverManager.getConnection(ConnStr,MyUser,MyPassword);
stmt = conn.createStatement();
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery:"+ex.getMessage());
}
rs = stmt.executeQuery("insert into book(name,author) values('1','1')");
rs.close();
%>
</body>
</html>
程序执行后,察看数据库无纪录增加,why?