package myexample;
import java.io.*;
import java.sql.*;
 
public class bean {
  private int msgid;
  private String message;
    private Connection connection=null;
    private ResultSet rs = null;
    private Statement st = null;
  String connectionURL = "jdbc:mysql://localhost:3306/steflik";

  public bean() {
    try {
      Class.forName("com.mysql.jdbc.Driver");
      connection = DriverManager.getConnection(connectionURL, "userid", "********"); 
    }catch(Exception e){
      System.out.println("Exception is ;"+e);
    }
  }  

  public void setmsgid(int msgid){
    this.msgid = msgid;
  }

  public int getmsgid(){
    return (this.msgid);
  }

  public void setmessage(String message){
    this.message = message;
  }

  public String getmessage(){
    System.out.println("Message: "+message);
    return (this.message);
  }

  public void insert(){
    try{
      if(message!=null)
      {
      String sql = "insert into artist  values(null,'" + message + "')";
      Statement s = connection.createStatement();
      s.executeUpdate (sql);
      s.close ();
      }
    }catch(Exception e){
      System.out.println("Exception is ;"+e);
    }
  }
}