jsp大作业总结（1）--连接数据库

平台是myeclips10  tomacate6.5 mysql5.5

 

import java.sql.*;
public class DBConnect {
 public static Connection getConnection(){
  String url = "jdbc:mysql://localhost:3306/test";
  String user = "root";
  String pwd = "123456";
  Connection con = null;
  try{
   Class.forName("com.mysql.jdbc.Driver").newInstance();
   con = DriverManager.getConnection(url,user,pwd);
   System.out.println("ok");
  }catch(Exception e){
    e.getMessage();
  }
  return con;
 }

 

package com.nba.db;
import com.mysql.jdbc.Driver;
import java.sql.*;
public class UserRegister
{
        private UserBean userBean;
        private Connection con;
        //获得数据库连接。
        public UserRegister()
        {

             String url="jdbc:mysql://localhost/"+"chao"+"?user="+"root"+"&password="+"123456";

            try
            {

                Class.forName("com.mysql.jdbc.Driver").newInstance();
                        con = DriverManager.getConnection(url);
                }
                catch(Exception e)
                {
                        e.printStackTrace();
                }

        }
        //设置待注册的用户信息。
        public void setUserBean(UserBean userBean)
        {
                this.userBean=userBean;
        }
        //进行注册
        public void regist() throws Exception
        {
                String reg="insert into userinfo(userid,password)  values(?,?)";

                try
                {
                        PreparedStatement pstmt=con.prepareStatement(reg);
                        pstmt.setString(1,userBean.getUserId());
                        pstmt.setString(2,userBean.getPassword());
                        pstmt.executeUpdate();
                }
                catch(Exception e)
                {
                        e.printStackTrace();
                        throw e;
                }

        }
}