数据库连接

来源：互联网发布：程序员入门学什么编辑：程序博客网时间：2024/05/13 22:33

<%@ page contentType="text/html;charset=UTF-8" import="java.sql.*"%>
<html>
<head>
<title>用户信息注册</title>
</head>
<body>
<%request.setCharacterEncoding("utf-8");%>
<%=request.getParameter("name")%><br>
<%=request.getParameter("pwd")%><br>
<%=request.getParameter("E_mail")%><br>
<%=request.getParameter("job")%><br>
<%String[] hobbys=request.getParameterValues("hobby");
if(hobbys!=null){

for(int i=0;i<hobbys.length;i++)
{out.print(hobbys[i]);}
}
%>
<br>
<%=request.getParameter("text")%><br>
<table>
<tr>
<th colspan="2">
<input type="submit" name="submit" value="添加">
</th>
</tr>
</table>
<%
request.setCharacterEncoding("UTF-8");
String submit=request.getParameter("submit");
if(submit!=null&&!submit.equals(""))
{
String name=request.getParameter("name");
String pwd=request.getParameter("pwd");
String E_mail=request.getParameter("E_mail");
String job=request.getParameter("job");
String hobby=request.getParameter("hobby");
String text=request.getParameter("text");
Class.forName("com.mysql.jdbc.Driver");
Connection
con
=
DriverManager.getConnection("jdbc:mysql://localhost:3306/user","root","admin123");
Statement stmt=con.createStatement();
String sql="insert into user(name,pwd,E_mail,job,hobby,text) values('"+name+"','"+pwd+"','"+E_mail+"','"+job+"','"+hobby+"','"+text+"')";
stmt.executeUpdate(sql);
out.println("添加数据成功");

/*int i=
if(i==1)
{
out.println("<script language='javaScript'>alert('添加成功，单击确定跳转到主页！');</script>");
response.setHeader("refresh","1;url=register.jsp");
}
else{
out.println("<script language='javaScript'>alert('添加失败，单击确定返回添加页面！');</script>");
response.setHeader("refresh","1;url=sava.jsp");
}*/
stmt.close();
con.close();
}
%>
<a href="register.jsp" >返回test.jsp页面,查看数据</a><br>
</body>
</html>

0 0