67,515
社区成员
发帖
与我相关
我的任务
分享
<%@ page import="java.sql.*"import="java.lang.*" errorPage="err.jsp" contentType="text/html;charset=GBK"%>
<%
String driverClassName;
String url;
Connection conn = null;
//加载sqlserver2000驱动
try{
driverClassName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
Class.forName(driverClassName);
}catch(ClassNotFoundException e){
out.println("无法加载驱动程序:<br>"+e.toString());
}
try{
url="jdbc:microsoft sqlserver://host:1433;DatabaseName=zulin";
conn = DriverManager.getConnection(url,"sa","yangguang123");
out.println("<p>成功连接到SQLserver数据库</p>");
}catch(SQLException e){
out.println("连接SqlServer2000时出现错误:<br>"+e.toString());
}
finally{
conn.close();
}
%>
<%@ page import="java.sql.*"import="java.lang.*" contentType="text/html;charset=GBK"%>
<%
String driverClassName;
String url;
//Connection conn = null;
//加载sqlserver2000驱动
try{
driverClassName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
Class.forName(driverClassName);
}catch(ClassNotFoundException e){
out.println("无法加载驱动程序:<br>"+e.toString());
}
try{
url="jdbc:microsoft:sqlserver://locahost:1433;DatabaseName=zulin";
Connection conn = DriverManager.getConnection(url,"sa","yangguang123");
out.println("<p>成功连接到SQLserver数据库</p>");
}catch(SQLException e){
out.println("连接SqlServer2000时出现错误:<br>"+e.toString());
}
finally{
// conn.close();
;
}
%>
package JDBC;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class sssss {
public static Connection getConnect(){
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=zulin;SelectMethod=cursor;tds=8.0;lastupdatecount=true";
String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String password="";
String user="";
Connection conn = null;
try {
Class.forName(CLASSFORNAME);
conn = DriverManager.getConnection(url, user, password);
} catch (Exception e) {
e.printStackTrace();
System.out.println("一般错误是不体现在前台的,那是不有好的");
}
return conn;
}
}
//如果一定要用JSP页面做JDBC链接,可以把稍作修改即可!!没什么两样。学习的时候要选择优秀的实例