java连接sqlserver
1 创建 dynamic web project项目
在webcontent/web-inf/lib中添加sqljdbc42.jar
2 在class文件里连接数据库
class.forname("com.microsoft.sqlserver.jdbc.sqlserverdriver");
string url = "jdbc:sqlserver://localhost:1433;databasename = text";
string a = "sa";
string b = "admin";
connection conn=drivermanager.getconnection(url,"sa","admin");
preparedstatement pstat = conn.preparestatement(sql);
resultset rs = pstat.executequery();
---------------------------------------------------------
statement stat = conn.createstatement();
resultset rs = stat.executequery(sql);
spring中连接sqlserver
1 添加sqljdbc.jarjiabao
<dependency>
<groupid>com.microsoft.sqlserver</groupid>
<artifactid>sqljdbc4</artifactid>
<version>4.2</version>
</dependency>
2 在配置文件中连接数据库(application.yml)
spring:
datasource:
url: jdbc:sqlserver://localhost:1433;databasename=practice
driver-class-name: com.microsoft.sqlserver.jdbc.sqlserverdriver
username: sa
password: admin
3 操作数据库
@autowired
jdbctemplate jdbctemplate;
public list<studentbean> getstudentbyrubric(string id){
list<studentbean> user = jdbctemplate.query("select * from student where rid ='"+id+"'",
new beanpropertyrowmapper<studentbean>(studentbean.class));
return user;
}
4 idea中有数据库插件可以将microsoft sql server management studio 17中需要操作的数据库导入idea
database->new->data source->microsoft sql server->port(1433),instance(数据库名)->test connection
c#连接sqlserver
1 加载数据库
工具->连接数据库->microsoft sql server (sqlclient)->服务器名(登录microsoft sql server management studio使得服务器名称)->其他操作
2 连接数据库
using system.data.sqlclient;
string url = 服务器资源管理器->数据连接->属性->连接字符串
sqlconnection conn = new sqlconnection(url)
3 操作数据库
string sql = "select * from table";
sqlcommand cmd = new sqlcommand(sql, conn)
conn.open();
cmd.commandtype = commandtype.text;
sqldatareader re = cmd.executereader();
---------------------------------------------------------------
cmd.commandtype = commandtype.text;
result = cmd.executenonquery();
qt连接数据库
1 创建odbc
打开odbc数据资源管理程序->添加->sql server->服务器(登录ssms的服务器名称)->选择登陆的类型->选择要添加的数据库
2 连接odbc
qsqldatabase db = qsqldatabase::adddatabase("qodbc");
qstring dsn = qstring::fromlocal8bit(创建sql server odbc的名称);
db.sethostname("127.0.0.1");
db.setdatabasename(dsn);
db.setusername("sa");
db.setpassword("admin");
db.open();
3 操作数据库
qsqlquery query(db);
query.exec("select * from student");
db.close();