<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<html>
<body>
<%
String driverName="com.mysql.jdbc.Driver";
String userName="root";
String userPassword="10086";
String dbName="ly";
String tableName="liuyan";
String
url="jdbc:mysql://localhost:3306/"+dbName+"?user="+userName+"&password="+userPassword;
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String id=request.getParameter("id");
id=new String(id.getBytes("ios-8859-1"));
String name=request.getParameter("name");
name=new String(name.getBytes("ios-8859-1"));
String title=request.getParameter("title");
title=new String(title.getBytes("ios-8859-1"));
String time=request.getParameter("time");
time=new String(time.getBytes("ios-8859-1"));
String messages=request.getParameter("message");
messages=new String(message.getBytes("ios-8859-1"));
if(id.equals("")|name.equals("")|title.equals("")|time.equals("")|message.equals(""))
{
response.sendRedirect("index.jsp");}
else
{
String sql="insert into liuyan(id,name,title,time,messages)
values('"+id+"','"+name+"','"+title+"','"+time+"','"+messages+"')";
stmt.executeUpdate(sql);
out.print("数据库连接成功");
response.sendRedirect("liuyanjieguo.jsp");
}
stmt.close();
conn.close();
%>
</body>
</html> |
|
|
|
评论
直达楼层