String user="root";
			String password="root";
			conn = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/mydbtest",
					user,
					password);
			System.out.println(conn.isClosed());
			/*
			 Statement stmnt = conn.createStatement();
			stmnt.execute("insert into test(id,txt,num) values (null,'Michael',33);");
			****
			stmnt.addBatch("insert into test(id,txt,num) values (null,'Michael',33);");
			stmnt.addBatch("insert into test(id,txt,num) values (null,'You',34);");
			stmnt.executeBatch();
			stmnt.clearBatch();
			****
			ResultSet rs=stmnt.executeQuery("select * from test;");
			while(rs.next())
				System.out.println(rs.getInt(1)+"  "+rs.getString(2)+"  "+rs.getString(3));
			conn.close();
			stmnt.close();
			 */
			PreparedStatement pstmnt = conn.prepareStatement("insert into test(id,txt,num) values (null,?,?);");
			pstmnt.setString(1,"abctest");
			pstmnt.setInt(2,17);
			pstmnt.execute();
			pstmnt.close();