连接SQL Server
import java.sql.Connection;import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public classTest {
private Connection conn;
private String CLASSFORNAME=com.microsoft.sqlserver.jdbc.SQLServerDriver";
private String url ="jdbc:sqlserver://127.0.0.1:1433;databaseName=framework";
private String user="sa";
private String password="";
boolean ConnectionDataBase()
{
Properties sysProps = System.getProperties();
sysProps.put("user",user);
sysProps.put("password",password);
try
{
Class.forName(CLASSFORNAME);
conn= DriverManager.getConnection(url, sysProps);
return true;
}
catch(Exception e)
{
e.printStackTrace();
return false;
}
}
}
//"com.microsoft.jdbc.sqlserver.SQLServerDriver""
页:
[1]