连接mysql的字符串,注意使用细节。
- Connection=
- ("jdbc:mysql://localhost:3306/dataname","root","password")
举例1:
- 连接字符串
- MySqlConnection conn = new MySqlConnection("User Id=root;Password=sa;Host=localhost;Database=mis;");
- conn.Open();
- MySqlDataAdapter da = new MySqlDataAdapter("select id, name, age from `mis`.`users` ",conn);
- DataSet ds = new DataSet();
- da.Fill(ds,"users");
- conn.Close();
- DataGrid1.DataSource= ds;
- DataGrid1.DataBind();
举例2:
- package com;
- import java.sql.*;
- public class ssss {
- public static void main(String args[]) {
- try {
- Class.forName("org.gjt.mm.mysql.Driver");
- //加载MYSQL JDBC驱动程序
- System.out.println("Success loading Mysql Driver!");
- }
- catch (Exception e) {
- System.out.print("Error loading Mysql Driver!");
- e.printStackTrace();
- }
- try {
- Connection connect = DriverManager.getConnection(
- "jdbc:mysql://localhost/student", "root", "123");
- // 连接URL为 jdbc:mysql//服务器地址/数据库名
- // 后面的2个参数分别是登陆用户名和密码
- System.out.println("Success connect Mysql server!");
- Statement stmt = connect.createStatement();
- ResultSet rs = stmt.executeQuery("select * from teststudent");
- while (rs.next()) {
- System.out.println(rs.getString("sn")+"---"+rs.getString("ss"));
- }
- }
- catch (Exception e) {
- System.out.print("get data error!");
- e.printStackTrace();
- }
- }
- }