JSP连接SQL2008

来源：互联网发布：泰兴减速机js txjsj 编辑：程序博客网时间：2024/05/20 07:53

因为我本身没装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"; //urlConnection 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>

搜索

复制

0 0