mainjdbc.java

java 数据库操作的简单示例 利用mysql类型数据库

package firstJdbc;

import java.sql.Connection;
import java.sql.DriverManager;

public class MainJdbc {

	public static void main(String[] args) {
		MainJdbc mj = new MainJdbc();
		mj.initDatabase();
	}
	
	public void initDatabase(){
		try{
			//1，加载驱动
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			//2.连接数据库   jdbcURL =协议（协议前缀+数据库类型+://）+主机+":"+端口+/+数据库名
			String protocolPrefix = "jdbc:";
			String databaseType = "mysql";
			String protocol = protocolPrefix+databaseType+"://";
			String host = "127.0.0.1";
			String port = "3306";
			String databaseName = "netjava";
			String jdbcURL = protocol+host+":"+port+"/"+databaseName;
			java.sql.Connection conn = java.sql.DriverManager.getConnection(jdbcURL, "root", "netjava");
			//3.开始执行SQL语句
			String sql = "create database user;";
			java.sql.Statement stmt = conn.createStatement();
			stmt.executeUpdate(sql);
			System.out.println("create succeed!!!");
			conn.close();
			if(conn.isClosed())
				System.out.println("connection is is closed");
		}catch(Exception ex){
			ex.printStackTrace();
		}
	}
}