jsp插入数据(insert into)的简单例子!--好空间网络!

正文 /News

jsp插入数据(insert into)的简单例子

2014/9/17 14:11:53 \| 阅9977	来源：好空间网络 [打印] [关闭]

这个是比较简单的例子,今天没事自己写个,放在这里,以备其他用户插入数据库不成功的时候,来排除问题所用

分为2个文件,第一个文件:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<form id="form1" name="form1" method="post" action="a.jsp">
<label>
<textarea name="a" cols="100" rows="11" id="a"></textarea>
</label>
<label>
<input type="submit" name="Submit" value="提交" />
</label>
</form>
</body>
</html>

第二个文件 a.jsp

<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="utf-8"%>
<%@ page contentType="text/html;charset=utf-8"%>
<%
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
response.setContentType("text/html; charset=utf-8");
%>
<html>
<head>
<title>add message into table </TITLE>
</head>
<body>
<%
String id=request.getParameter("a"); //从表单获得
java.util.Date date=new java.util.Date();
String datetime=new Timestamp(date.getTime()).toString();
/** 连接数据库参数 **/
String driverName = "com.mysql.jdbc.Driver"; //驱动名称
String DBUser = "****"; //mysql用户名
String DBPasswd = "*******"; //mysql密码
String DBName = "****"; //数据库名
String connUrl = "jdbc:mysql://localhost:3306/" + DBName + "?user=" + DBUser + "&password=" + DBPasswd;
Class.forName(driverName).newInstance();
Connection conn = DriverManager.getConnection(connUrl);
Statement stmt = conn.createStatement();
stmt.executeQuery("SET NAMES UTF8");
String insert_sql = "insert into article(content) values('" + id + "')";
try {
stmt.execute(insert_sql);
}catch(Exception e) {
e.printStackTrace();
}
stmt.close();
conn.close();
out.print("ok!");
%>
</body>
</html>

另外记得放个mysql的驱动,mysql的驱动网络上都上我就不发了

您的姓名：	(*)
验证码：	(*) 点击更换
您的评论：