My first pieces of web db code. Without ORM. or ActiveRecord.

comment.java

		public void addAComment(Comment c) throws Exception{
			openConnection();
			Statement st = connection.createStatement();
			String query = "insert into comments (comment,personid,personname,issueid,commenton,companyid) " +
					"values('"+c.getComment()+"',"+c.getPersonid()+",'"+c.getPersonname()+"',"+c.getIssueid()+",'"+c.getCommenton()+"',"+c.getCompanyid()+")";
			st.execute(query);
			System.out.println("====Comment added");
			closeConnection();
		}
		
		public void deleteAComment(int id) throws Exception{
			openConnection();
			Statement st = connection.createStatement();
			String query = "delete from comments where commentid="+id;
			
			st.executeUpdate(query);
			System.out.println("=====Comment deleted");
			closeConnection();
		}