环境:
jdk jdk-8u20-windows-x64.exe
服务器 Apache-tomcat-8.0.15
数据库 MSSQL2012
操作系统 windows server 2008 R2 标准版
telnet 127.0.0.1 1433 端口 开放
http://localhost:8080/marketplace/test.jsp
恭喜,数据库连接创建成功!
test.jsp
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page info="database handler"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<!--导入结束-->
<html>
<head>
<title>数据库连接实验111111111</title>
</head>
<body>
<%
String sDBDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //与解压到tomcat服务器那个文件路径相同
String sConnStr = "jdbc:sqlserver://localhost:1433;DatabaseName=db_shop";//“try”的意思就是与数据库设置的数据源名对应;与数据库中的名称要一致,必须要在sql中建立相应数据库
Connection Con = null;
Statement Stmt = null;
try
{
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
out.print("Connect to Database error: " + e.getMessage());
}
try
{
Con = DriverManager.getConnection(sConnStr,"sa","123456");//设置你登陆sql的用户和密码;例如:用户:“linxia” 密码:“123”(这是sql验证方式)
}
catch(SQLException e)
{
out.print(e.toString());
}
Stmt = Con.createStatement();
String query="CREATE TABLE GUEST" + "(NUM VARCHAR(32)," + "USERNAME TEXT," + "CONTENT TEXT," + "PASSWORD INTEGER," + "TOTAL INTEGER," + "REALNAME TEXT)";
Stmt.executeUpdate(query);
out.println("恭喜,数据库连接创建成功!");
}
catch (Exception e) {
out.println("出错了!");
}
%>
</body>
</html>