package?com.imooc.dao;

import?java.sql.Connection;
import?java.sql.Date;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.List;

import?com.imooc.db.DBUtil;
import?com.imooc.model.Goddess;

public?class?GoddessDao?{
	public?void?addGoddess(Goddess?g)?throws?Exception?{
		Connection?conn?=?DBUtil.getConnection();
		String?sql?=?""?+?"insert?into?imooc_goddess"?+?"(user_name,sex,age,birthday,email,mobile,"
				+?"create_user,create_date,update_user,update_date,isdel)"?
				+?"values("
				+?"?,?,?,?,?,?,?,current_date(),?,current_date(),?)";//?用預編譯符占位，后面兩個日期直接用sql中的日期函數(shù)
		PreparedStatement?ptmt?=?conn.prepareStatement(sql);//?預編譯sql語句
		//?給預編譯符賦值
		ptmt.setString(1,?g.getUser_name());//?把數(shù)據(jù)集成的傳遞過來，不要寫死，方便前臺操作
		ptmt.setInt(2,?g.getSex());
		ptmt.setInt(3,?g.getAge());
		//?ptmt.setDate(4,?g.getBirthday());
		//類型不符，這里的getBirthday傳回java.util.birthday類型
		ptmt.setDate(4,?new?Date(g.getBirthday().getTime()));//?此處date為sql類型
		ptmt.setString(5,?g.getEmail());
		ptmt.setString(6,?g.getMobile());
		ptmt.setString(7,?g.getCreate_user());
		ptmt.setString(8,?g.getUpdate_user());
		ptmt.setInt(9,?g.getIsdel());
		ptmt.execute();
	}

	public?void?updateGoddess()?{

	}

	public?void?delGoddess()?{

	}

	public?List<Goddess>?query()?throws?Exception?{
		Connection?conn?=?DBUtil.getConnection();
		Statement?stmt?=?conn.createStatement();
		ResultSet?rs?=?stmt.executeQuery("select?user_name,age?from?imooc_goddess");
		List<Goddess>?gs?=?new?ArrayList<Goddess>();
		Goddess?g?=?null;
		while?(rs.next())?{
			g?=?new?Goddess();
			g.setUser_name(rs.getString("user_name"));
			g.setAge(rs.getInt("age"));
			gs.add(g);
		}
		return?gs;
	}

	public?Goddess?get()?{
		return?null;
	}
	}

package?com.imooc.action;

import?java.util.Date;
import?java.util.List;

import?com.imooc.dao.GoddessDao;
import?com.imooc.model.Goddess;

public?class?GoddessAction?{
	public?static?void?main(String[]?args)?throws?Exception?{

		GoddessDao?g?=?new?GoddessDao();
		/*
		?*?查詢
		?*?List<Goddess>?gs=g.query();
		?*?for(Goddess?goddess:gs){
		?*?System.out.println(goddess.getUser_name()+","+goddess.getAge());?}
		?*/
		
		Goddess?g1=new?Goddess();
		g1.setUser_name("小夏");
		g1.setAge(22);
		g1.setSex(1);
		g1.setBirthday(new?Date());//此處Date為util類型
		g1.setEmail("xiaoxia@imooc.com");
		g1.setMobile("18766888866");
		g1.setCreate_user("ADMIN");
		g1.setUpdate_user("ADMIN");
		g1.setIsdel(1);
		g.addGoddess(g1);
	}
}

Exception in thread "main" com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'update_user' in 'field list'

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)

at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:882)

at com.imooc.dao.GoddessDao.addGoddess(GoddessDao.java:35)

at com.imooc.action.GoddessAction.main(GoddessAction.java:30)