jdbc的增删改查与DBUtil工具类的编写

查询

package org.zhangsan.test;
//增
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class SlectTest {

	/**
	 * @param args
	 * @throws ClassNotFoundException 
	 * @throws SQLException 
	 */
	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		Connection conn = DBUtil.getConn();
		String sql = "select from * student "; 
		PreparedStatement ps = conn.prepareStatement(sql);
		ResultSet rs = ps . executeQuery();
		while (rs.next()) {
			System.out.println("编号"+rs.getInt("id")+
					"姓名"+rs.getString("name")+
					"年龄"+rs.getInt("age"));
			
		}
		
		DBUtil.close(rs,ps,conn);
	}

}

插入

package org.zhangsan.test;

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

public class InsertTest {

	/**
	 * @param args
	 * @throws ClassNotFoundException 
	 * @throws SQLException 
	 */
	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		Connection conn = DBUtil.getConn();
		String sql = "instert into student (name, age)values(张三,18)"; 
		PreparedStatement ps = conn.prepareStatement(sql);
		int count = ps . executeUpdate();
		if (count>0) {
			System.out.println("插入成功!");
		} else {
			System.out.println("插入失敗！!");
		}
		DBUtil.close(conn,ps,null );
	}

}

**

删除

**

package org.zhangsan.test;

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

public class DeleteTest {

	/**
	 * @param args
	 * @throws ClassNotFoundException 
	 * @throws SQLException 
	 */
	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		Connection conn = DBUtil.getConn();
		String sql = "Delete  from student  where name='张三'"; 
		PreparedStatement ps = conn.prepareStatement(sql);
		int count = ps . executeUpdate();
		if (count>0) {
			System.out.println("删除成功!");
		} else {
			System.out.println("删除失败！");
		}
		DBUtil.close(conn,ps,null);
	}

}

**

修改

**

package org.zhangsan.test;

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

public class UpdateTest {

	/**
	 * @param arg
	 * @throws ClassNotFoundException 
	 * @throws SQLException 
	 */
	public static void main(String[] args) throws ClassNotFoundException, SQLException {
		Connection conn = DBUtil.getConn();
		String sql = "Update  student  set name='张三'where name = '李四'"; 
		PreparedStatement ps = conn.prepareStatement(sql);
		int count = ps . executeUpdate();
		if (count>0) {
			System.out.println("修改成功!");
		} else {
			System.out.println("修改失败！");
		}
		
		DBUtil.close(conn,ps,null);
	}

}


**

## DBUtil

**
package org.chenao.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) {
		// TODO Auto-generated catch block
		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 (ps!=null) {
			ps .close();
		}
			
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}
	}