简单测试连接mysql数据库

来源：互联网发布：部落冲突vb.67.9破解版编辑：程序博客网时间：2024/06/05 08:29

//写入数据库的脚本，用于创建数据表
create table ceshi(
id int primary key auto_increment,
user_name varchar(30) not null,
age int,
)engine= innodb default charset=utf8 auto_increment=1;

altern database test default character set 'utf8';
SET character_set_client='utf8';
SET character_set_connection='utf8';
SET character_set_results='utf8';

//检测是否连接上数据表
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;

public class DBUtil {
private static final String URL= "jdbc:mysql://127.0.0.1:3306/test";
private static final String NAME="root";
private static final String PASSWORD="/*数据库的密码*/";
public static void main(String[] args) throws ClassNotFoundException, SQLException{
Class.forName("com.mysql.jdbc.Driver");
java.sql.Connection Conn= DriverManager.getConnection(URL, NAME, PASSWORD);
java.sql.Statement stme =Conn.createStatement();
ResultSet rs= stme.executeQuery("select name,age from ceshi");
while(rs.next()){
System.out.println(rs.getString("name")+","+rs.getInt("age"));
}
}
}

0 0