增删改查和DBUtil

package org.text.modle;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class work1 {

	/**
	 * @param args
	 * @throws ClassNotFoundException 
	 * @throws SQLException 
	 */
	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		// TODO Auto-generated method stub
		//1.加载驱动程序(项目中添加驱动包)
		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		//2.使用DriverManger连接数据库
		Connection conn = DriverManager.getConnection(
				"jdbc:sqlserver://localhost:1433;databaseName=MyDB","sa","1");
				
		//3.准备一个sql语句
		String sql="select * from student";
		//4.准备一个和数据库打交道的preparedStatment
		PreparedStatement ps=conn.prepareStatement(sql);
		//5.使用ResultSet 接受ps执行的结果
		ResultSet rs = ps.executeQuery();
		//6:数据的展示
		while(rs.next()){
			System.out.println(rs.getString("name"));
			
		}
		//7.资源的关闭
		rs.close();
		ps.close();
		conn.close();
		
		

	}

}

package org.text.modle;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class work2 {

	/**
	 * @param args
	 * @throws ClassNotFoundException 
	 * @throws SQLException 
	 */
	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		// TODO Auto-generated method stub
		//1.加载驱动程序(项目中添加驱动包)
		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		//2.使用DriverManger连接数据库
		Connection conn = DriverManager.getConnection(
				"jdbc:sqlserver://localhost:1433;databaseName=MyDB","sa","1");
				
		//3.准备一个sql语句
		String sql="insert into student(name,age)values ('haoming',18)";
		//4.准备一个和数据库打交道的preparedStatment
		PreparedStatement ps=conn.prepareStatement(sql);
		//5.使用ResultSet 接受ps执行的结果
		int count = ps.executeUpdate();
		//6:数据的展示
		if(count>0){
			System.out.println("插入成功!");
		}else{
			System.out.println("插入失败!");
		}
		//7.资源的关闭
		ps.close();
		conn.close();
		
		

	}

}

package org.text.modle;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class work3 {

	/**
	 * @param args
	 * @throws ClassNotFoundException 
	 * @throws SQLException 
	 */
	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		// TODO Auto-generated method stub
		//1.加载驱动程序(项目中添加驱动包)
		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		//2.使用DriverManger连接数据库
		Connection conn = DriverManager.getConnection(
				"jdbc:sqlserver://localhost:1433;databaseName=MyDB","sa","1");
				
		//3.准备一个sql语句
		String sql="delate from student where id=2";
		//4.准备一个和数据库打交道的preparedStatment
		PreparedStatement ps=conn.prepareStatement(sql);
		//5.使用ResultSet 接受ps执行的结果
		int count = ps.executeUpdate();
		//6:数据的展示
		if(count>0){
			System.out.println("删除成功!");
		}else{
			System.out.println("删除失败!");
		}
		//7.资源的关闭
		ps.close();
		conn.close();
		
		

	}

}

 

package org.text.modle;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class work4 {

	/**
	 * @param args
	 * @throws ClassNotFoundException 
	 * @throws SQLException 
	 */
	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		// TODO Auto-generated method stub
		//1.加载驱动程序(项目中添加驱动包)
		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		//2.使用DriverManger连接数据库
		Connection conn = DriverManager.getConnection(
				"jdbc:sqlserver://localhost:1433;databaseName=MyDB","sa","1");
				
		//3.准备一个sql语句
		String sql="update student set age ="+18+" where id=5";
		//4.准备一个和数据库打交道的preparedStatment
		PreparedStatement ps=conn.prepareStatement(sql);
		//5.使用ResultSet 接受ps执行的结果
		int count = ps.executeUpdate();
		//6:数据的展示
		if(count>0){
			System.out.println("修改成功!");
		}else{
			System.out.println("修改失败!");
		}
		//7.资源的关闭
		ps.close();
		conn.close();
		
		

	}

}

 

package org.Ming.util;

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

public class DBUtil {

	 static  {
			try {
				Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			} catch (ClassNotFoundException e) {
				e.printStackTrace();
			}
			
			}
		 
		 public static Connection getconn(){
				Connection conn = null;
				 try {
					conn = DriverManager.getConnection(
							"jdbc:sqlserver://localhost:1433;databaseName=MyDB","sa","1");
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				return conn;
			
		 }	
			public static void close(Connection conn,PreparedStatement ps,ResultSet rs){
				try{
					if(conn != null)
						conn.close();
				}catch(SQLException e){
					e.printStackTrace();
				}
				try{
					if(rs !=null)
						rs.close();
				}catch(SQLException e){
					e.printStackTrace();
				}
				try{
					if(rs !=null)
						rs.close();
				}catch(SQLException e){
					e.printStackTrace();
		}
			}
	}

 

增删改查和DBUtil