mysql链接串怎么写_MySQL链接字符串

java连接Mysql的连接字符串怎么写的

import java.sql.*;

public class SqlUtil

{

public static void main(String[] args)

try

String url="jdbc:mysql://localhost/mydb";

String user="root"; //用户名

//加载驱动,这一句也可写为：Class.forName("com.mysql.jdbc.Driver");

Class.forName("com.mysql.jdbc.Driver").newInstance();

//建立到MySQL的连接

Connection conn = DriverManager.getConnection(url,user, pwd);

//执行SQL语句

Statement stmt = conn.createStatement();//创建语句对象,用以执行sql语言

ResultSet rs = stmt.executeQuery("select * from student");

//处理结果集

while (rs.next())

String name = rs.getString("name");

System.out.println(name);

}

rs.close();//关闭数据库

conn.close();

catch (Exception ex)

System.out.println("Error : " + ex.toString());

}技术问题可到itjob技术群交流

c#连接到mysql 的连接字符串怎么写

ODBC DSN

ODBC -- MyODBC Driver -- local database

ODBC -- MyODBC Driver -- remote database

OleDb

.NET DataProvider from CoreLab

// ODBC DSN

using System.Data.Odbc;

OdbcConnection conn = new OdbcConnection();

conn.ConnectionString =

"Dsn=DsnName;" +

"Uid=UserName;" +

"Pwd=Secret;";

conn.Open();

// ODBC -- MyODBC Driver -- local database

"Driver={MySql};" +

"Server=localhost;" +

"DataBase=DataBaseName;"

// ODBC -- MyODBC Driver -- remote database

"Server=db.domain.com;" +

"Stmt=;" +

"DataBase=DataBaseName;" +

"Pwd=Secret;"

"Server=ServerName;" +

// or

"SERVER=ServerName;" +

"DATABASE=DataBaseName;" +

"USER=UrerName;" +

"PASSWORD=Secret;"

// OleDb

using System.Data.OleDb;

OleDbConnection conn = new OleDbConnection();

"Provider=MySqlProv;" +

"Data Source=ServerName;" +

"User id=UserName;" +

"Password=Secret;"

// .NET DataProvider from CoreLab

using CoreLab.MySql;

MySqlConnection conn = new MySqlConnection();

"Host=ServerName;" +

"Protocol=TCP;" +

"Direct=true;" +

"Compress=false;" +

"Pooling=true;" +

"Min Pool Size=0;" +

"Max Pool Size=100;" +

"Connection Lifetime=0;" +

"Password=Secret;" +

C#连接mysql数据库的字符串怎么写?

using MySql.Data.MySqlClient;

然后使用连接字符串的时候,使用以下代码：

MySqlConnectionStringBuilder s = new MySqlConnectionStringBuilder();

s.Database = "dbName";

s.UserID = "root";

s.Password = "root";

s.CharacterSet = "latin1";

MySqlConnection mcon = new MySqlConnection(s.ConnectionString);

其他的也要用mysql的,比如MySqlCommand等等.有疑问可以追问~

asp连接mysql字符串 怎么写

以上就是土嘎嘎小编为大家整理的mysql链接串怎么写相关主题介绍,如果您觉得小编更新的文章只要能对粉丝们有用,就是我们最大的鼓励和动力,不要忘记讲本站分享给您身边的朋友哦！！