import java.sql.*;

public class InsertData
{
 public void run (int c,String path,String photo,String msg,String ip,String sendaddr)
  {
	String sql;
	try {
      // The newInstance() call is a work around for some
      // broken Java implementations
      Class.forName("org.gjt.mm.mysql.Driver").newInstance();
    }
    catch (Exception E) {
    	System.err.println("Unable to load driver.");
        E.printStackTrace();
    }
	//sql="insert into message(check, path, photo, msg, ip) values(c,path,photo,msg,ip)";
	sql="insert into message(check, path, photo, msg, ip, sendaddr) values(\""+c+"\", \""+path+"\", \""+photo+"\", \""+msg+"\", \""+ip+"\", \""+sendaddr+"\")";

	//印出sql語法
	System.out.println(sql);
    try {
		/* Connection Management */
    	Connection conn =
               DriverManager.getConnection("jdbc:mysql://localhost:3306/MMS_Messages","luckystraw","babyweiwei");
		conn.setAutoCommit(true);

    	/* Create stmt and process some basic SQL statements */
    	Statement stmt = conn.createStatement();
    	//stmt.execute("drop table message");   	
		//stmt.execute("create table message(check int, path varchar(25), photo varchar(25), msg varchar(25), ip varchar(25))");
    	//stmt.execute("insert into message values(0,'c:/test','1.jpg','msg1.txt','ip1.txt')");
    	//stmt.execute("insert into message values(1,'c:/test','2.jpg','msg2.txt','ip2.txt')");
		//sql="insert into message values("+c+","+path+","+photo+","+msg+","+ip+")";
		stmt.execute(sql);
	    
    	/* Result set */
    	//System.out.println("--------------------資料庫現有data---------------------");
		ResultSet rs = stmt.executeQuery("SELECT * FROM message");
    	while (rs.next())
    	{
			//System.out.print("check:"+rs.getInt(1)+"\t");
			//System.out.print("path:"+rs.getString(2)+"\t");
			//System.out.print("photo:"+rs.getString(3)+"\t");
			//System.out.print("msg:"+rs.getString(4)+"\t");
			//System.out.println("ip:"+rs.getString(5));
		}

		// Clean up after ourselves
		rs.close();
		stmt.close();
		conn.close();
	}
	catch (SQLException E) {
	    System.out.println("SQLException: " + E.getMessage());
		System.out.println("SQLState:     " + E.getSQLState());
	    System.out.println("VendorError:  " + E.getErrorCode());
	}

  }
  public static void main(String[] Args)
  {
   InsertData test = new InsertData();
   test.run(0,"C:/AppServ/www/TheZoo/Messages/ u9127400/","1.jpg","1.txt","140.115.206.29","u9127400@cc.ncu.edu.tw");
  }
}