peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

@Boss, I am newbie here working independently on this project.
I'm not boss, I'm student

@Frankly speaking I have no source of guidelines other than your forum.
So people from Sun Microsystem just waste their time creating their website with documentation and tutorials you been suggested to have look at? Plus many others that run other similar related sites?

@And can you suggest me some idea about how to restrict student against answering/polling same module twice.
There is more then one solution, but I would do it like this
Have module table that consist of

  • student_id (string)
  • test_table_name (string)
  • test_name (string)
  • taken (boolean) {default false}
  • score_or_mark (int or character depending on the marking system)
    1. A, B, C, D, E
    2. 1, 2, 3, 4, 5
    3. 10%, 20%, 30% (the sign of percentage doesn't have to be store, you should know what is stored)

Note: I would use test_table_name as this would enable me to have each test questions with possible answers, plus correct answer stored in different table (easier to maintain)

Lets say module has 3 marking assignments. Therefore student name will appear in the table 3x, each time with different name of the test. By default taken column will be false and will change to true as soon student submit the assignment. Will help of this column you will be able to display only test/assignments that have to be done.

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

@Kindly give me some guidelines regarding below issue.
Why should we do so? You so many times asked for help to just get quick solution and completely ignored other suggestions (I know I made most of the suggestions).

@Database structure - re do it, what you provided is ineffective rubbish

The whole questions/exam database is incorrectly lay out.

Take example college or university

  1. It is unlike that all student will be studying for same same degree (bioscience, IT, art, music etc.)
  2. It is unlike that even if they study for same degree they will take all same modules (IT students - programming languages C, C++, C#, Java; web development - HTML, PHP, ASP, ASP.NET, etc)
  3. they are on different level of study ( college/ university, 1st, 2nd, 3rd year of study)

Therefore when student log in, from his account info you should be able to pick up degree he/she is working toward, what level/year is in, what modules is taking and offer only test/exam relevant to that person. Also once the student took that exam it should not be available again to that person

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

The more appropriate/correct way to do it is to put jar files required by project in PROJECT_DIRECTORY/WEB-INF/lib

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

I do not understand what this has to do with database?

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Only people who can mark thread as solved is original poster or member of moderators team, but we usually leave it to poster

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Dude you should be slapped on your back side, you should know better then re-open 3 and half year old post and provide ZERO solution just pointless comment

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster
peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Just did little bit of search on internet and seems to me there is more trouble with use of the root then you want to go through. Just replace it with html or html,body

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Can you please post the JSP file?

PS: Please use code tags here is small help

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Incorrect order of tag elements, it should be as

<head>
<link rel="stylesheet" type="text/css" href="mystyle.css">
</head>

also make sure their are in correct directory (in your case together with JSP document)

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Exactly as to any other HTML based document, either use internal or external approach.

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Instead of using method="get" in the opening form tag use method="post" . This the basic of HTML you should already know, if not have look at w3schools for more examples.
One more thing, you should be sending the username and password for validation to servlet not another page from which you attempt to connect with database

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Thread moved to ASP.NET section

@kkeith29 - if you get across post and you think there is something wrong about it, please use the "Flag Bad Post" option to let moderators know about it. If the original poster made mistake in the forum he/she cannot move the post to correct forum, therefore if the person make a new thread it is just flooding forum that is not really welcomed.

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Moved to VB section

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

However, this will be an Ecommerce site, so I am unfamiliar with the following:

"Software Required: Hosting with PHP5x and MySQL5x; Apache only (on Unix/Freebsd/Linux/Windows); osCommerce runs on most server specific configurations ranging from dedicated servers to shared servers that utilize different PHP configurations such as register_globals (should be ON) and safe_mode restrictions"

What does this mean?

Above is set of recommended technologies to use, I think you picked up in some book or article
PHP - is scripting language (there are others too)
MySQL - is database
Apache - is server that supports/enables you to run the above technologies

I'm not sure how much time you wish to spend on learning and developing the site, but you would need to learn a lot about PHP & MySQL

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

overall of this nobody should boast in his skills, you'll just bringing down your self, don't compare if your not perfect.

Nobody is perfect, and if you happened to be perfect just make sure you not standing behind glass in the museum as their exposition ;)

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Some Java-Oracle examples

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

I did not get such problem, but this could be caused by the fact that you do not have closing sorted out. So when you press X in right top corner to shut down the window, the window will visually disappear but resources are still in use and that may do lot of strange things.
Add this line to JFrame declaration this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); .

One small advice, try to keep the whole element declaration together (example button-name, size, position, visibility, listeners) it will save you time searching for errors in the logic

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Please post your code so we may have look at it

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

EERM = Extended Entity Relationship Model

I would say auto increment column as if you want to keep track of next item number to be used you need to run extra query to get current number. Plus there are other thing you would have to take care from coding point of view

@tesuji, please drop that joke about "id-iots"

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Would be better if you attached source file (raw flash file not final swf) in zip or rar format so people may look at it if you do not mind.
Check on your server that flash file is saved in folder Flash as new.swf, keep in mind that it have to be with capital "F", lower wouldn't work (unix servers are sensitive with this)
As for reducing size, you may want to use external library where you store your resources, this will reduce the file size, however downside of this is longer time for loading

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

JButton.setVissible(boolean); the function is inherited from JComponent

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Then SQL Server Management Studio Express is your solution. Simply create back up of DB1, then create DB2 and restore data from DB1 there

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Of course it will, you declares connections as

Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mynewdatabase","root", "root123");

but you trying to call it as

st=connection.createStatement();

You should seriously look into some materials on Java web development Java EE5 Tutorial and JDBC Database Access may help you too. As I said previously accessing database from JSP is bad thing to do

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

If you did it in Java, then this task should be simple for you.

  1. Get location of excel file from user in JSP
  2. Pass file location from JSP to servlet
  3. Servlet is in general a Java class so you should have no problem to proceed from here
peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Ehmm you trying to get data from MySQL to Microsoft SQL Server 2005?

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

What DB you will be using MySQL, MS SQL, Oracle?

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Are you planning to do this once in while or this is non-stop requirement

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Google my friend is what you should do, like this

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster
  1. Accessing database from JSP is wrong thing to do, you should access DB only from servlet
  2. The PreparedStatement.executeUpdate(); should be st.executeUpdate();
  3. Closing connection on the end would be nice
peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

In my office...

A real helpful answer :@
It really let me know what browser you using.
Well consider this, your network admin may disabled some stuff so "busy" employees can not access it (for example email at yahoo, google, shopping at amazon, ebay etc). If your work require extensive search of internet ask your admin or your boss to lower security level for your account.

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Its not working on my computer...
Tel me whats the wrong???

Would be helpful if you provide your some pc specs so we do know what you use and this can also help Kkeith29 fix the issue if any there.
Beside I would be interested too, as in many posts you saying this or that does not work for you where others obviously have no problem at all. Are you trying to access these things from home/work/school/ public library/internet pub?

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

You are on discussion forum! Observe, learn and develop own forum based on your observation...

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

One more thing to add, setting up connection with database from JSP is bad thing to do. Learn to use servlets and then do JSF

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Here is tutorial how to set up Tomcat on Windows machine

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

You should commence your self to better internet search. Since 2005 Microsoft provide free version of they development tools that also include Visual Web Developer and they also have large database of topics/tutorials related to ASP

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Simple copy&paste of the class to project folder (PROJECT_DIRECTORY/PROJECT_NAME/src) in Window Explorer with refresh of Netbeans should do the trick

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Yes, they have to be in same directory

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

If you use import EasyIn.*; then this class must be in same directory as class in which one you wish to use EasyIn

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

first install dreamweaver in your system,
it will easy to edit image mapping

Dreamweaver is not all, secondly is not for free and installing trial version for such banality is silly

Code is OK, however you should swap name attribute for id attribute in start of map tag <map name="map"> , as id attribute is required where name is just optional. Do not forget to add links to locations where to go after mouse click as these are currently not set href="http://TBA" . If you not sure what you doing you can have look at w3schools example on this topic

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Dear Sir

I want to develop an application that will get the current market price of the stock using jsp.

Please can you be more specific on topic. More explanation would be nice

@stephen84s - if you not ready to help please do not leave such comments any more

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Have look at this topic on Sun forum

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Ehmm, what is the purpose in replying to post that is 6 months old and presumably what ever schoolwork it was, it should be submitted/failed by now?

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

You got the folder structure wrong. Here is basic structure of it http://www.daniweb.com/forums/post625873-6.html. Also you can learn more here .

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Simplest solution would be have database with table of user details with unique ID for each member. This would hold username and password at-least to ensure that voting member is who he/she say is. For each voting process I would create new table with members ID's and vote cats of Boolean type to see if the person already voted or not (not they selected vote option). Plus I would have table with vote options where each option will hold integer value that will be incremented depending on members vote. Is that understandable?

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

Did u try it out in a browser?

That thing would not even compile as it is missing MUST HAVE IT section. Therefore no point to discus browser deployment or Applet Viewer

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

I been told that if you can get Java application running in Visual J++ VS2005 and VS2008 should do the conversion for you. Reality, I never try it, I love Java too much...:*

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

I would advice embedded Derby/JavaDB
---
yap

Derby is still new, so I will not expect so much support on it. In Java will be good, but C# less likely

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

then create new post in Software Development > VB.NET section. And please give a proper problem description, not the one line statements like in this case

peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster

the integer division is done. so the result is in integer.
try select convert(numeric(5,2), 50)/100 OR
select 50.00/100.00

Another genius...