一个关于jsp的数据库操作问题?在线等! 为什么不用javabean。你可以include 那个jsp,<%@ page include file="jsp的相对路径"%> 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <jsp:forward page="filepath"/> 我想你看看这个例子,关于如何调用,或者其他,你会明白很多的://用的是jdbcOdbc桥连接access数据库<%@page language="java" import="java.sql.*"%><%@ page contentType="text/html;charset=gb2312"%><%!public String getStr(String str){ try { String temp_p=str; byte[] temp_t=temp_p.getBytes("ISO8859-1"); String temp=new String(temp_t); return temp; } catch(Exception e) {} return "null";}%><%Connection sqlConn;Statement sqlStmt;Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");sqlConn = DriverManager.getConnection("jdbc:odbc:myuser","zhaoxin","zhaoxin");sqlStmt = sqlConn.createStatement();%><%String name1=getStr(request.getParameter("username"));String pwd=getStr(request.getParameter("password"));String sql="select * from userinfo1 where username='"+name1+"' and password='"+pwd+"'";ResultSet rs=sqlStmt.executeQuery(sql);String name;String email;String education;String resume;if(rs.next()){ name = rs.getString("name"); email = rs.getString("email"); education = rs.getString("education"); resume = rs.getString("resume");%><body bgcolor=#ffffff background="new_pa14.gif"><br><br><br><br><center><h2>请选择你所要修改的信息进行修改!</h2><form method="post" action="editinfo1.jsp"><table width="56%" ><tr><td width="28%" height="20" align="legt"><p align="right"></p></td><td align="left" height="20" width="72%"><p><input type="hidden" name="username" value="<%=name1%>"></td></tr><tr><td width="28%" height="20" align="left"><p align="right">真实姓名:</p></td><td align="left" height="20" width="72%"><p><input type="text" name="name" value="<%=name%>"></td></tr><tr><td width="28%" height="20" align="left"><p align="right">Email:</p></td><td align="left" height="20" width="72%"><p><input type="text" name="email" value="<%=email%>"></td></tr><tr><td width="28%" height="20" align="left"><p align="right">教育:</p></td><td align="left" height="20" width="72%"><p><input type="text" name="education" value="<%=education%>"></td></tr><tr><td width="28%" height="20" align="left"><p align="right">个人简介:</p></td><td align="left" height="20" width="72%"><p><textarea name="resume" cols="50" row="10"><%=resume%></textarea></p></td></tr><tr><td width="28%" height="20" align="left"></td><td><input type="submit" value="提交" name="submit"><input type="reset" value="重写" name="submit2"></td> </tr></table></form></center><%rs.close();}else{rs.close();%><script language=javascript>window.location="back.html"</script><%}%></body> 你可以看看这个例子,或许对你很有帮助!!!//用的是JdbcOdbc桥连接access数据库<%@page language="java" import="java.sql.*"%><%@ page contentType="text/html;charset=gb2312"%><%!public String getStr(String str){ try { String temp_p=str; byte[] temp_t=temp_p.getBytes("ISO8859-1"); String temp=new String(temp_t); return temp; } catch(Exception e) {} return "null";}%><%Connection sqlConn;Statement sqlStmt;Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");sqlConn = DriverManager.getConnection("jdbc:odbc:myuser","zhaoxin","zhaoxin");sqlStmt = sqlConn.createStatement();%><%String name1=getStr(request.getParameter("username"));String pwd=getStr(request.getParameter("password"));String sql="select * from userinfo1 where username='"+name1+"' and password='"+pwd+"'";ResultSet rs=sqlStmt.executeQuery(sql);String name;String email;String education;String resume;if(rs.next()){ name = rs.getString("name"); email = rs.getString("email"); education = rs.getString("education"); resume = rs.getString("resume");%><body bgcolor=#ffffff background="new_pa14.gif"><br><br><br><br><center><h2>请选择你所要修改的信息进行修改!</h2><form method="post" action="editinfo1.jsp"><table width="56%" ><tr><td width="28%" height="20" align="legt"><p align="right"></p></td><td align="left" height="20" width="72%"><p><input type="hidden" name="username" value="<%=name1%>"></td></tr><tr><td width="28%" height="20" align="left"><p align="right">真实姓名:</p></td><td align="left" height="20" width="72%"><p><input type="text" name="name" value="<%=name%>"></td></tr><tr><td width="28%" height="20" align="left"><p align="right">Email:</p></td><td align="left" height="20" width="72%"><p><input type="text" name="email" value="<%=email%>"></td></tr><tr><td width="28%" height="20" align="left"><p align="right">教育:</p></td><td align="left" height="20" width="72%"><p><input type="text" name="education" value="<%=education%>"></td></tr><tr><td width="28%" height="20" align="left"><p align="right">个人简介:</p></td><td align="left" height="20" width="72%"><p><textarea name="resume" cols="50" row="10"><%=resume%></textarea></p></td></tr><tr><td width="28%" height="20" align="left"></td><td><input type="submit" value="提交" name="submit"><input type="reset" value="重写" name="submit2"></td> </tr></table></form></center><%rs.close();}else{rs.close();%><script language=javascript>window.location="back.html"</script><%}%></body> servlet页面转发后不能显示图片和CSS 为什么啊??? 为什么时间会显示为08:05:52.0? 哪里有下WEBLOGIC7.0啊?急用 JSP页面如何大量取得客户端的数据。 关于clientKy的问题 大家请踊跃回答 清家荡产求算法 新手 myeclipse问题 大神们快帮帮忙 我只是想在页面上实现一个简单的发邮件功能,请大虾指教!!! JAVA做B/S结构系统,不想用在客户端用JAVASCRIPT脚本做用户界面,怎么用JAVA技术实现??? 请教几个方法! 有关jsp的问题 为什么我的bean找不到?(都有分)
//用的是jdbcOdbc桥连接access数据库<%@page language="java" import="java.sql.*"%>
<%@ page contentType="text/html;charset=gb2312"%><%!
public String getStr(String str)
{
try
{
String temp_p=str;
byte[] temp_t=temp_p.getBytes("ISO8859-1");
String temp=new String(temp_t);
return temp;
}
catch(Exception e)
{}
return "null";
}
%>
<%
Connection sqlConn;
Statement sqlStmt;Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
sqlConn = DriverManager.getConnection("jdbc:odbc:myuser","zhaoxin","zhaoxin");
sqlStmt = sqlConn.createStatement();
%><%
String name1=getStr(request.getParameter("username"));
String pwd=getStr(request.getParameter("password"));String sql="select * from userinfo1 where username='"+name1+"' and password='"+pwd+"'";
ResultSet rs=sqlStmt.executeQuery(sql);
String name;
String email;
String education;
String resume;
if(rs.next())
{
name = rs.getString("name");
email = rs.getString("email");
education = rs.getString("education");
resume = rs.getString("resume");
%>
<body bgcolor=#ffffff background="new_pa14.gif">
<br><br><br><br>
<center>
<h2>请选择你所要修改的信息进行修改!</h2>
<form method="post" action="editinfo1.jsp">
<table width="56%" >
<tr>
<td width="28%" height="20" align="legt">
<p align="right"></p>
</td>
<td align="left" height="20" width="72%">
<p><input type="hidden" name="username" value="<%=name1%>">
</td>
</tr>
<tr>
<td width="28%" height="20" align="left">
<p align="right">真实姓名:</p>
</td>
<td align="left" height="20" width="72%">
<p><input type="text" name="name" value="<%=name%>">
</td>
</tr>
<tr>
<td width="28%" height="20" align="left">
<p align="right">Email:</p>
</td>
<td align="left" height="20" width="72%">
<p><input type="text" name="email" value="<%=email%>">
</td>
</tr>
<tr>
<td width="28%" height="20" align="left">
<p align="right">教育:</p>
</td>
<td align="left" height="20" width="72%">
<p><input type="text" name="education" value="<%=education%>">
</td>
</tr>
<tr>
<td width="28%" height="20" align="left">
<p align="right">个人简介:</p>
</td>
<td align="left" height="20" width="72%">
<p><textarea name="resume" cols="50" row="10">
<%=resume%>
</textarea></p>
</td>
</tr>
<tr>
<td width="28%" height="20" align="left"></td><td><input type="submit" value="提交" name="submit"><input type="reset" value="重写" name="submit2"></td>
</tr>
</table>
</form>
</center>
<%
rs.close();
}
else
{
rs.close();
%>
<script language=javascript>
window.location="back.html"
</script>
<%
}
%>
</body>
你可以看看这个例子,或许对你很有帮助!!!//用的是JdbcOdbc桥连接access数据库<%@page language="java" import="java.sql.*"%>
<%@ page contentType="text/html;charset=gb2312"%><%!
public String getStr(String str)
{
try
{
String temp_p=str;
byte[] temp_t=temp_p.getBytes("ISO8859-1");
String temp=new String(temp_t);
return temp;
}
catch(Exception e)
{}
return "null";
}
%>
<%
Connection sqlConn;
Statement sqlStmt;Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
sqlConn = DriverManager.getConnection("jdbc:odbc:myuser","zhaoxin","zhaoxin");
sqlStmt = sqlConn.createStatement();
%><%
String name1=getStr(request.getParameter("username"));
String pwd=getStr(request.getParameter("password"));String sql="select * from userinfo1 where username='"+name1+"' and password='"+pwd+"'";
ResultSet rs=sqlStmt.executeQuery(sql);
String name;
String email;
String education;
String resume;
if(rs.next())
{
name = rs.getString("name");
email = rs.getString("email");
education = rs.getString("education");
resume = rs.getString("resume");
%>
<body bgcolor=#ffffff background="new_pa14.gif">
<br><br><br><br>
<center>
<h2>请选择你所要修改的信息进行修改!</h2>
<form method="post" action="editinfo1.jsp">
<table width="56%" >
<tr>
<td width="28%" height="20" align="legt">
<p align="right"></p>
</td>
<td align="left" height="20" width="72%">
<p><input type="hidden" name="username" value="<%=name1%>">
</td>
</tr>
<tr>
<td width="28%" height="20" align="left">
<p align="right">真实姓名:</p>
</td>
<td align="left" height="20" width="72%">
<p><input type="text" name="name" value="<%=name%>">
</td>
</tr>
<tr>
<td width="28%" height="20" align="left">
<p align="right">Email:</p>
</td>
<td align="left" height="20" width="72%">
<p><input type="text" name="email" value="<%=email%>">
</td>
</tr>
<tr>
<td width="28%" height="20" align="left">
<p align="right">教育:</p>
</td>
<td align="left" height="20" width="72%">
<p><input type="text" name="education" value="<%=education%>">
</td>
</tr>
<tr>
<td width="28%" height="20" align="left">
<p align="right">个人简介:</p>
</td>
<td align="left" height="20" width="72%">
<p><textarea name="resume" cols="50" row="10">
<%=resume%>
</textarea></p>
</td>
</tr>
<tr>
<td width="28%" height="20" align="left"></td><td><input type="submit" value="提交" name="submit"><input type="reset" value="重写" name="submit2"></td>
</tr>
</table>
</form>
</center>
<%
rs.close();
}
else
{
rs.close();
%>
<script language=javascript>
window.location="back.html"
</script>
<%
}
%>
</body>