Javaclass 链接数据库（初识JDBC）

Javaclass链接数据库Mysql（没有使用框架）

package BaseDao;

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

public class getConnection {
	
	static Connection con=null;
	
	public static Connection Opencon(){
	try {
		Class.forName("com.mysql.jdbc.Driver");
		con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");
	} catch (ClassNotFoundException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	
	
	return con;
} 

	public static void CloseJbdc(Connection Opencon,Statement st){
	
	try {
		if(st!=null){
			st.close();
		}else if(Opencon!=null){
			Opencon.close();
		}
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
}

}

---

---

service写sql语句

package Service;

import Entity.User;

public interface UserService {
	
	public int Register (String name,String pwd);
	
	public User Login(String name,String pwd);

}

impl层 实现service方法

package Service.Impl;

import Dao.UserDao;
import Dao.Impl.UserDaoImpl;
import Entity.User;
import Service.UserService;

public class UserServiceImpl implements UserService{
	UserDao ud=new UserDaoImpl();

	@Override
	public int Register(String name, String pwd) {
		// TODO Auto-generated method stub
		String sql="insert into user(name,pwd) values('"+name+"','"+pwd+"')";
		int a=ud.Register(sql);
		return a;
	}

	@Override
	public User Login(String name, String pwd) {
		// TODO Auto-generated method stub
		String sql="select * from user where name=? and pwd=?";
		User u=ud.Login(sql, name, pwd);
		return u;
	}

}

---

dao层实现与database链接

package Dao;

import Entity.User;

public interface UserDao {
	public int Register(String sql);
	
	public User Login(String sql , String  name, String pwd);

}

---

package Dao.Impl;

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

import Utils.Getcon;



import Dao.UserDao;
import Entity.User;

public class UserDaoImpl implements UserDao{
	Connection con=null;
	PreparedStatement ps=null;
	Statement st=null;
	ResultSet rs=null;
	

	public int Register(String sql) {
		// TODO Auto-generated method stub
		int a=0;
		try {
			con=Getcon.Opencon();
			ps=con.prepareStatement(sql);
			a=ps.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return a;
	}

	public User Login(String sql, String name, String pwd) {
		// TODO Auto-generated method stub
		User u=new User();
		try {
			con=Getcon.Opencon();
			ps=con.prepareStatement(sql);
			ps.setString(1, name);
			ps.setString(2, pwd);
			rs=ps.executeQuery();
			if(rs.next()){
				u.setPwd(rs.getString("pwd"));
				u.setName(rs.getString("name"));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return u;
	}
	

}