java mysql操作

import java.awt.Insets;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.mysql.jdbc.PreparedStatement;
import com.mysql.jdbc.Statement;
public class yichang {

	/**
	 * @param args
	 */
	  static Connection con;
	  static ResultSet res;
	  static java.sql.Statement sql;
	  public Connection getConnection()
	  {
		  try {
				Class.forName("com.mysql.jdbc.Driver"); //mysql驱动名
				System.out.println("数据库驱动加载成功");
			} catch (ClassNotFoundException e) {
				e.printStackTrace();
			}
			try{
				con=DriverManager.getConnection("jdbc:mysql://localhost:3306/db_jbdc","root","");  //数据库名称
				System.out.println("数据库连接成功");   //连接
			}catch(SQLException e)
			{
				e.printStackTrace();
			}
			return con;
	}
	public static void main(String[] args) {
		yichang c=new yichang();
		con=c.getConnection();
		/*try{
		      sql=con.createStatement();  //查询
		      res=sql.executeQuery("select *from wsp1");  //表名称
		      while(res.next())
		      {
		    	  String id=res.getString("id");     
		    	  String name=res.getString("name");
		    	  String score=res.getString("score");
		    	  System.out.println(id+" "+name+" "+score);
		      }
		}catch(SQLException e)
		{
			e.printStackTrace();
		}*/
		/*try{
			sql=con.createStatement();
			res=sql.executeQuery("select *from wsp1 where name like'王%'");//模糊查询 这地方是开头为王，%王为结尾，
			while(res.next())                                        //%王%为中间包含
			{
				String name=res.getString("name");
				System.out.println(name);
			}
		}catch(SQLException e)
		{
			e.printStackTrace();
		}*/
		/*try{   // 预处理语句
			java.sql.PreparedStatement sq=con.prepareStatement("select *from wsp1 where id=?");
			sq.setInt(1,2);
			res=sq.executeQuery();
			while(res.next())
			{
				String id=res.getString("id");
				String name=res.getString("name");
				System.out.println(id+" "+name);
			}

		}catch(Exception e)
		{
			e.printStackTrace();
		}*/
		try{  //数据的添加，修改，删除
sq=conn.prepareStatement("insert into custom (name,password,form) values (?,?,?)");  //添加数据
sq.setString(1,rname);
sq.setString(2,pass);
sq.setInt(3,0);
sq.executeUpdate();

			
			/*java.sql.PreparedStatement sq=con.prepareStatement("update wsp1 set score=?,name=? where id=?");
			sq.setInt(1, 11);     //修改语句：第一个？更新score 第二个更新name 第三个查找id
			sq.setString(2,"zz");
		     sq.setInt(3,2);
			sq.executeUpdate();*/

			java.sql.PreparedStatement sq=con.prepareStatement("delete from wsp1  where id=?");
			sq.setInt(1, 4);
			sq.executeUpdate();
		}catch(Exception e)
		{
			e.printStackTrace();
		}

}
}

 传入MySQL时间  
设置单元格式为 datetime

Date date = new Date();//获得系统时间.
String nowTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(date);//将时间格式转换成符合Timestamp要求的格式.
Timestamp ndate = Timestamp.valueOf(nowTime);//把时间转换

sq=conn.prepareStatement("insert into liuyan (content,date) values (?,?)");
sq.setString(1,text);
sq.setTimestamp(2,ndate);