java连接sqlserver2005数据库的用法
1、首先将sqljdbc4.jar驱动文件,放置项目文件夹的lib下面(自行下载)。
package DataBase;
import java.sql.*;
public class SqlserverConn {
public Connection conn;
public Statement st;
public ResultSet rs;
//获取链接
public Connection getConn() throws SQLException, ClassNotFoundException
{
String driverClassName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url = "jdbc:sqlserver://localhost:1433;databaseName=MyServer"; //:1433为数据库默认端口号,MyServer为数据库名字
String password = "sa"; //登录用户名
String user = "sa"; //登录密码
try {
Class.forName(driverClassName);
conn = DriverManager.getConnection(url, user, password);
System.out.println("数据库连接成功");
} catch (SQLException ex1)
{