C# web Web.config里sql连接数据库

访问数据库有两种方式：

Windows身份验证登录（不需要用户名和密码，适用于访问本地数据库，应用程序和SQL软件安装在同一台服务器）

SQL Server 身份验证登录（适用于访问其他计算机的数据库，当然也可以用这种方式访问本地数据库）

根据楼主的情况应该用 SQL Server 身份验证登录

数据库连接字符串一般写在 connectionStrings节点下，非强制性（如写在appsettings节点下），只不过这样可以用

ConfigurationManager.ConnectionStrings["connString"].ConnectionString

方便访问

以下是笔者的一个 web.config 文件的内容

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

<connectionStrings>

<add name="connString" connectionString="Data Source=.Initial Catalog=TestDatabaseIntegrated Security=SSPI"/>

</connectionStrings>

</configuration>

附：数据库连接字符串的写法

SQL Server connection strings

SQL ODBC connection strings

Standard Security:<br>"Driver={SQLServer}Server=Your_Server_NameDatabase=Your_Database_NameUid=Your_UsernamePwd=Your_Password"

Trusted connection:<br>"Driver={SQLServer}Server=Your_Server_NameDatabase=Your_Database_NameTrusted_Connection=yes"

SQL OLE DB connection strings

Standard Security:

"Provider=SQLOLEDBData Source=Your_Server_NameInitial Catalog= Your_Database_NameUserId=Your_UsernamePassword=Your_Password"

Trusted connection:

"Provider=SQLOLEDBData Source=Your_Server_NameInitial Catalog=Your_Database_NameIntegrated Security=SSPI"

SQL OleDbConnection .NET strings

Standard Security:

"Provider=SQLOLEDBData Source=Your_Server_NameInitial Catalog= Your_Database_NameUserId=Your_UsernamePassword=Your_Password"

Trusted connection:

"Provider=SQLOLEDBData Source=Your_Server_NameInitial Catalog=Your_Database_NameIntegrated Security=SSPI"

SQL SqlConnection .NET strings

Standard Security:

1. "Data Source=Your_Server_NameInitial Catalog= Your_Database_NameUserId=Your_UsernamePassword=Your_Password" <br>2. "Server=Your_Server_NameDatabase=Your_Database_NameUserID=Your_UsernamePassword=Your_PasswordTrusted_Connection=False"

Trusted connection:

1. "Data Source=Your_Server_NameInitial Catalog=Your_Database_NameIntegrated Security=SSPI"

2."Server=Your_Server_NameDatabase=Your_Database_NameTrusted_Connection=True"

希望回答对你有帮助

以java连接oracle为例：

1)首先要有java连接oracle数据库的驱动类,下载好后导入到工程里

2)代码:

import java.sql.*

public class JDBCTest {

/**

* @param args

* @throws ClassNotFoundException

*/

public static void main(String[] args)

throws ClassNotFoundException, SQLException{

//1.准备参数

String ip = "192.168.0.26"

String sid = "tarena"

String port = "1521"

String dbUser = "openlab"

String dbPassword = "open123"

String driver

= "oracle.jdbc.driver.OracleDriver"

//2.构造驱动实例

Class.forName(driver)

//3.创建连接

//连接字符串是固定的形式,oracle的形式:

String url

= "jdbc:oracle:thin:@"

+ ip + ":" + port + ":" + sid

Connection conn

= DriverManager.getConnection

(url, dbUser, dbPassword)

//4.执行SQL语句

String sql = "select id, password, name from user_sd1104 " +

"where id = 1001 and password = '1234'"

Statement stmt = conn.createStatement()

ResultSet rs

= stmt.executeQuery(sql)//执行sql语句

while(rs.next()){

int id = rs.getInt(1)

String pwd = rs.getString(2)

String name = rs.getString(3)

System.out.println("welcome," + name)

}

rs.close()

stmt.close()

conn.close()

}

}

---