大家 帮我看看这段把数据插入到NYSQL数据库中的语句,哪错拉?谢谢!
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url="jdbc:mysql://127.0.0.1/dbname?user=accounts&password=password&useUnicode=true&characterEncoding=gb2312";
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
string title=newstring(request.getparameter("title").getbytes("8859_1"));
String sql = "insert into gb(title) values('"+title+"')" ;
stmt.executeUpdate(sql) ;
%>
success!
<%
rs.close();
stmt.close();
conn.close();
%>