- 论坛徽章:
- 0
|
现在有一个表:
create table role
(
role_no int(5) NOT NULL auto_increment,
role_id varchar(32),
role_name varchar(64),
valid ENUM('Y','N') NOT NULL ,
PRIMARY KEY (role_no)
)ENGINE=InnoDB DEFAULT CHARSET=latin1;
写了一下的一个简单的jsp:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<head>
<title>
testmysql.jsp
</title>
</head>
<body>
<H1>Mysql</H1>
<%
Class.forName("com.mysql.jdbc.Driver");
String mysql_url="jdbc:mysql://localhost/img_db";
Connection conn= DriverManager.getConnection(mysql_url,"img","123");
Statement stmt=conn.createStatement();
String query="insert into role values('','xxx','xxx','Y')";
stmt.executeUpdate(query);
if(stmt != null)
stmt.close();
if(conn != null)
conn.close();
%>
</body>
</html>
但是就是抱错:
javax.servlet.ServletException: Data truncation: Out of range value for column 'role_no' at row 1
不知道怎么做,请教各位大哥!
[ 本帖最后由 jjcowboy 于 2006-5-10 15:55 编辑 ] |
|