 |
| JSP execution |
//////////////////////////////////////////////////////////////////////
// CATEGORIES
package entities;
import java.io.Serializable;
import javax.persistence.*;
import java.util.List;
/**
* The persistent class for the Categories database table.
*
*/
@Entity
@Table(name="Categories")
public class Categories implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@Column(name="CategoryId", unique=true, nullable=false)
private String categoryId;
@Column(name="CategoryName")
private String categoryName;
@Column(name="Description", length=50)
private String description;
//bi-directional many-to-one association to Products
@OneToMany(mappedBy="category", cascade={CascadeType.PERSIST, CascadeType.REMOVE})
private List products;
public Categories() {
}
public String getCategoryId() {
return this.categoryId;
}
public void setCategoryId(String categoryId) {
this.categoryId = categoryId;
}
public Object getCategoryName() {
return this.categoryName;
}
public void setCategoryName(String categoryName) {
this.categoryName = categoryName;
}
public String getDescription() {
return this.description;
}
public void setDescription(String description) {
this.description = description;
}
public List getProducts() {
return this.products;
}
public void setProducts(List products) {
this.products = products;
}
}
//////////////////////////////////////////////////////////////////////
// PRODUCTS
package entities;
import java.io.Serializable;
import javax.persistence.*;
/**
* The persistent class for the Products database table.
*
*/
@Entity
@Table(name="Products")
public class Products implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@Column(name="ProductId", unique=true, nullable=false)
private String productId;
@Column(name="ProductName", length=50)
private String productName;
@Column(name="Supplier", length=50)
private String supplier;
//bi-directional many-to-one association to Categories
@ManyToOne
@JoinColumn(name="CategoryId")
private Categories category;
public Products() {
}
public String getProductId() {
return this.productId;
}
public void setProductId(String productId) {
this.productId = productId;
}
public String getProductName() {
return this.productName;
}
public void setProductName(String productName) {
this.productName = productName;
}
public String getSupplier() {
return this.supplier;
}
public void setSupplier(String supplier) {
this.supplier = supplier;
}
public Categories getCategory() {
return this.category;
}
public void setCategory(Categories category) {
this.category = category;
}
}
public static void main()
{
// Creating entity manager to create Db query
EntityManagerFactory factory = Persistence.createEntityManagerFactory("WebWithJPA");
javax.persistence.EntityManager em = factory.createEntityManager();
try
{
// Creating Query using JPQL
Query objQuery = em.createQuery("select c from Categories c");
// Getting result set in List
List objC = (List) objQuery.getResultList();
// Listing all categories and its related products
for (Categories c : objC)
{
System.out.println("Category Name: " + c.getCategoryName());
for (Products p : c.getProducts())
{
System.out.println("* " + p.getProductName());
}
}
}
//******** File reading using scanner
/**
* Read given file line by line
* @param m_strFileName File name
* @throws Exception File not exist
* @auther Amit 31/10/2011
*/
void printFile(String m_strFileName) throws Exception {
// Create an instance of File for data file.
File objFile = new File(m_strFileName);
if(objFile.exists() == false)
{
throw new Exception(m_strFileName + "File does not exist");
}
// Reading and displaying file line by line
Scanner objScanner = new Scanner(objFile);
while(objScanner.hasNextLine() == true)
{
System.out.println(objScanner.nextLine());
}
objScanner.close();
}
//********** Using FileInputStream
// Get the object of DataInputStream, passing FileInputStream
DataInputStream in = new DataInputStream(new FileInputStream("anyfile.txt"));
BufferedReader br = new BufferedReader(new InputStreamReader(in));
String strLine;
//Read File Line By Line
while ((strLine = br.readLine()) != null)
{
// Print the line on the console
System.out.println (strLine);
}
in.close();
Amit +91-9033334254 1986-01-01 Male Single
ASI
IND
2000-01-10
// Creating Object of XML Serializer for Getting Data into Emplyee Object
XmlSerializer objXmlSerializer = new XmlSerializer(typeof(Employees));
TextReader objTextReader;
Stream objStream = null;
FileStream objFileStream = null;
// Generated class from xsd.exe
Employees objEmployees = null;
objFileStream = new FileStream("Employee.xml", FileMode.OpenOrCreate);
objTextReader = new StreamReader(objFileStream);
// Get the xml data into the objEmployees obj
objEmployees = (Employees)objXmlSerializer.Deserialize(objTextReader);
objFileStream.Close();
///
/// Display Employees Records on Console
///
public void DisplayEmployeeInfo(Employees Employee)
{
if (Employee == null )
{
Console.WriteLine(Defination.NoRecordFound);
return;
}
for (int nIndex = 0; nIndex < Employee.Length; nIndex++)
{
// Calculating emp age
TimeSpan objTimeSpan = DateTime.Now - DateTime.Parse(Employee[nIndex].BirthDate);
Console.Write("{0}\t{1}\t{2} {3} ", Employee[nIndex].Name, Employee[nIndex].Telephone, ((int)objTimeSpan.TotalDays / 365), Employee[nIndex].RelationshipStatus);
Console.Write("\t{0}\t{1}\t{2}", Employee[nIndex].Branch[0].Name, Employee[nIndex].Branch[0].CountryCode, Employee[nIndex].Branch[0].EstablishmentDate);
Console.WriteLine();
}
}
// for insert / update just take new emplyees obj and serialize it
Employees objNewEmployees = new Employees();
// fill the required info like u get it in Display() method
...
...
XmlSerializer serializer = new XmlSerializer(typeof(Employees));
TextWriter textWriter = new StreamWriter("New file.xml");
serializer.Serialize(textWriter, objNewEmployees);
textWriter.Close();
// Setting Thumbnail size
int height = 600;
int width = 400;
// Getting desired image
Bitmap objImage = new Bitmap("--file path --");
// Showing image in picturebox, here pictureBox1 is pictureBox control
pictureBox1.Image = objImage.GetThumbnailImage(width, height,null, IntPtr.Zero);
ILMerge.exe" in your \WINNT directory
ilmerge /out:$(TargetDir)YOURAPPNAME.exe $(TargetPath) $(TargetDir)YOURDLLNAME.dllbin\Release" directory, you will find a YOURAPPNAME.exe which can be run on its own without the .dll.