连接 sql

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();