jsp查询sql数据库当页显示结果

来源：互联网发布：linux 创建用户组编辑：程序博客网时间：2024/05/15 01:46

<%@ page contentType="text/html;charset=gb2312"%>

<%@page language="java" import="java.sql.*" %>

<%@page language="java" import="java.util.*" %>

<html>

<head>

<title>数据库内容显示</title>

function chaxun(){

//document.getElementById("number").value;

document.f.submit();

}

</script>

function inform()

{

//a=document.getElementById("number").value;

var a=document.all.number.value;

if(a=="")alert("不能为空");

else

alert("输入值为"+a);

}

</SCRIPT>

</head>

<body>

<h1 align="center">数据库查询</h1>

号码：<input type="text" id="number" name="number" >

</div>

<hr/>

</form>

<%String number = request.getParameter("number"); //获取页面传来的号码

if(number==""){}

else{

//查询的语句

String sql = "SELECT * FROM [lhm].[dbo].[liaopin] where [号码]='" + number + "'";

//String sql = "SELECT * FROM [lhm].[dbo].[liaopin] ";

String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

String url="jdbc:sqlserver://10.144.79.43:1433";

String user="sa";

String password="";

Class.forName(driver).newInstance();

Connection conn= DriverManager.getConnection(url,user,password);

Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

ResultSet rs=stmt.executeQuery(sql); %>

<% while(rs.next()) {%>

<%}

rs.close();

stmt.close();

conn.close();}%>

</table>

</body>

</html>