<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312"%>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>信息查询</title>
</head>
<body>
<marquee direction=left bgcolor="#b0cbcb">请输入您要查询的名字:</marquee>
<form action=e.jsp name="form2"><p align=center>姓名<input type="text" name="name" ></p>
<p align=center><input type=submit name="name1" value="查询"></p>
</form>
</body>
</html><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312"%>
<%@page import="java.sql .*" %>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>信息查询</title>
</head>
<body><%
String name1=request.getParameter("name");
Connection con;
PreparedStatement ps;
ResultSet re;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){};
try{
con=DriverManager.getConnection("jdbc:odbc:sjk","sa","");
ps=con.prepareStatement("select * from 工资表 where name='"+name1+"'");
re=ps.executeQuery();
if(re.next())
{out.print(re.getString("id"));
out.print(re.getString("xing"));
out.print(re.getString("sex"));
out.print(re.getString("gong"));
}
else
{out.print("你输入的用户名不存在");}
con.close();ps.close();}
catch(SQLException e1){out.print (e1); }%>
</body>
</html>大家给我看一下,我这个程序不能查询,where name='"+name1+"'");name改成INT型的gong或者id就能查询信息的,如果改成string的name或者sex就不能查询了。谢谢大家了给我指点一下
<html>
<head>
<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312"%>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>信息查询</title>
</head>
<body>
<marquee direction=left bgcolor="#b0cbcb">请输入您要查询的名字:</marquee>
<form action=e.jsp name="form2"><p align=center>姓名<input type="text" name="name" ></p>
<p align=center><input type=submit name="name1" value="查询"></p>
</form>
</body>
</html><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312"%>
<%@page import="java.sql .*" %>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>信息查询</title>
</head>
<body><%
String name1=request.getParameter("name");
Connection con;
PreparedStatement ps;
ResultSet re;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){};
try{
con=DriverManager.getConnection("jdbc:odbc:sjk","sa","");
ps=con.prepareStatement("select * from 工资表 where name='"+name1+"'");
re=ps.executeQuery();
if(re.next())
{out.print(re.getString("id"));
out.print(re.getString("xing"));
out.print(re.getString("sex"));
out.print(re.getString("gong"));
}
else
{out.print("你输入的用户名不存在");}
con.close();ps.close();}
catch(SQLException e1){out.print (e1); }%>
</body>
</html>大家给我看一下,我这个程序不能查询,where name='"+name1+"'");name改成INT型的gong或者id就能查询信息的,如果改成string的name或者sex就不能查询了。谢谢大家了给我指点一下
解决方案 »
- 如何传递数组到后台(使用Struts2)
- displaytag的export导出excel报错
- linux乱码
- 对于大数据量、高并发的解决方案
- HttpURLConnection
- 怎么将checkbox的内部变色?想让它的打对号那个方框内为绿色,对号还是黑的。怎么办?
- 请教一下,如何变换验证码的问题
- The value for the useBean class attribute umrsystem.PoolBean is invalid.请问如何解决?快跳楼了
- 有JSP+James开发WEBMAIL例子吗?
- 各位大侠,救命呀,一个简单问题快急死我了
- 大家帮帮忙看看这段JSP代码错在哪了?
- 用Java做搜索引擎的问题
String name=‘+name1+’
这里强转试一下
1、检查name字段是否是字符串类型的
2、查询之前把name1输出一下,看看是不是没有拿到想要的东西