jdbc

package jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class TestJDBC {
private static String url = "jdbc:mysql://127.0.0.1/zijin";
private static String username = "root";
private static String password = "root";
private static String driverName = "com.mysql.jdbc.Driver";

public static void create(){
	Connection con = null;    //获取连接
	Statement stat = null;     //获取状态
	try {
		//加载驱动
		Class.forName(driverName);		
		con = DriverManager.getConnection(url, username, password);
		stat = con.createStatement();
		System.out.println("连接成功");
		//sql语句
		String sql = new StringBuffer()
							.append("create table t_student ")
							.append(" (id int,name varchar(10),")
							.append("age int,sex boolean);")
							.toString();
		stat.execute(sql);
	} catch (ClassNotFoundException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	} finally{
		//关闭数据库
		if (stat!=null) {
			try {
				stat.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		if (con!=null) {
			try {
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
}
public static void main(String[] args) {
	// TODO Auto-generated method ytub
	create();
}

}