数据库连接以及增删操作

用的是Mysql数据库 JDBC访问方式 开发环境：myeclipse
package DBUtil;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Iterator;

import javaBean.User;


public class DBCon {
	private Connection con = null;
	private String driver = "com.mysql.jdbc.Driver";
	private String url = "jdbc:mysql://localhost:3306/test";
	private String username = "root";
	private String password = "";
	public	DBCon(){
			try {
				Class.forName(driver);
				System.out.println("加载成功！");
			} catch (ClassNotFoundException e) {
				e.printStackTrace();
			}
			try {
				con=DriverManager.getConnection(url,username,password);
				System.out.println("连接成功！");
			} catch (SQLException e) {
				
				e.printStackTrace();
			}
		
				}
	public void insert(){
		 try {
			 String sql="insert into user values(6,'乱码你妹','cao')";
				PreparedStatement   pstmt=con.prepareStatement(sql);
				pstmt.executeUpdate();
				System.out.print("添加成功!");
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
	}
	public void delete(){
		String sql="delete from user where id=6";
		try {
			PreparedStatement   pstmt=con.prepareStatement(sql);
			pstmt.executeUpdate();
			System.out.print("删除成功！");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public static void main(String[] args) {
		// TODO Auto-generated method stub
	DBCon dbcon=new DBCon();
	//dbcon.delete();
	dbcon.insert();
	}
}
如果Mysql中出现中文显示乱码问题只需要修改mysql的配置文件（my-default.ini）就彻底解决了注：需要重启mysql服务 ！加入如下内容：
[client]
default-character-set=utf8 
[mysqld]
character_set_server=utf8
<pre name="code" class="java">最后一句要加入mysql驱动程序