弄了好久也没弄好,刚解决一个问题,又是一个问题.麻烦得很.先谢谢你们,祝大家身体健康,万事如意! 其余代码如下:
问题:sql="INSERT INTO person (name,password) VALUES('"+uname+"','"+pwd+"')"; 一直显示出错????
<%@ page language="java" import="java.util.*" import="java.sql.*"
pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'regist.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<center>
<%
request.setCharacterEncoding("utf-8");
String uname=request.getParameter("name"); //从表单获得 String
String pwd=request.getParameter("password"); //从表单获得 String
String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url="jdbc:mysql://localhost:1443/JSP?user=luo&password=123";
//这是数据库连接地址Iuo是数据库名称,user是用户.password就是用户名,
sql="INSERT INTO person (name,password) VALUES('"+uname+"','"+pwd+"')";
Connection conn=null; //数据库连接 Statement stmt=null; ResultSet rs = null;
//查询结果 %>
<%
Class.forName(driver); //加载驱动
conn=DriverManager.getConnection(url); //获得连接
stmt=conn.createStatement();
stmt.execute(sql);//存入数据库
rs=stmt.executeQuery("select * from t_goods"); //查询所有person语句
%>
<%
if(rs!=null){ //判断以下
while(rs.next()){
String id=rs.getString(1);
String name=rs.getString(2);
%>
<table>
<tr>
<td><%=username %></td>
<td><%=password %></td>
</tr>
</table>
<%
//关闭数据库连接,和开始的顺序是反的
rs.close();//关闭结果集
stmt.close();//关闭Statement
conn.close();//关闭数据库连接
//ok完成了插入和查询操作
}
}
%>
</center>
</body>
</html>