JDBCUtils工具类

JDBCUtils

package com.ls.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class JDBCUtils {
	private JDBCUtils() {
	}
	public static Connection getConnection() {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			String url="jdbc:mysql://localhost:3306/jtdb";
			String user="root";
			String password="root";
			Connection conn=
					DriverManager.getConnection(url, user, password);
			return conn;
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return null;
	}
	public static void close(
			ResultSet rs,
			Statement st,
			Connection conn
			) {
		if(rs!=null) {
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}finally {
             rs=null;
			}
		}
		if(st!=null) {
			try {
				st.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}finally {
				st=null;
			}
		}
		if(conn!=null) {
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}finally {
				conn = null;
			}
		}

	}

}

package com.ls.test;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.junit.Test;
import com.ls.util.JDBCUtils;

public class UtilsTest {
	
	//单元测试
	@Test
	public void utils() {
		ResultSet rs = null;
		Statement st = null;
		Connection conn = null;
		try {
			conn = JDBCUtils.getConnection();
			st = conn.createStatement();
			String sql="select * from dept";
			rs = st.executeQuery(sql);
			
			while(rs.next()) {
				String id = rs.getString(1);
				String name=rs.getString("name");
				
				System.out.println(id+name);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
		 JDBCUtils.close(rs, st, conn);	
		}
	}

}

package cn.tedu.login;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;



import cn.tedu.util.JDBCUtils;

/*
 * 这个类用来模拟用户登陆
 */

public class LoginUser {
	//1.提供
    public static void main(String[] args) {
    	Scanner sc=new Scanner(System.in);
    	//接收用户输入的用户名
		System.out.println("请输入用户名：");
		 String name = sc.nextLine();
		 //接收用户输入的密码
		System.out.println("请输入密码：");
		String pwd = sc.nextLine();
		
		//去user表用户名和密码查询数据
		login(name,pwd);
	}
    //2.提供login方法，用来利用jdbc的技术查询用户名
	private static void login(String name,String pwd) {
		Connection conn = null;
		//Statement st = null;
		ResultSet rs = null;
		PreparedStatement ps = null;
		try {
			//1.注册驱动，2.获取数据库的连接
			conn=JDBCUtils.getConnection();
			//3.获取传输器
			//st =conn.createStatement();
			//SQL中包含着 ?的，叫做SQL骨架
			//？叫做占位符
			String sql="select * from user where username=? and password1=?";
			ps = conn.prepareStatement(sql);
			
			//设置参数 1.第一个参数必须和问号的顺序一致
			//2.第二值参数指定问号的值
			ps.setString(1, name);
			ps.setString(2, pwd);
			//4.执行SQL
		  rs=ps.executeQuery();
			//String sql=
		//"select * from user where username='"+name+"'and password1='"+pwd+"'";
			
			//rs=st.executeQuery(sql);
		
			//5.遍历结果集
			//如果rs有值，从数据库中查询到了记录时登录成功
			if(rs.next()) {
				System.out.println("恭喜您，登录成功！");
			}else {
				//如果没有查询到记录
				System.out.println("您输入的用户名或密码错误！");
			}
			
		} catch (SQLException e) {
			
			e.printStackTrace();
		}finally {
			
			//6.释放资源
			JDBCUtils.close(rs, ps, conn);
		}
		
	}
}