数据库实验：用js实现sql数据库的增删查改，最简洁版本

sql数据库

实现成果

代码实现

BaseDao.java

package Base.lyc.dao;
//数据库连接
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class BaseDao {
   


         String driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
         String url="jdbc:sqlserver://localhost:1433;DatabaseName=615";
         String  userno="sa";
         String pwd="123456";
      
       /* try
        {
            Class.forName(driverName);
            Connection dbConn=DriverManager.getConnection(dbURL,userName,userPwd);
            System.out.println("success!");
         }
          catch(Exception e)
       {
            e.printStackTrace();
            System.out.print("fail!");
       }*/
     	public Connection conn;
    	public PreparedStatement ps;
    	public ResultSet rs;
    	
    	public Connection getConn() {
   
    		try {
   
    			Class.forName(driver);
    			this.conn=DriverManager.getConnection(url, userno, pwd);
    			return conn;
    		} catch (Exception e) {
   
    			e.printStackTrace();
    		}
    		return null;
    	}
   	public static void main(String[] args)
    	{
   
    		BaseDao bd= new BaseDao();
    		
    		 System.out.println(bd.getConn());
    	}
}

UserDao.java

package Base.lyc.dao;
//类的具体实现
import java.sql.SQLException;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import Base.lyc.dao.*;

import com.lyc.model.User;

public class UserDao extends BaseDao{
   
//查询
	public List<User> findUserList() {
   
				String sql="select * from member ";
				
				try {
   
					this.conn = this.getConn();
					this.ps = conn.prepareStatement(sql);
					this.rs = ps.executeQuery();
					List<User> list = new ArrayList<User>();
					
					while(rs.next()) {
   
						String name = rs.getString("name");
						int age = rs.getInt("age");
						String sexx = rs.getString("sexx");
						String dept  = rs.getString("dept");
						
						User user=new User();
						user.setDept(dept);
						user.setAge(age);
						user.setSexx(sexx);
						user.setName(name);
						
						
						list.add(user);
						
					}
					return list; 
					
				} catch (SQLException e) {
   
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
		// TODO Auto-generated method stub
	return null;
	}
	
	
	
	public List<User> findWs() {
   
		String sql="select * from ws ";
		
		try {
   
			this.conn = this.getConn();
			this.ps = conn.prepareStatement(sql);
			this.rs = ps.executeQuery();
			List<User> list = new ArrayList<User>();
			
			while(rs.next()) {
   
				String date = rs.getString("date");
				String name = rs.getString("name");
				String grade = rs.getString("grade");
				String remarks  = rs.getString("remarks");
				
				User user=new User();
				user.setDate(date);
				user.setGrade(grade);
				user.setRemarks(remarks);
				user.setName(name);
				
				
				list.add(user);
				
			}
			return list; 
			
		} catch (SQLException e) {
   
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
// TODO Auto-generated method stub
return null;
}
	
	public List<User> findUserListByUserNo(String usernoLike) {
   
		// TODO Auto-generated method stub
		String sql="select * from member where name like '%"+usernoLike+"%'";
		
		try {
   
			this.conn = this.getConn();
			this.ps = conn.prepareStatement(sql);
			this.rs = ps.executeQuery();
			List<User> list = new ArrayList<User>();
			

			while(rs.next()) {
   
				String name = rs.getString("name");
				int age = rs.getInt("age");
				String sexx = rs.getString("sexx");
				String dept  = rs.