package dao;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;import bean.Org;import bean.Tree;public class UserDAO {public List getTree(String parentId) {try {Class.forName("com.mysql.jdbc.Driver");Connection conn = DriverManager.getConnection("jdbc:mysql://192.168.231.142:3306/manager", "root", "root");String sql = "select * from ext_tree where pid = " + parentId;PreparedStatement ps = conn.prepareStatement(sql);ResultSet rs = ps.executeQuery();List list = new ArrayList();while(rs.next()) {/*Org o = new Org();o.setId(rs.getInt("id"));o.setOname(rs.getString("oname"));o.setPid(rs.getInt("pid"));o.setDescript(rs.getString("descript"));o.setLeaf(rs.getInt("leaf"));list.add(o);*/Tree t = new Tree();t.setId(rs.getInt("id"));t.setPid(rs.getInt("pid"));t.setText(rs.getString("text"));list.add(t);}return list;} catch (SQLException e) {e.printStackTrace();} catch (ClassNotFoundException e) {e.printStackTrace();}return null;}public boolean login(String username, String pwd) {try {Class.forName("com.mysql.jdbc.Driver");Connection conn = DriverManager.getConnection("jdbc:mysql://192.168.231.143:3306/manager", "root", "root");String sql = "select * from ext_user where username = " + username + " and pwd = " + pwd;System.out.println(sql);PreparedStatement ps = conn.prepareStatement(sql);ResultSet rs = ps.executeQuery();if(rs.next()) {return true;}} catch (SQLException e) {e.printStackTrace();} catch (ClassNotFoundException e) {e.printStackTrace();}return false;}}