JSP连接SQL Server数据库

最新推荐文章于 2021-06-04 04:50:35 发布

ZhaoRNash

最新推荐文章于 2021-06-04 04:50:35 发布

阅读量379

点赞数

文章标签： sql server jsp database exception string null

本文链接：https://blog.csdn.net/ZhaoRNash/article/details/3253516

版权

<%@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>

ZhaoRNash

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
JSP连接SQL Server数据库

%@page contentType="text/html;charset=GB2312" %>%@page import="java.sql.*" %> JSP Connection SQL DataBase JSP Connection SQL DataBase Connection dbcon; String restr1=null, restr2=null;%>
复制链接

扫一扫