数据库连接

package com.cl.util;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class addvisiter {

public static void main(String[] args) {

String url = "jdbc:mysql://localhost:3306/ch316";

String user = "root";

String password = "123456";

try {

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

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

Statement statement = conn.createStatement();

String sql = "INSERT INTO visiter VALUES('wei','123','魏奕然','6666@163.com',6666)";

int i = statement.executeUpdate(sql);

System.out.println(i);

ResultSet resultSet = statement.executeQuery(sql);

statement.close();

conn.close();

}catch(Exception e) {

e.printStackTrace();

}

}

}