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 https://www.360docs.net/doc/6613751573.html,erDao;

import https://www.360docs.net/doc/6613751573.html,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;

}

public void start() throws Exception{//开锁计费函数。

System.out.println("请输入您要骑行的车辆号码");

Scanner scan = new Scanner(System.in);

long bikeNumber = scan.nextLong();

pwd=ud.getPwd(bikeNumber);

System.out.println("此车密码为："+pwd);

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

long bikeWord = scan.nextLong();

if(bikeWord==pwd){

System.out.println("开锁成功，祝您旅途愉快");

getStartTime();

System.out.println("输入1还车");

int reback=scan.nextInt();

if(reback==1){

getStopTime();

System.out.println("车以归还，停止计时");

}

}else{

System.out.println("不好意思，您输入的有误，请看清楚之后在输入");

}

}

public void recharge() throws Exception{

System.out.println("请输入充值金额￥");

Scanner scan = new Scanner(System.in);

int money = scan.nextInt();

flag=ud.DaoRecharge(money,numberID);

if(flag){

System.out.println("恭喜您充值成功！");

}

}

public void getStartTime()throws Exception{

System.out.println(dateSql);

flag=ud.DaoStartTimes(dateSql,numberID);

if(flag){

System.out.println("已经开始计时");

}

}

public void getStopTime() throws Exception{

ud.DaoStopTimes(dateSql,numberID);

};

}

4 UserDao.java

package com.movobike.dao;

import java.sql.Date;

public interface UserDao {

public boolean DaoRegist(long id,long pwd) throws Exception;

public boolean DaoLogin(long id,long pwd) throws Exception;

public long getPwd(long bkId) throws Exception;//获取密码

public boolean DaoRecharge(int money,long id) throws Exception;//充值

public boolean DaoStartTimes(Date nowtime,long id)throws Exception;//开始骑行时间

public boolean DaoStopTimes(Date nowtime,long id)throws Exception;//还车时间

}

5 UserDao.java

package com.movobike.dao;

import java.sql.Statement;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.Date;

import java.sql.PreparedStatement;

import www.chinasofiti.eex.jdbcutil.JDBCutil;

public class UserDaoImpl implements UserDao {

private static Connection conn;

private static PreparedStatement s;

private static Statement ss;

private static ResultSet rs;

public static boolean flag;

public static long bkPwd;

@Override

public boolean DaoRegist(long id,long pwd) throws Exception{ String sql1="select * from user_bike where id="+id;

String sql2="insert into user_bike

(id,password)values("+id+","+pwd+")";

UserDaoImpl udi=new UserDaoImpl();

conn=JDBCutil.getConnection();

ss=conn.createStatement();

rs=ss.executeQuery(sql1);//执行

flag=rs.next();

if(flag){

}else{

ss.execute(sql2);

};

return flag;

}

@Override

public boolean DaoLogin(long id,long pwd) throws Exception { // TODO Auto-generated method stub

String sql="select * from user_bike where id=? and password=?";

conn=JDBCutil.getConnection();

s= conn.prepareStatement(sql);

s.setLong(1, id);

s.setLong(2, pwd);

rs=s.executeQuery();

flag=rs.next();

return flag;

}

public long getPwd(long bkId) throws Exception{

String sql="select bike_password from bike where id=?";

conn=JDBCutil.getConnection();

s= conn.prepareStatement(sql);

s.setLong(1, bkId);

rs=s.executeQuery();

if(rs.next()){

bkPwd=rs.getLong(1);

}

return bkPwd;

}

public boolean DaoRecharge(int money,long id) throws Exception { String sql="update user_bike set balance=balance+?"+"where id=?";

conn=JDBCutil.getConnection();

s= conn.prepareStatement(sql);

s.setInt(1, money);

s.setLong(2, id);

rs=s.executeQuery();

flag=rs.next();

return flag;

};

public boolean DaoStartTimes(Date nowtime,long id)throws Exception{ String sql="update bike set begin_time=?"+"where id=?";

conn=JDBCutil.getConnection();

s= conn.prepareStatement(sql);

s.setDate(1, nowtime);

s.setLong(2, id);

rs=s.executeQuery();

flag=rs.next();

return flag;

}

public boolean DaoStopTimes(Date nowtime,long id)throws Exception{ String sql="update bike set _time=?"+"where id=?";

conn=JDBCutil.getConnection();

s= conn.prepareStatement(sql);

s.setDate(1, nowtime);

s.setLong(2, id);

rs=s.executeQuery();

flag=rs.next();

return flag;

}

}

6 UserTest.java

package test;

import java.util.Scanner;

import https://www.360docs.net/doc/6613751573.html,erServiceImple;

public class UserTest {

static UserServiceImple userServiceImple=new UserServiceImple(); static Scanner scanner=new Scanner(System.in);

public static void main(String[] args) throws Exception {

System.err.println("登录请输入：1\r\n注册请输入：2");

int num=scanner.nextInt();

if (num==1) {// num=1登录

if(userServiceImple.login()){

choice();

}

}else {// 注册并登录

userServiceImple.regist();

System.out.println("正在登录，请稍候...");

Thread.sleep(2000);

userServiceImple.login();

while (true) {

choice();

}

}

}

public static void choice() throws Exception{

System.err.println("骑车请输入：1\r\n充值请输入：2");

int num2=scanner.nextInt();

switch (num2) {

case 1:

userServiceImple.start();

break;

case 2:

userServiceImple.recharge();

break;

}

}

}