链接mysql数据库

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;
	}

}