jdbc测试

增删改：

package jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.PreparedStatement;
public class test {
	//jdbc:microsoft.sqlsever://localhost:1433:DatabassName=test
	private static final String url = "jdbc:sqlserver://localhost:1433;DatabaseName=test";
	private static final String user = "sa";
	private static final String password = "123";
	private static Statement stmt;
	private static PreparedStatement pstmt;
	@SuppressWarnings("null")
	public static void up(){
		// TODO Auto-generated method stub
		Connection connection =  null;
		PreparedStatement pstmt = null;
		try {
		//a、导入驱动
		//Class.forName("com.mysql.cj.jdbc.Driver");//加载具体驱动(mysql)
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		//b、建立连接
		 connection = DriverManager.getConnection(url, user, password);

/*Statement
		//		c、执行sql语句
		Statement stmt = connection1.createStatement() ;
//增
//		String sql = "insert into test values(1,'dsd',44)";
//删
//		String sql =" delete FROM test where num= 1";
//改
		String sql =" update test set num=3 where name='dsd'";
		int count = stmt.executeUpdate(sql);	  */
		
		
		
		//prepaStatement
		//String sql="insert into test values(3,'ad',42)";//普通
		String sql="insert into test values(?,?,?)";//预编码
		pstmt = connection.prepareStatement(sql);
		pstmt.setInt(1, 4);//学号
		pstmt.setString(2, "zzs");//姓名
		pstmt.setInt(3, 36);//年龄
		int count = pstmt.executeUpdate();
		if(count > 0) {
			System.out.println("操作完成");
		}
		}catch(ClassNotFoundException e) {
			e.printStackTrace();
		}catch(SQLException e) { 
			e.printStackTrace();
		}catch(Exception e) {
			e.printStackTrace();
		}finally {
			try {
			if(stmt!= null)stmt.close();	
			if(connection!= null)connection.close();
			}catch(SQLException e){
				e.printStackTrace();
			}
		}
		
	}


public static void main(String[] args) {
	up();
}

}

 查询：

package jdbc;

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

public class rquest {

        // TODO Auto-generated method stub
        private static final String url = "jdbc:sqlserver://localhost:1433;DatabaseName=test";
        private static final String user = "sa";
        private static final String password = "123";
        private static Statement stmt;
        private static PreparedStatement pstmt;
        public static void  up(){
            // TODO Auto-generated method stub
            Connection connection =  null;
            ResultSet rs = null;
            PreparedStatement pstmt= null;
            try {
            //a、导入驱动
            //Class.forName("com.mysql.cj.jdbc.Driver");//加载具体驱动(mysql)
                Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            //b、建立连接
            connection = DriverManager.getConnection(url, user, password);
String sql;
            //            z执行sql语句
//模糊查询A,B才用    stmt = connection1.createStatement() ;
//            String sql ="select * from test";
//模糊查询A 根据相关信息查询，比如所含字母
//            String sql = "select *from test where name like '%s%'";
//模糊查询B
            /*String Name = "s" ;
            String sql ="select * from test where name like '%"+Name+"%'";*/    
            //String sql = "select num,name,age from test";
//            rs = stmt.executeQuery(sql);        
//            模糊查询c    ，prepareStatemnt

            sql ="select * from test where name like ?";        
            pstmt = connection.prepareStatement(sql);
            pstmt.setString(1, "%z%");
            rs = pstmt.executeQuery();
            while(rs.next()) {
                int num = rs.getInt("num");
                String name = rs.getString("name");
                int age = rs.getInt("age");
                System.out.println("num---"+num+"//name---"+name+"//age----"+age);
            }
            }catch(SQLException e) {
                e.printStackTrace();
            }catch(ClassNotFoundException e) {
                e.printStackTrace();
            }catch(Exception e) {
                e.printStackTrace();
            }finally {
                try {
                if(rs!=null)rs.close();
                if(stmt!= null)stmt.close();    
                if(connection!= null)connection.close();
                }catch(SQLException e){
                    e.printStackTrace();
                }
            }
            
        }
    

public static void main(String[] args) {
    up();
    
}
}