因为我本身没装Mysql,所以想方设法让JSP能连接上SQL2008。
<%@ page language="java" import="java.util.*"%>
<%@ page pageEncoding="ISO-8859-1"%>
<%@page import="java.sql.SQLException"%>
<%@page import="java.net.ConnectException"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.*"%>
<html>
<body>
<%
String user = "sa";//用户名
String password = "123456";//密码
String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //驱动
String url = "jdbc:sqlserver://localhost:1433;DatabaseName=hospital3"; //url
Connection conn = null;
Statement stmt = null;
try {
Class.forName(driver).newInstance(); //加载驱动
conn = DriverManager.getConnection(url, user, password); //获取连接
stmt = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_READ_ONLY);
out.println("Connection is succeed !");
} catch (Exception e) {
out.println("Exception msg: " + e.toString());
}
%>
</body>
</html>
搜索
复制