Microsoft SQL Server 2005 JDBC 驱动程序下载 http://www.xin126.cn/soft_show.asp?id=24
下载后解压,将sqljdbc.jar存放在web服务目录的WEB_INF/lib/目录下。
JSP使用纯Java数据库驱动程序连接数据库,读取数据库信息并显示:
代码如下:
<% Connection con;
Statement sql;
ResultSet rs;
try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
}
catch(Exception e)
{ out.print(e);
}
try {String uri=
"jdbc:sqlserver://127.0.0.1:1433;DatabaseName=employee";
String user="sa";
String password="2005";
con=DriverManager.getConnection(uri,user,password);
sql=con.createStatement();
rs=sql.executeQuery(“select * from employee_info where salary>3000");
out.print("<table border=2>");
out.print("<tr>");
out.print("<th width=100>"+"雇员号");
out.print("<th width=100>"+"姓名");
out.print("<th width=50>"+"出生日期");
out.print("<th width=50>"+"薪水");
out.print("</tr>");
while(rs.next())
{ out.print("<tr>");
out.print("<td >"+rs.getString(1)+"</td>");
out.print("<td >"+rs.getString(2)+"</td>");
out.print("<td >"+rs.getDate("birthday")+"</td>");
out.print("<td >"+rs.getFloat("salary")+"</td>");
out.print("</tr>") ;
}
out.print("</table>");
con.close();
}
catch(SQLException e)
{ out.print(e);
}
%>
Statement sql;
ResultSet rs;
try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
}
catch(Exception e)
{ out.print(e);
}
try {String uri=
"jdbc:sqlserver://127.0.0.1:1433;DatabaseName=employee";
String user="sa";
String password="2005";
con=DriverManager.getConnection(uri,user,password);
sql=con.createStatement();
rs=sql.executeQuery(“select * from employee_info where salary>3000");
out.print("<table border=2>");
out.print("<tr>");
out.print("<th width=100>"+"雇员号");
out.print("<th width=100>"+"姓名");
out.print("<th width=50>"+"出生日期");
out.print("<th width=50>"+"薪水");
out.print("</tr>");
while(rs.next())
{ out.print("<tr>");
out.print("<td >"+rs.getString(1)+"</td>");
out.print("<td >"+rs.getString(2)+"</td>");
out.print("<td >"+rs.getDate("birthday")+"</td>");
out.print("<td >"+rs.getFloat("salary")+"</td>");
out.print("</tr>") ;
}
out.print("</table>");
con.close();
}
catch(SQLException e)
{ out.print(e);
}
%>