java数据库连接JDBC和MVC

1 JDBCutil.java

package www.chinasofiti.eex.jdbcutil;

import java.sql.Connection;

import java.sql.DriverManager;

public class JDBCutil {

public static final String DRIVER = "oracle.jdbc.driver.OracleDriver";

public static final String URL="jdbc:oracle:thin:@192.168.80.49:1521:XE";

public static final String USER="SCOTT";

public static final String PASSWORD="TIGER";

public static Connection conn;

public JDBCutil(){

}

public static Connection getConnection() throws Exception{

Class.forName(DRIVER);//加载驱动

conn=DriverManager.getConnection(URL,USER,PASSWORD);//链接数据库

System.out.println(conn);

System.out.println("数据库链接成功");

return conn;

}

// public static void main(String[]args){

// try {

// getConnection();

// } catch (Exception e) {

// // TODO Auto-generated catch block

// e.printStackTrace();

// }

// }

}

2 UserService.java

package com.movobike.service;

public interface UserService {

public void regist() throws Exception;

public boolean login() throws Exception;

public void start() throws Exception;//开锁

public void recharge() throws Exception;

public void getStartTime()throws Exception;//计时开始

public void getStopTime() throws Exception;//结束计时}

3 UserServiceImpl.java

package com.movobike.service;

import java.text.SimpleDateFormat;

import java.util.Scanner;

import erDao;

import erDaoImpl;

import java.sql.Date;

import java.text.*;

public class UserServiceImple implements UserService{

Boolean flag;

UserDao ud=new UserDaoImpl();

public static long pwd;

public static int money;

long numberID;

java.util.Date date = new java.util.Date();

long datetime=date.getTime();

java.sql.Date dateSql= new java.sql.Date(datetime);

public void regist() throws Exception{//注册函数

System.out.println("请输入您的手机号来进行注册");

Scanner scan = new Scanner(System.in);

long numberID = scan.nextLong();//对用户输入的账号进行接受。

System.out.println("请输入您的密码");

long password = scan.nextLong();//对用户输入的密码进行接受，但不判断。

flag=ud.DaoRegist(numberID, password);

if (flag) {

System.out.println("此号码已被注册，请直接登录！");

}else{

System.out.println("恭喜您注册成功，发个红包呗！！！！！");

}

}

public boolean login () throws Exception {//登录函数

System.out.println("请输入您的手机号登录");

Scanner scan = new Scanner(System.in);

numberID = scan.nextLong();//对用户输入的账号进行接受。

System.out.println("请输入您的密码登录");

long password = scan.nextLong();//对用户输入的密码进行接受。

flag=ud.DaoLogin(numberID, password);

if(flag){//调用dao层方法进行判断

System.out.println("登录成功");

}else{

System.out.println("账户或密码有误");

}

return flag;

}