Believe me, weight training is not going to turn you into Hulk Hogan over night. It takes time, discipline, hard training, and big eating to get bulky.
I think you should start off by doing a routine consisting of bodyweight exercises to build up some stabilizer strength and condition your body before getting into a resistance training regimen. Try doing a few sets pushups, squats, chinups, and situps a few times per week for a couple of weeks before you get into resistance training. Hyperextensions would be great too if you have access to an apparatus to do them.
Once you finish your initial preparation phase, you should start by using fairly light weight (12-15 repetitions) for a couple of weeks, and using all compound free weight exercises. Here is the routine that I suggest to beginners, but start with 12-15 repetitions:
Deadlifts 2 x 8-12
Olympic Squats 2 x 8-12
Bent Rows 2 x 8-12
Chinups 2 x 8-12
Bench Press 2 x 8-12
Military Press 2 x 8-12
Decline Situps 2 x 12-15
Hyperextensions 2 x 12-15
Standing Calf Raises 2 x 12-15
Do this three days per week, with at least one rest day in between each session. Make sure your form is really good on these exercises. Don't forget to do warmups. This site has a lot of good videos and exercise explanations:
http://www.bsu.edu/webapps/strengthlab/home.htm