package User;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class db {

private static final String URL="JDBC:mysql://127.0.0.1:3306/testone";

private static final String USER="root";

private static final String PASSWORD="";

public static void main(String[] args) throws Exception{

//加載驅(qū)動

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

? ?//獲得數(shù)據(jù)鏈接

Connection conn=DriverManager.getConnection(URL, USER, PASSWORD);

//實(shí)現(xiàn)增刪改查

Statement stmt=conn.createStatement();

ResultSet rs=stmt.executeQuery("select username from use");

while(rs.next()){

System.out.println(rs.getInt("name"));

}

}