can't insert data to mysql
<p>I can connect fine in Netbeans using this:</p>

<pre><code> Connection conn = null;
 try{
     conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/librarymangementsystem","root","root");
     if(conn!= null)
     {
     System.out.println("connected");
     }
 }catch(Exception e)
             {
             System.out.println("not connected");
             }
}
</code></pre>

<p>But when it comes to adding data to the columns, i just cant.</p>

<pre><code>try{
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/librarymangementsystem","root","root");
        Statement stmt=conn.createStatement();
        String Query = "INSERT into librarian_details(username, name, email, password) VALUES("+ uname +", "+ fname +", " + emails + ",  " + psword +")";
        stmt.executeUpdate(Query);
        JOptionPane.showMessageDialog(null, "Success!");
     }
</code></pre>

<p>Anyone knows the problem?
Updated Problem:</p>

<blockquote>
  <p>String Query = "insert into book_details(Book_Name, ISBN, Author, Category, >Quantity, BookShelfNo,Row,Column) VALUES('" +bookname + "','" + ISBN + "','" + >AuthorName + "','" + Category + "','" + Quantity + "','" + ?BookShelfNo +"', '" >+ Row + "', '" + Column + "')";</p>
</blockquote>

<p>I cant seem to insert any data to Row and Column using this:</p>

<blockquote>
  <p>String Row = jTextField9.getText();
  String Column = jTextField10.getText();
  Row and Column Datatype is int.</p>
</blockquote>