连接数据库的工具类，实现数据的插入

一、建立连接数据库的工具类

package util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class DbUtil {

	
		private static String dbUrl="jdbc:mysql://localhost:3306/test?characterEncoding=utf8";
		private static String  UserName="root";
		private static String  PassWord="123456";
		private static String  jdbcName="com.mysql.jdbc.Driver";
		
		/**
		 * 获取数据库连接
		 * @param args
		 */
		public  Connection getCon() throws Exception{
			Class.forName(jdbcName);
			Connection con=DriverManager.getConnection(dbUrl,UserName,PassWord);
			return con;	
		}
		/**
		 * 关闭连接
		 * @param con
		 * @throws Exception
		 */
		public void close(Connection con,Statement state)throws Exception{
			if(con!=null){
				state.close();
				con.close();
			}
		}
		
		

二、实现数据的插入

package zhuling.jdbc;

import java.sql.Connection;
import java.sql.Statement;

import util.DbUtil;

public class Demo2 {

	public static int addUser(String UserName,int age) throws Exception {
		DbUtil dbUtil = new DbUtil();
		String sql = "insert into user values(null,'"+UserName+"',"+age+")";		
		Connection con = dbUtil.getCon();// 获取连接
		Statement state = con.createStatement(); //获取Statement
		int result = state.executeUpdate(sql);
		System.out.println(result + "行受影响");
		dbUtil.close(con, state);//关闭连接
		return result;
	}
	
	public static void main(String[] args) throws Exception{
		int result=addUser("徐林",22);
		if(result==1){
			System.out.println("插入成功！");
		}
		
	}
}