JSP连接SQL Server数据库

来源：互联网发布：mysql bit 对应java 编辑：程序博客网时间：2024/04/28 06:58

<%@page contentType="text/html;charset=GB2312" %>
<%@page import="java.sql.*" %>

<HTML>
<HEAD>
<TITLE> JSP Connection SQL DataBase </TITLE>
<font color=blue>
<h1 align=center> JSP Connection SQL DataBase </h1>
</font>
</HEAD>

<BODY bgcolor="#aacc77">
<%!
   Connection dbcon;
   String restr1=null, restr2=null;
%>
<font size=+3 color=red>
<%
try
{
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   dbcon = DriverManager.getConnection("jdbc:odbc:DB","sa","sa");

//这里的DB是数据源哈
   out.println("connection successful !! <br>");
}
catch(ClassNotFoundException e)
{
   out.println("Database driver not found");
   out.println(e.toString());
}
catch (Exception e)
{
   out.println("UNKNOWN The DataBase !?");
}

   Statement state = dbcon.createStatement();
   String sqlcommand = "select * from login";
   ResultSet res = state.executeQuery(sqlcommand);

   while(res.next())
   {
   restr1 = res.getString(1);
     out.println("<br> The c_Accountid is :" + restr1 );
     restr2= res.getString(2);
     out.println("The cPIN_no is : " + restr2 + "<br>");
   }

out.println("operater database successful!!");
res.close();
state.close();
dbcon.close();
%>
</font>
</BODY>
</HTML>